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:
Number of searches of a keyword
An estimated amount to be paid for a click on a given keyword in Google Ads.
Domain position on a given keyword in organic search results on Google.
Domain position on a given keyword in organic search results on Google on the day of adding the project.
A change in domain position for a given keyword when compared to the position the previous day.
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).
A change in estimated traffic from organic search results when compared to visibility the previous day. It’s also illustrated as a percentage.
The maximal monthly traffic that a domain can generate from the monitored keywords.
The URL visible for the given keyword
Snippets displayed on a given keyword.
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!