Connect Google Analytics 4 to Looker Studio for free: tutorial and templates
to connect Google Analytics 4 to Looker Studio, visit portermetrics.com, create a trial or free account, select single data source, and choose GA4. Sign in with your Google account linked to your GA4 property, grant access, select the desired account and property, and click Create report. Looker Studio will open and load your GA4 dashboard; […]
Connect Klaviyo to Looker Studio for free: tutorial and templates
To connect Klaviyo to Looker Studio, start by visiting powermetrics.com and sign up with the same Google account you use for Looker Studio. Create a new connection, select Klaviyo as your data source, and add your Klaviyo account by generating a private API key with read-only permissions from your Klaviyo Account Settings. Paste this key […]
Connect LinkedIn Pages to Looker Studio for free: tutorial and templates
To connect LinkedIn Pages to Google Looker Studio, go to Porter Metrics, start a free trial or use the free forever plan, and sign in with the same Google account you use for Looker Studio. Choose single data source, select LinkedIn Pages, authorize your LinkedIn account, allow access, then select one or more LinkedIn Pages […]
Connect ActiveCampaign to Looker Studio for free: tutorial and templates
To connect ActiveCampaign to Google Looker Studio, visit Porter Metrics, start a free trial or use the free plan, and sign in with your Google account. In Porter Metrics, go to the Connect section, select Single data source, choose ActiveCampaign, and click Add account. In your ActiveCampaign account, copy your account name, API URL, and […]
Connect Instagram to Looker Studio for free: tutorial and templates
To connect Instagram to Google Looker Studio with Porter Metrics, visit portermetrics.com, create a report and select Single data source, then choose Instagram Insights. Authorize your Facebook profile by clicking Add profile, opt in to all current and future pages, allow permissions, and confirm. After linking your Facebook profile, select the Instagram Business profiles you […]
How to Connect Meta Ads to Looker Studio for free: tutorial and templates
To connect Meta Ads to Google Looker Studio (formerly Data Studio), go to Create report (or to the Looker Studio community connectors gallery), Select single data source, as connection type, choose the Meta Ads integration by Porter Metrics, connect your Google account, connect your Facebook profile, choose your ad accounts, Click on Create report, and […]
4 ways to export and analyze Facebook Ads data on Google Sheets: tutorial & templates (2024)

To export Facebook Ads data to Google Sheets, download the Facebook Ads to Sheets add-on, connect your Facebook profile, select ad accounts, set a conversion window and date, metrics, dimensions (or breakdowns), and date ranges, and schedule hourly, daily, or weekly data refreshes to monitor your Facebook Ads campaigns performance and automate your marketing reports. […]
How to use Google Looker Studio complete tutorial (2024)

In this Google Looker Studio tutorial, we will go through all the steps needed to automate your reports and tell stories with actionable visualizations: I also made a complete YouTube video tutorial you can watch: Why does Google Looker Studio matter? We’ve already published an article about why businesses—especially marketers—should learn Google Looker Studio, data […]
How to Create Calculated Fields on Looker Studio (2024)

Calculated fields enable you to create new metrics and dimensions from existing data, allowing you to create insightful reports based on your use case and specific data sources. The result? More insightful analysis and better decision-making with the help of chart-level calculated fields. In this tutorial, you will learn how to create custom fields, formulas, […]
How to Use Regex on Looker Studio: Regular Expressions with Examples for Marketers

In this article, we’ll show you how to use REGEX on Looker Studio (previously Google Data Studio) with real step-by-step examples. From one marketer to another: I’ll try to make this easy and quick to implement for you. Personally, I think that using Regular Expressions is a must if you want to create useful reports […]