Home » Keywords rankings in Google Data Studio

Keywords rankings in Google Data Studio

by Luuk

Monitoring organic keyword rankings is essential for many online marketers, especially for SEO professionals. How cool would it be if those keyword rankings would show up dynamically in your Google Data Studio dashboard? We found a way to insert your preferred keywords in your dashboard: the Accuranker connector.

Why we chose Accuranker as our keyword tracking tool

  • The keyword ranking tool of Accuranker is very accurate;
  • You can insert local and nationwide keywords (see the image with the table for an example);
  • You can track fluctuations of rankings on a daily basis;
  • You can track different elements in the SERP (Search Engine Result Page) very well. Like if the SERP has Ads on the top and/or bottom.

Getting keywords in Google Data Studio step by step

The first step you need to take is to get a Accuranker license. You can try the software with all it’s benefits for fourteen days with a trial, to ensure it fits all your needs. Once you’ve got your trial/license (and added a domain with keywords in your Accuranker account) it’s time to connect your account to Google Data Studio. It’s very easy, just follow the instructions.

Creating a Data Studio graph with keywords in it

After successfully connecting the Accuranker connector you can use the source in tables and/or graphs. A very useful graph is the ‘trend graph’. With this graph you can track the fluctuations of your keyword rankings for a longer period. In this example the time period is set to the last 30 days.

Trend keywords in Google Data Studio

A Google Data Studio ‘trend graph’ with Accuranker data for example. You can monitor your keyword developments with this connector on a daily basis.

The needed dimensions and statistics to create a trend graph

To create a ‘Keyword trend graph’ you need to select the following dimensions and statistics in a ‘Time series diagram’:

Dimensions: 

  • [Keyword Rank] Date
  • [Keyword] Keyword

Statistic:

  • [Keyword Rank] Rank

Important: set the aggregation of the statistic ‘[Keyword Rank] Rank’ at ‘Average’ instead of the standard ‘Total’. Otherwise we don’t get correct outcomes. You can fix this by clicking on the pencil next to the name of the statistic. In the image below you can see ‘AVG’ on this place.

Organic Keywords in Data Studio

The dimensions and statistics in Google Data Studio.

Creating a Google Data Studio table with organic keywords

A ‘Trend graph’ is very handy, but sometimes you only want to see a clear table with all the rankings of your keywords in it. You can fix this with the settings below.

Organic keywords in Google Data Studio

Dynamic keywords in a Google Data Studio table.

To create a ‘Keyword table’ like above you need to select the following dimensions and statistics in a standard ‘Table’:

Dimensions: 

  • [Keyword] Keyword
  • [Keyword Rank Landing Page] Keyword
  • [Keyword] Search Location

Statistics:

  • [Keyword Rank] Rank

Important: set the aggregation of the statistic ‘[Keyword Rank] Rank’ at ‘Average’ instead of the standard ‘Total’. Otherwise we don’t get correct outcomes. You can fix this by clicking on the pencil next to the name of the statistic. In the image below you can see ‘AVG’ on this place.

The dimensions and statistics in Google Data Studio.

Extra tip: categorize your keywords by using filters

Suppose we have a webshop that sells cuddle toys. We made a Google Data Studio dashboard that has several different ‘category’ pages:

  • Bears – Google Data Studio
  • Horses – Google Data Studio
  • Frogs – Google data Studio

The Google Data Studio page “Bears – Google Data Studio” only has data from the /stuffed-animals/bears/ pages on our website.

Now let’s say we have 250 keywords in total, but only 30 keywords about bears. we don’t want keywords like ‘Horse stuffed animal’ in our “Bears – Google Data Studio” page. At this point the Google Data Studio filters come in action!

First click on ‘Add a filter’, the Accuranker connector is already selected. To filter a bunch of specific keywords your need to set up the following settings:

Include -> [Keyword] Keyword -> Contains -> ‘Keyword’ (in our example it would be “bear”, since we only wanted to show keywords with the keyword “bear” in it.

In the example above, we would only get keywords with the word ‘bear’ in our table.

You may also like