How to create a GA4 report in Power BI

How to create a GA4 report in Power BI

Check out the detailed step-by-step guide below to replicate our model and easily adapt it to the GA4 report in Power BI.

Steps to Follow:

1. Access Kondado: Create a free account or log in if you are already a user.

2. Choose Your Report: Select the desired report, and within minutes, Kondado will automatically configure everything, providing you with a link to access the complete panel with your data.

Report Features

The report is divided into three main pages:

Overview Tab

Shows an overview of the most important business metrics and insights, helping you quickly and clearly understand the company’s key focus areas. You can also apply filters by time period, country, and region, as well as compare data with the previous year.

Pages Tab

Provides a detailed analysis of user interactions on your pages, including data on sessions, source and medium, channel groupings, and campaigns. It also includes a sales funnel view that outlines user behavior from product viewing to purchase.

Products Tab

Presents a complete analysis of product performance, including information on revenue, view counts, and conversion rates. With the product table and ABC curve analysis, it is possible to identify the most profitable items and strategically adjust your portfolio.

Report Metrics

Revenue and Users by Period Chart: A combined bar and line chart with dual axes, allowing for the evaluation of the relationship between revenue and user volume over each period.

Map Chart: Displays the distribution of selected indicators, such as "New Users," "Total Revenue," "Transactions," and "Total Users," by region. Circle sizes vary based on the relative values, making the geographic data easier to analyze.

User Conversion Rate: Shows the percentage of users who triggered a transaction event. It is calculated by dividing "transactions" by "totalusers."

Session Source / Medium Filter: Enables the segmentation of sessions based on Source and Medium, identifying the main traffic sources.

Performance Table: Provides a detailed view of marketing and sales performance, making it simple to analyze the impact of each channel and campaign.

GIF ENG- GA4 X POWER BI.gif

Improve Campaign Management with Kondado

Our platform makes data analysis easier, providing essential insights to help businesses of all sizes improve their strategies.

With our GA4 report model in Power BI , you can monitor general performance, user engagement, and geographic distribution, segment your audience, analyze product performance, channels, and campaigns, and extract valuable insights to optimize your strategies.

Learn more about how to configure our report in our documentation.

Conclusion

Using this guide, you can quickly configure a GA4 report in Power BI and explore all its features to gain deep insights into your business performance.

Create a GA4 Report in Power BI with Kondado

Use Kondado's pre-built GA4 dashboard model to launch a Power BI report covering overview, pages and product performance — populated with your own data.

1
Sign up or log in to Kondado

Create a free account at Kondado or log in if you already have one.

2
Choose the GA4 report template

Inside the platform, select the GA4 Power BI report. Kondado configures the source, destination and data flow automatically and returns a link to your populated dashboard.

3
Explore the Overview tab

Use the Overview page to track key metrics with filters by period, country and region, and to compare data with the previous year.

4
Analyze pages and traffic

On the Pages tab, review sessions, source/medium, channel groupings, campaigns and the funnel from product view to purchase.

5
Review product performance

On the Products tab, use the product table and ABC curve to identify top revenue items, conversion rates and view counts so you can adjust your portfolio strategy.

Frequently asked questions

How do I access the GA4 report template in Kondado?
You can access the GA4 report by creating a free account or logging in if you are already a user. Once inside the platform, select the desired report and Kondado will automatically configure everything, providing you with a link to access the complete panel with your data.
What tabs are included in the GA4 Power BI report?
The report is divided into three main pages: the Overview Tab showing key business metrics with time, country, and region filters; the Pages Tab with detailed user interaction analysis including sessions, sources, channels, campaigns, and a sales funnel; and the Products Tab presenting product performance with revenue, views, conversion rates, and ABC curve analysis.
Can I filter the GA4 report by traffic source and medium?
Yes, the report includes a Session Source / Medium Filter that enables segmentation of sessions based on Source and Medium, helping you identify the main traffic sources and analyze the impact of each channel and campaign on your performance.
How is the User Conversion Rate calculated in the report?
The User Conversion Rate shows the percentage of users who triggered a transaction event. It is calculated by dividing "transactions" by "totalusers," allowing you to evaluate how effectively your traffic converts into actual purchases.
What does the Map Chart in the GA4 report display?
The Map Chart displays the geographic distribution of selected indicators such as "New Users," "Total Revenue," "Transactions," and "Total Users" by region. Circle sizes vary based on relative values, making it easier to analyze geographic data and understand your audience distribution.
How can Kondado help improve my campaign management beyond GA4 reports?
Kondado's data-to-dashboards approach makes data analysis easier by providing essential insights to help businesses of all sizes improve their strategies. You can monitor general performance, user engagement, geographic distribution, segment your audience, analyze product performance, channels, and campaigns, and extract valuable insights to optimize your strategies.

Written by·Published 2025-01-21·Updated 2026-04-26