Convenient sample for Google Search Console data visualization, the second version

Ivan Paliy
15 May 2020

Why is the second version better?

Link to the report’s second version.

There are two pages in the report:

• General report;

• Rankings report.

General – this one includes massive data on keywords and pages.

Rankings – a short first page’s variant for an analysis of the positions specifically by keywords.

In my report, I can see all Google Search Console information on my site; this option is available by default.

There are several changes which make the second report more useful and better in general:

1. No editing, while working on the report.

Check whether you are signed in into a Google account; then, log in to the report. You can now see the filtered sites’ list – these are the websites you have access to from your account in Google Search Console.

Importantly, to use the report, you do not need to copy it.

2. The Page and Keyword filters are very flexible.

The filters simplify and speed up your work with information. In the older report’s version, you would have to create a filter for every single page or category. For now, this all is unnecessary.

Select – is the first you should know. With this filter’s help, you can choose the number of pages and the number of keywords you need so that you don’t stick to their content.

Search – is the second filter, which allows you to filter both keywords and pages by any occurrence.

What is more, you can easily apply these filters altogether. For example, the screenshot below demonstrates how I used the search filter first;

Also, you can see how this activity influenced the data in the select filter on the left. Sure, this option is unnecessary when working with small sites; however, it is very time-consuming when working with large sites.

3. Convenient position charts.

In the first version, you can see all the positions only in the pivot table. If you use the new version, you will have a graphical variant of this information as well. Therefore, you can see the growth and fall in positions conveniently.

4. Calculated metrics.

Google Search Console does not offer these metrics by default. How we do it: first, we consider some assumptions and default metrics and then calculate the parameters ourselves. You would appreciate this addition. Personally, I believe it to be one of the most important ones. Below, you can see more information on each metric.

The essence of the new calculated metrics

Ranked keywords

1. Formula


2. Value

It allows you to see the amount of ranked critical phrases within a chosen page, word occurrence, and category.

Ranked pages

1. Formula


2. Value>

It allows you to see the exact amount of ranked pages: you can apply it to a keyword, site, or category.

Potential rank

1. Formula

Impressions / Average Position

2. Value

The metrics demonstrate the keywords that require your attention. So, you can see which words you should work on in the first instance. The key value shows how profitable a keyword is in terms of the gain size (impressions per word) and how close your position is to this benefit.

Average Ideal Final Result (Average IFR)

1. Formula

(Impressions / Average Position) / Impressions

2. Value

The metric demonstrates how close you are to the best end result regarding a keyword, category, page, and site. However, this result will be based on the already ranked queries.

Lost clicks

1. Formula

(Impressions * 0.2) – Url Clicks

2. Value

With this metric’s help, you can see the number of clicks you lose in relation to the website, page, and keyword, until you reach the top 1. Sure, we all know that every search query has corresponding CTR that can and will vary considerably. As for me, I took the first position’s lowered CTR so that I don’t overdo it.

One of the recent studies by Backlinko and similar sources indicate that the first place has more than 30% of clicks. Considering that many queries in the search results are generally passed without visiting the sites, it will be better to lower it to 20%.

Two options for working with a report.


The first option is to save the report and work with it whenever you want. I am not going to edit this report’s version as I want to work with the same interface.

The second option – you just copy the report the way I told in my last video. So, your first dataset will be the URL Impression, while Site Impression – is the second one. After you copied it, the report is available in the Data Studio files. I should say that this option seems to be better.


This version of the report allows you to edit it as you wish. These are the things you can do with the advanced version of the report:

• the calculated metrics can be either deleted or replaced.

• the graphics can be removed or replaced.

• in filters, you can sort the values by clicks.


In the advanced version, you copy the report and edit it as you wish. There is a high probability that you will want to fix the following:

• Remove or replace my calculated metrics.

• Remove or replace any graphics.

• Set up the filters so that the values are sorted not by impressions, however, by clicks.

• Expand the limitations on data displayed in tables or graphs.

How to combine with position monitoring services.

One of our platforms offers a tool that we are developing for monitoring site positions. Communication with users allowed me to notice that they don’t always understand the following:

• Why does it matter to have data from the Google Search Console and the position monitoring tool?

• Is there any way to use these tools together?

The point is that you can successfully promote your website with the help of Google Search Console data. But this process is more complicated and time-consuming.

Despite lots of essential data in my report, there are still many shortcomings in it. These drawbacks appear due to the lack of data in the Google Search Console. Also, keep in mind that their customization in Data Studio is minimal. Check out the list of what this report cannot do, but position monitoring services can.

Report flaws

1. 5000 keywords per day is the limit.

If more than 5,000 keywords rank your site, you will not be able to watch the dynamics of the ranking of keywords beyond this maximum.

Yes, you can divide the site into categories by URL and look at the dynamics of individual categories, but this is not very convenient.

2. It is impossible to derive the metrics of the number of keys in the position range: top-1, top-3, top-10, top-30, top-50, top-100.

I spent much time searching for and experimenting on how this can be done in Data Studio since there is all the data for this.

This formula was supposed to solve the problem.


WHEN Average Position = 1 THEN “Top 1”

WHEN Average Position <4 THEN “Top 3”

WHEN Average Position <11 THEN “Top 10”

WHEN Average Position <31 THEN “Top 30”

WHEN Average Position <51 THEN “Top 50”

WHEN Average Position <101 THEN “Top 100”

ELSE “No positions”


But Data Studio does not allow you to create parameters based on the conditions of the metric values, or to split the metric into several types. I am sure it’s not hard, so you can try to do it yourself.

3. No notifications on triggers.

Data Studio allows you to configure the regular sending of a report by mail to your clients, colleagues, or yourself. However, it’s all about simply uploading a report; you are free to access it whenever you need it anyway.

The Google Search Console team is constantly carrying out experiments with diverse critical triggers. Nevertheless, they still have many to analyze and research.

As for position monitoring services, these are associated with more essential and informative reports.

4. It is impossible to check the results of promotion in several search engines simultaneously.

If it is essential for you to know positions from different consoles, Google report will not be enough for you. Note that these reports will be difficult to configure in one form as every console report will consist of different data.

5. You will find it hard to work with keyword groups.

First of all, if all of your similar pages are sorted by categories (this allows you to filter the URLs of the needed pages), this flaw doesn’t concern you.

Nevertheless, it may happen that dozens of valuable pages have diverse URLs. Using Data Studio, you can create a new separate page and apply one filter for all data; here, you can add all the required pages in the filter. At the same time, keep in mind one critical limitation from the side of Data Studio: no more than ten values are allowed.

While loading keywords in position monitoring services, you may indicate a group for each word. Then, you will be able to look through the information for the whole cluster.

6. Data delay (1-2 business days).

A usual data delay for Google Search Console ranges from one to two working days. It seems to be not a big deal; however, when you continuously work with the updates, revise your site, and create pages, you want to check whether indexation is over or not quickly. If you are currently experimenting with the site, you would also like to see the effects of your actions on your position. As for me, I want to see the results every morning. With the position monitoring services, you can solve this problem quickly.

7. You cannot measure the percentage of completion of the plan.

I talked about the metric Average Ideal Final Result previously in the article. It is a good indicator of your plan’s success, but only within keywords you already have impressions.

If you want to understand how successfully you are fulfilling a ranking plan for a pre-assembled semantic core, then the Google Search Console data will not be enough. You need to remove positions for all keywords you want to rank and compare them with your results from the Google Search Console.

8. No opportunity to compare yourself with your competitors.

I consider this flaw as the biggest one. As I examine my positions with a keyword, I can see whether it has dropped or risen. However, after this, I want to see what’s up with my competitors. Google Search Console doesn’t allow you to do this. And it is not very convenient to look through all the search results for the device’s type, geolocation, and also each keyword.

GA + GSC integration: do you need it?

Now that is the question. This is how I tried to answer the question: first, I combined Google Analytics and Google Search Console reports’ data. There is nothing complicated, and you can do it yourself. After that, I added some calculated metrics to my report. At the moment, there are no coincidences between GA data and the report on Bounce Rate and New Users. Undoubtedly, the problem is in import. I cannot see how such a report will be helpful for me; how about you?

If you are okay with this, I will mull over it and try to recall what can be done. Perhaps, some of you already know the solution for the issue – tell me what to do.

In conclusion, I have five questions all in all. You are free to answer these in the comments. Here are the questions:

  • The second report misses some graphs and data; what other graphics and data you are missing?
  • Are there any redundant graphs or data?
  • Do you need video instruction in the second report’s version?
  • Is GA + GSC integration important for you?
  • If you use position monitoring services, which things are missing or what should be improved in these?

1 Comment

  • Бодя says:

    Спасибо, бро! Отличный дашборд)
    Если бы я был хоть чуть аналитиком, то я бы с удовольствием ответил на твои вопросы, но так как я юзаю его просто смотреть динамику страниц/делать план по ссылочному – то тут без вариантов)
    В любом случае спасибо и удачи)

Leave a Reply

Your email address will not be published.