Power BI GA4 Universal Analytics Design Dashboard Template

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

1. Connect your Google Analytics 4 Data to Windsor.ai
   

   Connect Google Analytics 4

   Register for free or login if you already have an account.

2. 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.
3. Select at least one Google Analytics 4 account from the drop-down.
4. Click on Preview and Destination, choose Power BI Web, then copy your API Key.
5. Install the Power BI Web App
   

   Install Power BI Web App: Google Analytics 4 Universal Analytics Design

6. Click on Connect in the Connect your data section
   
7. Enter your API Key from Step 4.
8. On the next screen click on Sign In
9. Your data should be loading now. Depending on your data size this may take a minute or two.

 

Power BI Desktop

1. Connect your Google Analytics 4 Data to Windsor.ai
   

   Connect Google Analytics 4

   Register for free or login if you already have an account.

2. 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.
3. Select at least one Google Analytics 4 account from the drop-down.
4. Click on Preview and Destination, choose Power BI Web, then copy your API Key.
5. Download the Desktop Template
   

   Download Power BI Desktop Template: Google Analytics 4 Universal Analytics Design

6. 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.