Rank Tracker: Add a summary of your project’s statistics in Google Data Studio
In this article I will guide you step by step through the process of adding a summary of your project's statistics to the report 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 in detail here.
Step 2: Add a scorecard to the report.
Step 3: Set the data source to "Project - Statistics (p_sta_*)".
Step 4: Select which data you want to present in the summary.
You can select all variables with the prefix p_sta_*. If you select a variable with a different prefix, the system will not work properly because the prefix must match the previously selected data source.
In this case, I chose the "p_sta_top10" option, which means that I will present the number of keywords in the TOP10.
Data that you can present in the statistics:
The number of keywords for which the domain is visible on positions ranging from x to y
The number of phrases for which the domain is visible on the positions from 1 to Z
The number of keywords, the position of which increased, decreased or did not change in relation to the previous day.
Number of keywords with a position greater than 50.
The maximum monthly traffic that a domain can generate from the monitored keywords.
The percentage of traffic that the domain generates from the maximum potential from the monitored words.
Number of keywords added to the project.
An estimated amount to be spent in Google Ads to generate the same traffic as the one generated by SEO efforts. The amount is estimated on the basis of traffic from keywords for which the website is ranked 1–10.
_prev: Adding _prev to the variable means that the variable refers to the previous day, e.g. p_sta_1_3_prev means the number of phrases in positions 1-3 of the previous day.
Step 5: Rename the variable.
If you want the statistics to display the name "TOP10" instead of "p_vis_top10", change the name of the variable by clicking on the pencil sign marked below.
To add more statistics, repeat the steps described earlier.
Step 6: Display the report.
Done! You have added a summary of the project's statistics to the report!