Rank Tracker: Create an increases/decreases table in Google Data Studio
In this article I will guide you step by step through the process of creating an increases or decreases table in Google 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 Increases (p_inc_*)" or "Project - Positions Decreases (p_dec_*)".
The choice of source depends on whether you want to present a table of increases or decreases. In this manual I will use the source for the increase table.
Step 4: Set the parameters
data: p_inc_organic_pos,p_organic_pos_diff, p_inc_searches
Other variables that you can use in the table:
An average monthly number of searches of a given keyword in Google.
An estimated amount to be paid for a click on a given keyword in Google Ads.
The position of the website for a given keyword in Google organic search results.
A difference between the current website’s position for a given keyword and its positions the previous day.
Estimated 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.
URL visible for a given keyword.
_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 entry for a given key phrase 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 keyword positions in the report for any day.
Rename the variables to make the report easier to understand.
Step 6: Display the table.
Done! You have added an increases table to your report in Google Data Studio!