Connect LinkedIn Pages to Data Studio for free: tutorial and templates
To connect LinkedIn Pages to Google Data Studio (formerly 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 Data Studio. Choose single data source, select LinkedIn Pages, authorize your LinkedIn account, allow access, then select one or […]
Connect Instagram to Data Studio for free: tutorial and templates
To connect Instagram to Google Data Studio (formerly 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 […]
How to Connect Meta Ads to Data Studio for free: tutorial and templates
To connect Meta Ads to Google Data Studio (formerly Looker Studio), go to Create report (or to the Data 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 Data Studio complete tutorial (2024)
In this Google Data Studio (formerly 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 Data Studio matter? We’ve already published an article about why businesses—especially marketers—should learn Google […]
How to Create Calculated Fields on Data 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 Data Studio: Regular Expressions with Examples for Marketers
In this article, we’ll show you how to use REGEX on Data Studio (formerly 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 […]
How to create filters on Data Studio
In this comprehensive guide you will learn how to create filters on Data Studio (formerly Looker Studio), based on real examples. I’ll show you how to create basic filters without knowing anything about coding or design. Here you have a step-by-step video on how to create a filter in less than 4 minutes: How do […]
How to design Data Studio reports and customize them
In this tutorial, you’ll learn how to design Data Studio reports, starting from the theme and layout, editing charts, and adding filters and buttons to make them interactive. No good design will save you if you don’t have the fundamentals right, such as the most important metrics and KPIs, and a good narrative to support […]
How to add charts and graphs to Data Studio
To create a good report you have to understand how to create and edit charts on Data Studio (formerly Looker Studio). If you want better reports, you have to understand: Combining these two ideas will help you create engaging, useful reports. I will cover the step-by-step process of creating charts, the different types, customization options, […]