How to create a Google Analytics report: Tips and must-have metrics

How to create a Google Analytics report: Tips and must-have metrics

In today's competitive landscape, where data-driven decisions are increasingly essential, Google Analytics stands out as a powerful tool to understand user behavior on your website. Through it, you can track everything from visit volume to sales conversions, providing valuable insights for optimizing campaigns and digital strategies.

In this article, we will explore the key metrics that should not be missing from a Google Analytics report and the most practical and efficient ways to create these reports.

Essential metrics for a complete report

1-  User Conversion Rate

Measures the percentage of users who performed a transaction event, calculated by dividing the number of "transactions" by the total number of "totalusers".

foto 1 ENG.jpg

Image of Kondado's Google Analytics Report in Looker Studio

2 - Revenue and Users by Period Chart

This dual-axis chart correlates the revenue generated with the number of users over time. It is ideal for visualizing sales trends and seasonality.

foto 2 ENG.jpg

Image of Kondado's Google Analytics Report in Power BI

3 - Map Chart

A map chart allows you to visualize the geographical origin of indicators such as "New Users," "Total Revenue," "Transactions," and "Total Users."

The size of the circles on the map varies according to the values of each metric, providing a clearer and faster geographical analysis.

foto 3 ENG.jpg

Image of Kondado's Google Analytics Report in Power BI

4 - Session Source / Medium Filter and Sessions by Source/Medium Chart

This filter allows you to segment sessions based on their source (such as Google, newsletter, Amazon, Pinterest, among others) and medium (such as organic, paid, and referral). 

The Sessions by Source/Medium Chart is linked to the filter and shows which channels are driving the most traffic.

foto 4.1 ENG.jpg

 

foto 4.2 ENG.jpg

Image of Kondado's Google Analytics Report in Looker Studio

5 - Sales Funnel Chart

Displays each stage of the user journey as percentages, including: Total Users, Items Viewed, Items Added to Cart, and Transactions. This allows for identifying drop-off points and optimization opportunities.

foto 5 ENG.jpg

Image of Kondado's Google Analytics Report in Looker Studio

6 - Performance Table

Displays marketing and sales performance, making it easier to analyze the impact of each channel and identify which strategies generate more revenue and engagement, as well as monitor conversion efficiency.

foto 6 ENG.jpg

Image of Kondado's Google Analytics Report in Power BI

7 - Products Table

Provides a complete view of each product's journey, from its first display to the final purchase. It enables data-driven analysis to optimize your marketing strategies, improve product positioning, and boost sales.

foto 7 ENG.jpg

Image of Kondado's Google Analytics Report in Looker Studio

8 - ABC Table

This table displays the information of the ABC Curve, indicating the percentage share of the most relevant items (Group A), intermediate items (Group B), and low-impact items (Group C) in the total revenue, along with their respective income.

foto 8 ENG.jpg

Image of Kondado's Google Analytics Report in Looker Studio

Want to learn more about what the ABC Curve is and how it works? Click here to read our article with examples and applications.

Ways to create a Google Analytics report

Below are several ways to create and visualize Google Analytics reports:

1️ - Manual Method

You can extract data from Google Ads and manually structure it in spreadsheets or presentations. This approach allows you to adjust the information as needed. However, it requires more time, is prone to human errors, and is less practical for constant updates.

2️ - With Kondado

Kondado allows you to automate your Google Analytics reports simply and efficiently. Just connect your account, and the data is automatically sent to:

  • Spreadsheets in Google Sheets or Excel
  • BI tools like Looker Studio or Power BI
  • Databases like SQL Server or BigQuery

With Kondado, you can create custom reports with real-time updates and interactive charts, without the need for coding.

3 - Using Kondado's Ready-Made report templates

To speed up your analysis, Kondado offers ready-made and customizable templates already configured with the main metrics and optimized visualizations for Google Analytics reports.
Connect your account and have a complete report in just a few minutes!

Check out our Google Analytics report templates:

gif ga4 ls.gif
gif pbi.gif

Take your reports to the next level with Kondado

Stop wasting time with manual processes and outdated reports! With Kondado, you automate Google Analytics data collection, integrate it directly into tools like Google Sheets, Power BI, or BigQuery, and visualize everything in ready-made, optimized reports.

Start your free trial today at app.kondado.com.br/signup and transform your analyses.

Frequently asked questions

What are the essential metrics I should include in a Google Analytics report?
The article highlights eight must-have metrics: User Conversion Rate, Revenue and Users by Period Chart, Map Chart, Session Source/Medium Filter and Chart, Sales Funnel Chart, Performance Table, Products Table, and ABC Table. These cover everything from geographical analysis to conversion funnels and product performance, giving you a complete view of user behavior and business outcomes.
How can I automate my Google Analytics reporting instead of doing it manually?
You can automate your Google Analytics reports using Kondado's data integration platform. Simply connect your Google Analytics account, and data is automatically sent to spreadsheets, BI tools, or databases—eliminating manual work, human errors, and outdated reports.
What BI tools and destinations does Kondado support for Google Analytics reports?
Kondado sends Google Analytics data to spreadsheets (Google Sheets or Excel), BI tools like Looker Studio and Power BI, and databases like SQL Server or BigQuery. You can explore all available destinations on the platform.
What are Kondado's ready-made Google Analytics report templates?
Kondado offers pre-built, customizable templates already configured with the main Google Analytics metrics and optimized visualizations. The article specifically mentions a GA4 Looker Studio report and a GA4 Power BI report, allowing you to get a complete report in just minutes after connecting your account.
What is the ABC Table in a Google Analytics report and why is it important?
The ABC Table displays the ABC Curve, which categorizes your products or items into three groups based on revenue contribution: Group A (most relevant items), Group B (intermediate items), and Group C (low-impact items). This helps you identify which products drive the majority of your revenue so you can optimize marketing strategies and inventory focus.
How does the Sales Funnel Chart help optimize my website performance?
The Sales Funnel Chart displays each stage of the user journey as percentages—including Total Users, Items Viewed, Items Added to Cart, and Transactions. This visualization makes it easy to identify drop-off points in your conversion path and spot specific optimization opportunities to improve your sales flow.

Written by·Published 2025-05-09·Updated 2026-04-25