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!


How Did We Do?


Powered by HelpDocs (opens in a new tab)