English Posts

Track Data Studio Dashboards with one Property in Google Analytics and 4 Calculated Fields

Track Data Studio Dashboards with one Property in Google Analytics and 4 Calculated Fields

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:

one property in analytics and 4 calculated fields

Let’s start.

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.

create an account in google analytics

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”:
set up the property in google analytics

And save.

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:

page title dimension analytics

The dashboards with only one page don’t have the symbol, as you can see here:

page title with one page

Let’s create the calculated field with the name “Page Title + >” and the following rule:

CONCAT(Page Title, " ›")
concatenate calculated field

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
nuovo campo calcolato in data studio

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, '(.*).*›.*')
creare un nuovo campo calcolato in data studio

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

TRIM(REGEXP_EXTRACT(Page Title,'›(.*)$'))
campo calcolato per mostrare la pagina

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):
inserisci una tabella in data studio

Two Tips:

  • 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:
cambia il nome della dimensione in data studio
  • 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:
applicare un filtro alla tabella

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 ;
crea una nuova tabella in data studio

As you’ll see, the “dashboard Page Name” dimension displays the name of the pages of every dashboard.

Final Result

Here’s what the final result looks like (I added more charts and graphs but only two have calculated fields inside).

la dashboard finale

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.

Conclusions

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:

numero di pagina

Good analysis!


You may also be interested in the following articles:

Schedule Emails in Google Data Studio

Tracking Google Data Studio Dashboards with Google Analytics

Find Query Parameters on Google Analytics

How to track Single Page Applications with Google Tag Manager

How to solve the 5 million cell limit in Google Sheets

Cardinality dimensions in Google Analytics

Lascia un commento

Il tuo indirizzo email non sarà pubblicato. I campi obbligatori sono contrassegnati *