• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / Google Analytics / The ultimate dashboard to track your website growth with Google Analytics 4 and Power BI
The ultimate dashboard to track your website growth with Google Analytics 4 and Power BI

The ultimate dashboard to track your website growth with Google Analytics 4 and Power BI

posted on November 29, 2015

 

I have been using Google Analytics for a few years now and it has been really useful to modify my websites so they are more useful to my readers.

So, all my efforts modifying my sites, are they paying off? Do I get new readers? Is my site growing?

Google Analytics 4helps you with the technical details, (screen size, speed, etc) with the behavioral details (pageviews, time on page, etc) and even with your traffic sources (social, organic, etc). Everything is geared so you can grow your site, but to see how much growth you are getting on a daily/ weekly/monthly or year basis, you need to do it manually.

I want to find out in one single click, how much your site is growing,  you can finally do it using Power BI. Your site growth in one click.

Scorecard for google analytics 4 in power bi
Scorecard for google analytics 4 in Power BI

Check the report live here:

About the report

The following Power BI report app will allow you to connect to Google Analytics 4 to analyze your website performance.
The report contains 7 tabs to analyze different aspects of your website:

  1. The User Acquisition Page, will allow you to get a deeper understanding on how your new users reach your site.
  2. The Traffic Acquisition Page, will help you understand where your traffic comes from for new and return users.
  3. The Pages page, lets you analyze your content so you can improve it or create more of what is working already.
  4. The Landing Page , will help you understand which pages are driving traffic to your site.
  5. The Tech Page, will help you optimize your site to the technology your audience uses. and finally,
  6. The Demographic Page, will help you learn more about your audience.

Important note:

This report uses Windsor.ai connector for Google Analytics 4.
They have a free tier you can use. If you need a pair tier you can get 15% off with this code:

CURBAL

Is the template using the built in Power BI connector in Power BI?

No, because it is not possible to send filters back to Google Analytics 4 at the time of the query and therefore the data will be incorrectly aggregated.

Can I get the report?

If you tested the app and you want to personalize it, you can buy the report here:

  • Google analytics 4 template for Power BI
    Google Analytics 4 Template App by Curbal
    449 € (Price excl. VAT: 359 €)
    Add to cart

For more information about this report check this blog post.

Filed Under: Google Analytics, Microsoft Power BI

Join our community of over 50,000 professionals

Become a Member

Subscribe to YouTube

Reader Interactions

Comments

  1. david jeba

    November 28, 2017 at 7:29 am

    the link is not working, i recommend to use amazon s3 or azure blob or onedrive instead of uploading files in a 3rd party unreliable servers

    Reply
    • Ruth Pozuelo Martinez

      November 28, 2017 at 12:39 pm

      Hi David,
      My server went down last night. It is up and running again, please try again,
      /Ruth

      Reply
  2. Collins

    October 19, 2017 at 10:59 am

    Hello Ruth,

    Thanks for this amazing solution. Doing this exactly the same way you specified actually works, but I have some challenges and they are as follows:

    1. When I add new columns e.g “Device Category” or “Default Channel Grouping” to the existing “Sessions” table it completely changes the total number of sessions and it does not match Google’s data anymore.
    2. If I import a new table, I have to create a new relationship and the One-to-many option is no longer available, it gives an error “The cardinality you selected is not valid for this relationship…”, selecting Many-to-one makes no difference because it does not match GA’s data.
    3. Importing a new table with metrics such as Unique Pageviews and Page Title matches Google, but when I bring in Page Name, the stats change”.

    Can you explain some of these anomalies, and what is the best way to create a relationship with multiple tables. Why does adding new columns to the existing Sessions table distort the data. ?

    Thanks.

    Reply
    • Ruth Pozuelo Martinez

      November 15, 2017 at 7:48 pm

      Hi Collins,
      There could be a million reasons why your data does not match GA.
      Check the following video to see if the tips there help you:
      https://www.youtube.com/watch?v=CN5ch2hUS7s&index=12&list=PLDz00l_jz6zz06ucv1CnhW7MHJK6zvFiJ

      /Ruth

      Reply
  3. Sebastian Hooshidar

    October 5, 2017 at 10:51 am

    Hello Ruth! The download-file is not working?

    Reply
    • Ruth Pozuelo Martinez

      October 5, 2017 at 9:25 pm

      Hi Sebastian,
      I fixed it, please try again!
      /Ruth

      Reply
  4. Brian Zito

    October 2, 2017 at 6:33 pm

    I’m getting an error when I enter any formula with a semi colon. Below is the error message I get when I paste the WTY formula as a new measure:

    The syntax for ‘;’ is incorrect. (DAX(CALCULATE([Total Sessions];DATESBETWEEN(DimDate[Date]; LASTDATE(DimDate[Date])-WEEKDAY(LASTDATE(DimDate[Date]);2)+1;LASTDATE(DimDate[Date])-1)))).

    Reply
    • Ruth Pozuelo Martinez

      October 2, 2017 at 7:01 pm

      Hi Brian, you probably have US settings on your Power Bi file. Change the “;” to “,”
      /Ruth

      Reply
  5. Nancy C

    September 25, 2017 at 7:09 pm

    Thank you for such a detailed post! I’m having a hard time displaying the average session duration. I first calculated the metrics for ‘Session Duration’ and then created the measures in PowerBI to get the Avg Session duration eg (MTD Session Duration / MTD Sessions). However, I’m having a hard time showing the new measure with the format “h:mm:ss”.

    Apparently this is a common issue for PowerBI users, but I was wondering if you found a work around.

    Thank you!

    Reply
    • Ruth Pozuelo Martinez

      October 2, 2017 at 11:19 am

      Hi Nancy,
      So you would like to show Avg session duration in h:mm:ss format?
      /Ruth

      Reply
  6. Nimesh patel

    September 7, 2017 at 7:29 am

    where can I get the images for -365,-30, -7 and -1?

    Reply
    • Ruth Pozuelo Martinez

      September 11, 2017 at 11:06 am

      Hi Nimesh,
      I am doing a video vlog about this today, stay tuned?
      /Ruht

      Reply
« Older Comments

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In