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, […]
How to connect data sources to Data Studio
Learn how to connect data to Data Studio (formerly 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 […]
How to Share Google Data Studio Reports
In this tutorial you’ll learn six different alternatives on how to share a Data Studio (formerly 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 […]
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 Data Studio in 6 Steps—and why it happens
To know why Data Studio (formerly 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 […]
How to copy a Data Studio Report Template
Learn how to copy any Data Studio (formerly 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 Data Studio Template Go to the main menu in Porter Metrics and open the Template […]
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 […]