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.

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!