1. Docs
  2. Documentation
  3. Using Hero’s Google Data Studio Report

Using Hero’s Google Data Studio Report

Connect Google Data Studio

Before you starting using our Google Data Studio (GDS) template with Keyword Hero, we highly recommend adding a new data source based on the Keyword Hero View in GA. This article walks you through the necessary steps to do this.

  1. Go to https://datastudio.google.com/
    After you’ve created an account, click on the + Create in the left upper corner to add a new data source.


    Google data studio create datasource

  2. Now you are in the “Connector View”. First, give your data source a name (we chose “Keyword Hero view”), so you’ll know which one to select. Next, select Google Analytics as connectorOnce you’ve given GDS access to your Google Analytics account, you see all Google Analytics properties displayed that you have access to.


    Google data studio datasource connector

  3. Now, select your Google Analytics Account, Property, and View. Usually, that is the Keyword View, which Keyword Hero created automatically for you. Then click on Connect.


    Google data studio analytics view

  4. In the next step, you see all dimensions and metrics, which are transferred from Google Analytics. Please do not change anything here!


    Google data studio analytics connencor fields

Create calculated metric

Next you have to do, is create the „Avg. Position“ as a Calculated Metric.

  1. Please click on the ADD A FIELD button in the top right corner.


    Google data studio add_field

  2. You now see the formula editor, where you name the field “Avg. Position“.


    Google data studio field editor

  3. Now enter „position / session“ as formula and click on SAVE in the bottom right corner.


    Google data studio field formula

Now you have created the new data source and can add any of our Google Data Studio reports.

Troubleshooting

It can happen that the Formula Editor has problems with metrics/dimensions with the same name. In this case, the position metric (blue) can only be added as dimension (green). To fix this, a copy of the position metric must be created and renamed.

Here is a little guide on how to do this.

Click on the Google Data Studio logo to get to the report overview, then select the tab “Data Sources” and then the Data Source where you want to create the Avg. Position metric.

You will now get an overview of the dimensions/metrics imported from
Google Analytics. Search now for the metric “Position”.

Now you should see the Custom Dimension/Metric from Keyword Hero.

Click on the three dots next to the position metric (blue field) and choose to duplicate the metric.

Google Data Studio will return you to the overview page and you will have to search for the position metric again. As soon as it is displayed you can rename the metric by clicking on the blue field.

NOTE: Please make sure that the copied metric has a different name from the original!

After copying and renaming, you can use the new metric in the formula editor and create the “Avg. Position” following our guide above.

Updated on September 26, 2019

Was this article helpful?

Related Articles

Add A Comment