Thanks to Google Analytics it’s possible to track the users’ interaction on a website.
Do you know that you can use GA also to track Google Data Studio‘s Dashboards?
Yes, you can!
In this post I explained how to track the Dashboards made via Google Data Studio using Google Analytics.
Reading the post you can easily implement the solution creating one new Property in GA for every Dashboard in Data Studio you want to track.
Here I suggest you a trick where you can create only one Property in Google Analytics.
All you need is:
- one Property in GA –> you’ll have one tracking Id that you can use for all the dashboards you want to track;
- calculated fields in DS –> they’ll be useful to extract dashboard title and pages for each dashboard;
The structure will be something like this:
Create an Account in Google Analytics
You have to create a new Property in order to copy the Tracking Id and paste it into the dashboards you want to track.
When you set up the Property, remember those two suggestions:
- use a name that can help you to describe the aim of the Property, for example: Data Studio Dashboards;
- Insert into the Default URL box the following URL: “datastudio.google.com”:
Create Calclulated Fields to See Reports in Data Studio
Now, to avoid creating one Property in GA for each Dashboard in DS you want to track, as described here, let’s create 4 calculated fiedls.
There is no more correct method than the other. The difference is that one solution provides for the creation of multiple Properties, while the other provides for only one Property but the use of calculated fields
1st Calculated Field
The final result of this field is: insert the “› “symbol at the end of each Page Title.
You have to know that the name of Data Studio Dashboard is processed under the Page Title dimension.
The purpose of this field is: to place the “› “symbol on all Data Studio dashboard titles, even those that only have one page. In fact, dashboards with multiple pages automatically generate the “› “symbol as you can see in the image below:
The dashboards with only one page don’t have the symbol, as you can see here:
Let’s create the calculated field with the name “Page Title + >” and the following rule:
CONCAT(Page Title, " ›")
2nd Calculated Field
The final result of this field is : showing dashboard’s Titles.
The purpose is: if the “› “symbol is present in the Page Title dimension, then it shows this dimension; if instead the “› “symbol is not present then use the 1st Calculated Field created in the previous step.
Let’s create a new calculated field with the following value (simply copy the code below and paste it into the fields in Data Studio). Then name it “Page Title Combined“:
CASE WHEN REGEXP_MATCH(Page Title, ".* ›.*") THEN Page Title ELSE Page Title + > END
If you want to learn more about what the RegEx (Regular Expressions) are, read the post here.
3rd Calculated Field
The final result of this field: only showing dashboard’s Title
The purpose is: this field will extract the text that is before the “› “symbol regardless of how many pages the report has or if the title contains the” ›” symbol or not.
Let’s create the new field with the following value and name it “Report Name – Final“:
REGEXP_EXTRACT(Page Title Combined, '(.*).*›.*')
4th Calculated Field
With this field it’ll be possible to see the page title you gave at every page you’ve created in every Data Studio Dashboard.
Let’s crate a new field with the following value and name it “Dashboard Page Name“
Create Charts in Data Studio
After having created the calculated fields, now it’s time to create the charts where we’ll see all the results.
I’ll show you two charts with the Calculated Fields we’ve created. Then ou can choose wich KPIs you want to insert to keep monitored.
Create a new chart in Data Studio with the following values:
- Dimension: Report Name – Final (this is our 3rd Calculaed Field created before);
- Metric: Users, Page Views, Avg. Time on Page (feel free to add others which can be useful for your analysis):
- it’s more useful to change the name of the dimension created and insert a more “speaking” one. Eg: “Dashboard Name“. Just click on the pen close to the entered dimension and write the name inside:
- Click on the chart and select Apply Filter. In this way, you have turned your chart into filter controls and you can filter all the report by interacting with that chart:
Now, let’s add another chart. The aim will be to show the pages that compose the dashboard.
Insert the chart with the following values:
- Dimension: Dashboard Page Name. This is the 2ns Calculated Field created before;
- Metric: Users, Page Views, Avg. Time on Page ;
As you’ll see, the “dashboard Page Name” dimension displays the name of the pages of every dashboard.
Here’s what the final result looks like (I added more charts and graphs but only two have calculated fields inside).
As you can see:
- the chart on the top left uses the calculated field “Report Name – Final” and it’s turned into filter control (as described above);
- the chart on the bottom right has the calculated field “Dashboard Page Name“.
In this way, by selecting the dates and clicking on the name of the Data Studio dashboard in the chart at the top left, all the KPIs in the report will change and show you the results of that dashboard.
In the chart on the bottom right you’ll see only the pages of the dashboard you have selected in the firts chart.
In this post I’ve shown you how, through the Calculated Fields made available by Data Studio, it is possible to “clean” some values and see the performance of the dashboard you created in an easy and intuitive way.
In this way you can create only one Property in Google Analytics and paste this tracking Id code in all the reports you want monitoring.
This saves you from creating a new Property every time, copying the tracking Id and pasting it within a single dashboard in Data Studio.
A tip when creating dashboards in Google Data Studio: to see the page number for each sheet use a structure like this:
“Page 1 – Name of the Page”
This’ll make it easier to find the page number in your report: