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!