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!