1. Home
  2. »
  3. Marketing Reporting and Analytics Comparisons and Review
  4. »
  5. Top 10 KPIs That You Should Be Tracking in 2023

Top 10 KPIs That You Should Be Tracking in 2023

We'll cover

Top 10 KPIs That You Should Be Tracking in 2023

How to Connect LinkedIn Pages to Google BigQuery

> Home Tutorials LinkedIn Pages to BigQuery LinkedIn Pages Google BigQuery Tutorial How to Connect LinkedIn Pages to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect LinkedIn Pages to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select LinkedIn Pages as data source and name your connection . 4 Authorize your LinkedIn profile to access your Company Pages. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or create new).

Read More »

How to Connect TikTok to Google BigQuery

> Home Tutorials TikTok to BigQuery TikTok Google BigQuery Tutorial How to Connect TikTok to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect TikTok to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select TikTok as data source and name your connection . 4 Authorize your TikTok profile to access your organic account data. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or create new). 7 Select metrics (e.g.,

Read More »

How to Connect Facebook Competitors to Google BigQuery

> Home Tutorials Facebook Competitors to BigQuery Facebook Competitors Google BigQuery Tutorial How to Connect Facebook Competitors to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Facebook Competitors to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Facebook Competitors as data source and name your connection . 4 Enter the competitor Page URLs you want to track (public data only). 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name

Read More »

How to Connect Instagram Competitors to Google BigQuery

> Home Tutorials Instagram Competitors to BigQuery Instagram Competitors Google BigQuery Tutorial How to Connect Instagram Competitors to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Instagram Competitors to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Instagram Competitors as data source and name your connection . 4 Enter the competitor Instagram profiles you want to track (public data only). 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name

Read More »

How to Connect Google Business Profile to Google BigQuery

> Home Tutorials Google Business Profile to BigQuery Google Business Profile Google BigQuery Tutorial How to Connect Google Business Profile to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Google Business Profile to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Google Business Profile as data source and name your connection . 4 Authorize your Google account to access your Business Profiles. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and

Read More »

How to Connect Google Analytics 4 to Google BigQuery

> Home Tutorials Google Analytics 4 to BigQuery Google Analytics 4 Google BigQuery Tutorial How to Connect Google Analytics 4 to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Google Analytics 4 to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Google Analytics 4 as data source and name your connection . 4 Authorize your Google account to access your GA4 properties. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and

Read More »

How to connect Meta Ads to Google BigQuery

> Home Tutorials Meta Ads to BigQuery Meta Ads Google BigQuery Tutorial How to Connect Meta Ads to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Meta Ads to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Meta Ads as data source and name your connection . 4 Authorize your Facebook profile to access your Ad Accounts. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or create new).

Read More »

How to Connect Google Search Console to Google BigQuery

> Home Tutorials Google Search Console to BigQuery Google Search Console Google BigQuery Tutorial How to Connect Google Search Console to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Google Search Console to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Google Search Console as data source and name your connection . 4 Authorize your Google account to access your Search Console properties. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset ,

Read More »

How to Connect Google Ads to Google BigQuery

> Home Tutorials Google Ads to BigQuery Google Ads Google BigQuery Tutorial How to Connect Google Ads to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Google Ads to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Google Ads as data source and name your connection . 4 Authorize your Google account to access your Google Ads accounts (individual or MCC). 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table

Read More »

How to Connect Shopify to Google BigQuery

> Home Tutorials Shopify to BigQuery Shopify Google BigQuery Tutorial How to Connect Shopify to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Shopify to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Shopify as data source and name your connection . 4 Connect your Shopify store via OAuth or custom app API key. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or create new). 7 Select metrics

Read More »

How to Connect LinkedIn Ads to Google BigQuery

> Home Tutorials LinkedIn Ads to BigQuery LinkedIn Ads Google BigQuery Tutorial How to Connect LinkedIn Ads to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect LinkedIn Ads to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select LinkedIn Ads as data source and name your connection . 4 Authorize your LinkedIn profile to access your Campaign Manager Ad Accounts. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or

Read More »

How to Connect Amazon Seller Central to Google BigQuery

> Home Tutorials Amazon Seller Central to BigQuery Amazon Seller Central Google BigQuery Tutorial How to Connect Amazon Seller Central to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Amazon Seller Central to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Amazon Seller Central as data source and name your connection . 4 Authorize your Amazon Seller account via SP-API credentials. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table

Read More »

How to Connect TikTok Ads to Google BigQuery

> Home Tutorials TikTok Ads to BigQuery TikTok Ads Google BigQuery Tutorial How to Connect TikTok Ads to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect TikTok Ads to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select TikTok Ads as data source and name your connection . 4 Authorize your TikTok for Business account to access your Advertiser accounts. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or

Read More »

How to Connect HubSpot to Google BigQuery

> Home Tutorials HubSpot to BigQuery HubSpot Google BigQuery Tutorial How to Connect HubSpot to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect HubSpot to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select HubSpot as data source and name your connection . 4 Authorize your HubSpot account via OAuth or Private App. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or create new). 7 Select metrics (e.g., spend)

Read More »

How to Connect X Ads to Google BigQuery

> Home Tutorials X Ads to BigQuery X Ads Google BigQuery Tutorial How to Connect X Ads to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect X Ads to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select X Ads as data source and name your connection . 4 Authorize your X (Twitter) account to access your Ads Manager. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or create

Read More »

How to Connect Klaviyo to Google BigQuery

> Home Tutorials Klaviyo to BigQuery Klaviyo Google BigQuery Tutorial How to Connect Klaviyo to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Klaviyo to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Klaviyo as data source and name your connection . 4 Connect your Klaviyo account using your Private API key. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or create new). 7 Select metrics (e.g., spend)

Read More »

How to Connect Microsoft Ads to Google BigQuery

> Home Tutorials Microsoft Ads to BigQuery Microsoft Ads Google BigQuery Tutorial How to Connect Microsoft Ads to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Microsoft Ads to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Microsoft Ads as data source and name your connection . 4 Authorize your Microsoft account to access your Bing Ads accounts. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or create

Read More »

How to Connect Mailchimp to Google BigQuery

> Home Tutorials Mailchimp to BigQuery Mailchimp Google BigQuery Tutorial How to Connect Mailchimp to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Mailchimp to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Mailchimp as data source and name your connection . 4 Authorize your Mailchimp account via OAuth. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or create new). 7 Select metrics (e.g., spend) and dimensions (e.g.,

Read More »

How to Connect Pinterest to Google BigQuery

> Home Tutorials Pinterest to BigQuery Pinterest Google BigQuery Tutorial How to Connect Pinterest to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect Pinterest to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select Pinterest as data source and name your connection . 4 Authorize your Pinterest Business account to access your Ad accounts. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or create new). 7 Select metrics (e.g.,

Read More »

How to Connect ActiveCampaign to Google BigQuery

> Home Tutorials ActiveCampaign to BigQuery ActiveCampaign Google BigQuery Tutorial How to Connect ActiveCampaign to Google BigQuery Juan Bello CEO – Porter Metrics Jan 30, 2026 15 min read To connect ActiveCampaign to Google BigQuery: 1 Log in with Google on portermetrics.com . 2 Select Google BigQuery as destination. 3 Select ActiveCampaign as data source and name your connection . 4 Connect your ActiveCampaign account using your API URL and key. 5 Authenticate BigQuery via Google login or Service Account. 6 Select Project ID , Dataset location , Dataset , and Table name (or create new). 7 Select metrics (e.g.,

Read More »

Meet the author

Picture of Juan Bello

Juan Bello

Juan Bello the co-founder and CEO of Porter Metrics, is a dedicated marketer who founded the company to help marketers make faster, data-driven decisions without the need for developers or wasting time and money⁠. He has a focus on helping marketing agencies and SMB marketing teams centralize and visualize their data on Looker Studio and Google Sheets without coding or complex setups.

Automate your marketing reporting in Looker Studio

no credit card required.