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.
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:
- The User Acquisition Page, will allow you to get a deeper understanding on how your new users reach your site.
- The Traffic Acquisition Page, will help you understand where your traffic comes from for new and return users.
- The Pages page, lets you analyze your content so you can improve it or create more of what is working already.
- The Landing Page , will help you understand which pages are driving traffic to your site.
- The Tech Page, will help you optimize your site to the technology your audience uses. and finally,
- 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 App by Curbal449 € (Price excl. VAT: 359 €)
For more information about this report check this blog post.
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
Hi David,
My server went down last night. It is up and running again, please try again,
/Ruth
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.
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
Hello Ruth! The download-file is not working?
Hi Sebastian,
I fixed it, please try again!
/Ruth
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)))).
Hi Brian, you probably have US settings on your Power Bi file. Change the “;” to “,”
/Ruth
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!
Hi Nancy,
So you would like to show Avg session duration in h:mm:ss format?
/Ruth
where can I get the images for -365,-30, -7 and -1?
Hi Nimesh,
I am doing a video vlog about this today, stay tuned?
/Ruht