Rank Tracker: Create a positions table in Google Data Studio

In this article I will guide you step by step through the process of creating a positions table in Data Studio.

 

GDS integration is available in the Premium and Professional plans. Do you want to have access to this integration without upgrading? Contact us about it by chat or support@senuto.com :)

Step 1: Go through the authorization process and select the project you want us to collect data from.

The whole process is described here.

Step 2: Add a table to the report.

Step 3: Set the data source to "Project - Positions (p_pos_*)".

Step 4: Set the most important parameters

  • dimension: p_pos_keyword

  • data: p_pos_organic_pos, p_pos_organic_visibility, p_pos_searches

  • sort: p_pos_organic_pos in ascending order

Rename the variables to make the report easier to understand.

Variables that you can use in the table:

Variable

Interpretation

p_pos_searches

Number of searches of a keyword

p_pos_cpc

An estimated amount to be paid for a click on a given keyword in Google Ads.

p_pos_keyword

Keyword

p_pos_organic_pos

Domain position on a given keyword in organic search results on Google.

p_pos_organic_pos_start

Domain position on a given keyword in organic search results on Google on the day of adding the project.

p_pos_organic_pos_diff

A change in domain position for a given keyword when compared to the position the previous day.

p_pos_organic_visibility

Etimated monthly traffic from organic search results, determined on the basis of visibility in the week under analysis (TOP3/10/50 keywords and individual positions of the website).

p_pos_organic_visibility_diff

A change in estimated traffic from organic search results when compared to visibility the previous day. It’s also illustrated as a percentage.

p_pos_organic_potential

The maximal monthly traffic that a domain can generate from the monitored keywords.

p_pos_organic_url

The URL visible for the given keyword

p_pos_serp_params

Snippets displayed on a given keyword.

p_pos_updated

Date of update of the position.

_prev - Adding _prev to the variable means that the variable refers to the previous day, e.g. p_pos_organic_pos_prev is a domain position for a given keyword in organic search results in Google on the previous day.

Step 5: Add date range and rename variables.

Adding a date range will allow you to later check the phrase positions in the report for any day.

Step 6: Display the table.

And there you go! You've added a positions table to your report!