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!