Google Analytics Template App by Curbal

In this article, I will show you how to configure and use my Google Analytics Template.

Check the video or keep on reading:

Test the app below:

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.

Read before using the report!

1. Note 1: This report uses Windsor.ai connector for Google Analytics.
   They have a free tier you can use. If you need a pair tier you can get 15% off with this code:
   
   CURBAL
   
2. If you are having sampling issues when you connect to Google Analytics with the connector, the same sampling problems will appear on this report too. To try to minimize the issue, select a smaller date range using the date parameters. 

Ok, with that out of the way, lets walk-through how to install the App and configure it.

Purchase the template app

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

How to configure the report

1. Create account at windsor.ai
2. Connect to GA4
3. Get API key
4. Parameters
5. Release Notes

Create a Windsor.ai account

Go to windsor.ai and select a tier:
1. Free tier
2. Paid tier (use my discount code: CURBAL for 15% off)

And connect your GA4 account:

1. Search for google analytics 4
2. Select the account you want to connect to
3. Sign in with your google account
4. Click next

Get your API Key

Click on Power BI desktop:

and then click on APIKEY to copy the key. You will need it later.

Connect your data with the App

Open the downloaded file and fill in the following parameters:

1. DateFormat: Here you can specify the regional settings, so the date will be in your local format all codes here. ex. sv-SE
2. Language: Here you can specify the regional settings, so the Month Name and the Day Name will be in your local language. You can find all language codes here.
3. StartWeekDay: Does the week start by Sunday or Monday? Use 1 for Sundays and 2 for Mondays.
4. ApiKey: Enter the key you got in the previous step.
5. Days to load from yesterday: Pick an option in the drop down menu.
6. Domain: Here you specify the domain of your website. For example, if the URL for your website is: www. curbal-blog.se, then the name to enter here is: se (without the dot).
   Note: This is used to create a link to the pages on your site, if you enter this wrong, you wont be able to navigate to your pages.

And if you entered of all the parameters successfully, the app will be generated with your data.

And that is all you need to do. Enjoy!

Purchase the template app

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

Release Notes