How to Solve “No Data” Charts on Google Looker Studio in 6 Steps—and why it happens
To know why Looker Studio charts show “No data” and solve it, verify your connections (data sources, accounts, permissions, and authorizations), validate the connection has actual data for the selected date range, verify applied filters, switch to different chart types, and test multiple metrics and dimensions. If it doesn’t work, reach out to Porter Metrics […]
How to copy a Looker Studio Report Template
Learn how to copy any Looker Studio template with this complete step-by-step guide. We made a ‘how to video’ in case you prefer to see how we do it! Now, here’s the step-by-step guide. 1. Choose a Looker Studio Template Go to the main menu in Porter Metrics and open the Template Gallery Browse through […]
Import Mailchimp to Google Sheets: tutorial & templates (2023)
To Import Mailchimp data to Google Sheets, download the Mailchimp to Sheets add-on, connect your Google account, connect your Mailchimp accounts, choose metrics, dimensions (or breakdowns), and date ranges, and schedule hourly, daily, or weekly data refreshes to monitor your email marketing performance. By the end of the tutorial, you’ll know: Free and paid ways […]
Import Shopify data to Google Sheets: tutorial & templates (2023)
To Import Shopify data to Google Sheets, download the Shopify to Sheets add-on, connect your Shopify account, select stores, set a conversion window, metrics, dimensions (or breakdowns), and date ranges, and schedule hourly, daily, or weekly data refreshes to monitor your Shopify campaigns performance and automate your marketing reports. By the end of the tutorial, […]
Import HubSpot to Google Sheets: tutorial & templates (2023)
To Import HubSpot data to Google Sheets, download the HubSpot to Sheets add-on, connect your Google account, connect your HubSpot account, select accounts, metrics, dimensions (or breakdowns), and date ranges, and schedule hourly, daily, or weekly data refreshes to monitor your website and marketing performance. By the end of the tutorial, you’ll know: Free and […]
Import Google Business Profile data to Google Sheets: tutorial & templates (2023)
To Import Google Business Profile data to Google Sheets, download the Google Business Profile to Sheets add-on, connect your Google account, select locations, metrics, dimensions (or breakdowns), and date ranges, and schedule hourly, daily, or weekly data refreshes to monitor your Local SEO performance. By the end of the tutorial, you’ll know: Free and paid […]
Import Google Analytics 4 to Google Sheets: tutorial & templates (2023)
To Import Google Analytics 4 data to Google Sheets, download the Google Analytics 4 to Sheets add-on, connect your Google account, select properties and views, metrics, dimensions (or breakdowns), and date ranges, and schedule hourly, daily, or weekly data refreshes to monitor your website and marketing performance. By the end of the tutorial, you’ll know: […]
Import Facebook Competitors to Google Sheets: tutorial & templates (2023)
To Import Facebook public data (aka Facebook competitors) to Google Sheets, download the Facebook public data Competitors to Sheets add-on, connect your Facebook profile, select metrics, dimensions (or breakdowns), and date ranges, and schedule hourly, daily, or weekly data refreshes to monitor your competitors for social media competitive analysis. By the end of the tutorial, […]
Import Instagram Competitors data to Google Sheets: tutorial & templates (2023)
To Import Instagram Public data (aka Instagram Competitors) to Google Sheets, download the Instagram Public data Competitors to Sheets add-on, connect your Facebook profile, select metrics, dimensions (or breakdowns), and date ranges, and schedule hourly, daily, or weekly data refreshes to monitor your competitors for social media competitive analysis. By the end of the tutorial, […]
Import Twitter Analytics to Google Sheets: tutorial & templates (2023)
To Import Twitter Analytics data to Google Sheets, download the Twitter Analytics to Sheets add-on, connect your Twitter profiles, metrics, dimensions (or breakdowns), and date ranges, and schedule hourly, daily, or weekly data refreshes to monitor your Twitter Analytics campaigns performance and automate your Social media marketing reports. By the end of the tutorial, you’ll […]
