This GA4 Dashboard Report Template for Power BI helps you to visualize your own GA4 data in Power BI in an interface which brings you back the Universal Analytics look & feel.
Follow the steps outlined below to get your data connected.
The template is available both as
- GA4 Universal Analytics Design Power BI Web Template App
- GA4 Universal Analytics Design Power BI Desktop Template
Power BI Web Template
- Connect your Google Analytics 4 Data to Windsor.ai
Register for free or login if you already have an account.
- Choose Google Analytics 4 from the left-side menu, click on “Sign in to Google” then follow the steps in the pop-up to sign-in and grant the required permissions.
- Select at least one Google Analytics 4 account from the drop-down.
- Click on Preview and Destination, choose Power BI Web, then copy your API Key.
- Install the Power BI Web App
Install Power BI Web App: Google Analytics 4 Universal Analytics Design
- Click on Connect in the Connect your data section
- Enter your API Key from Step 4.
- On the next screen click on Sign In
- Your data should be loading now. Depending on your data size this may take a minute or two.
Power BI Desktop
- Connect your Google Analytics 4 Data to Windsor.ai
Register for free or login if you already have an account.
- Choose Google Analytics 4 from the left-side menu, click on “Sign in to Google” then follow the steps in the pop-up to sign-in and grant the required permissions.
- Select at least one Google Analytics 4 account from the drop-down.
- Click on Preview and Destination, choose Power BI Web, then copy your API Key.
- Download the Desktop Template
Download Power BI Desktop Template: Google Analytics 4 Universal Analytics Design
- When opening the template, on the start screen, paste your API Key from step 4:
Power BI GA4 Universal Analytics Design Dashboard Template: metrics and dimensions
Below are the predefined metrics and dimensions available in the template. However, you can any other field you need in the connection string.
Dimensions:
- Date
- Device Category
- Source / Medium
- Landing Page
- Page path
- Campaign Name (Google Ads)
Metrics:
- Users
- New Users
- Sessions
- # of Sessions per User
- Pageviews
- Pages per Session
- Avg Session Duration
- Bounce Rate
- Revenue
- Conversion Rate
- Conversions
- Average Order Value
The Power BI GA4 dashboard template can be customized with > 500 different dimensions, breakdowns and metrics. Head here to see a complete list: available metrics and dimensions.
It queries the data through our connector and makes it available in real-time.
You might also be interested in…