How to create filters on Looker Studio
In this comprehensive guide you will learn how to create filters on 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 I add a […]
How to design Looker Studio reports and customize them
In this tutorial, you’ll learn how to design Looker 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 Looker Studio
To create a good report you have to understand how to create and edit charts on 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, and interactive filters- […]
How to connect data sources to Looker Studio
Learn how to connect data to Looker Studio with this complete step-by-step guide with real examples we have seen at Porter Metrics so you connect your data faster! We made a ‘how to video’ if you prefer to see how we do it! Now, here’s the step-by-step guide. How to connect any data source to […]
How to Share Google Looker Studio Reports
In this tutorial you’ll learn six different alternatives on how to share a Looker Studio report: Understanding the differences between these sharing options and what they mean for the people who will access your report is essential. I’ll take you through each sharing option in detail, including how to use them, different scenarios in which […]
How to analyze your marketing data: a 5-step framework
To analyze your marketing data following the SUMAS framework, begin by understanding your (S) strategy. This involves identifying key aspects of your company, customers, and competition.; define your (U) use cases between client reporting or performance management; map your (M) metrics between conversion, engagement, and visibility; (A) add context by comparing your data vs goals, […]
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, […]