Convenient template for data visualization Google Search Console, the second version – SEO on

The first version of the report raised many questions and suggestions. Thanks to everyone who gave feedback. I tried to create a second, improved version. This report answers more questions and is more convenient to work with.


Than the second version is better

The report consists of two pages:

  1. General report;
  2. Rankings report.

General report – A universal report with a lot of data on both keywords and pages.

Rankings report – An abbreviated version of the first page for analyzing positions only by keywords.

By default, the report displays data from the Google Search Console for my blog.

The second version of the report is better due to such changes.

1. You can work with the report without any editing.

Log in to the report, being logged in to your Google account, and the list of sites that you have access to in the Google Search Console will automatically pull up in the filter. Now it is not necessary to copy the report at all in order to start using it.

2. Flexible page and key filters

Two types of filters by pages and keywords significantly speed up work with data. In the previous version, you had to create your filter in the report for each page or category. Now all this is not necessary.

The first kind of filter is select. In it you can select any number of pages and keywords, without becoming attached to their content.

The second type of filter is search. In it, you can filter pages and keywords by any occurrence.

But even more interesting is that both of these filters can be used together. For example, in the screenshot below, I first filtered the pages using a filter of type search and this condition applied to the data in the select filter on the left. On small sites, this is not necessary, but on large sites it will save a lot of time.

3. Convenient position charts

In the first version, positions can only be viewed in the pivot table. In the new version, the same data is also available in the graphical version, where it is even easier to notice the growth or fall trends of specific keywords.

4. Calculated metrics

These are metrics that are not by default inside the Google Search Console. We calculate them ourselves based on default metrics and some assumptions. This is one of the most valuable additions to the new version. I’ll tell you more about each metric.

The essence of the new calculated metrics

Ranked keywords

It makes it possible to see the number of ranked key phrases within a specific page, category, word occurrence.

Ranked pages


It makes it possible to see the number of ranked pages within the site, category, keyword.

Potential rank

Impressions / Average Position

Helps determine which keywords to work on first. The key value is that it helps to determine the keyword’s profitability on the basis of two critical parameters: the size of the gain (number of impressions per word) and your proximity to this benefit (your position).

Average Ideal Final Result (Average IFR)

(Impressions / Average Position) / Impressions

It shows how much you have reached the ideal end result within the keyword, page, category, site, but only on the basis of those queries for which you are already ranking.

Lost clicks

(Impressions * 0.2) – Url Clicks

It shows how many clicks you lose on a keyword, page, site, while not standing in the top-1. It is clear that each search query has its own CTR and it can vary greatly. But I specifically took the lowered CTR of the first position so as not to overdo it.

Therefore, do not be surprised if for some queries you have a negative value in the metric Lost clicks. This will be especially true for brand requests. You can easily fix the default CTR of the first position in the formula, if necessary.

Two options for working with a report


The second option – you copy the report in the same way as I told in the last video. The first dataset is URL Impression, the second dataset is Site Impression. After copying it will appear on the page of your files in Data Studio. This option is much better.


In the advanced version, you copy the report and edit it for yourself. 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 the sorting of values ​​in filters not by impressions, but by clicks.
  • To expand the limits of data display in graphs, tables.

How to combine with position monitoring services

  • Why do they need data from both the Google Search Console and the position monitoring tool?
  • how to use these tools together effectively.

The truth is that quite successfully the site can be promoted using data only from the Google Search Console. But it’s more difficult and longer.

Despite the large amount of valuable data in my report, it has many shortcomings, which arise from the fact that the data in the Google Search Console is generally small and from the fact that their customization in Data Studio is very limited.

A list of what this report cannot do, but position monitoring services can.

Report flaws

1. No more than 5000 keywords per day.

If your site is ranked by more than 5000 keywords, 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 watch the dynamics by 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 searched and experimented for a long time how this can be done in Data Studio, since, in fact, all the data for this is there.

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" End

But Data Studio does not allow you to create parameters based on the conditions of the metric values, or to divide the metric into separate types. Maybe one of you will find how to do this.

3. You cannot receive notifications on triggers

In Data Studio, you can configure the regular sending of a report by mail to yourself and your colleagues or clients. But this is simply uploading a report that you can access anytime.

The Google Search Console team is experimenting a bit with different valuable triggers. But while they are moving slowly in this direction.

Position monitoring services, on average, send more valuable reports.

4. You can’t track the results of promotion in several search engines at once.

If it is important for you to know positions not only in Google, then you already need several reports from different consoles, which will be difficult to configure in one form, since different consoles give different data.

5. Difficult to work with keyword groups

If you have all similar pages grouped into categories by which it is easy to filter pages by URL, then this problem does not concern you.

But often the most valuable pages are from a variety of URLs. In Data Studio, you can create a separate page with a single filter for all data, where include each such page in the filter. Well, here you will find a limitation. A filter in Data Studio cannot contain more than ten values.

In position monitoring services, at the stage of loading keywords, you can specify a group for each word and then look at the general data for the entire cluster.

6. Data delay for one to two days

The Google Search Console provides data with a delay of one to two days. It would seem a trifle. But when you constantly work with the site, update and create pages, then you want to quickly assess whether the page has entered the index and how each of your actions has affected your position in general. I want to see the results for the positions every morning. Position monitoring services solve this problem.

7. You can not measure the percentage of completion of the plan

Above I talked about the metric Average Ideal Final Result. It is a good indicator of the success of your plan, but only within those keywords for which 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 for which you want to rank, and compare with your results with the Google Search Console.

8. You can not compare yourself with competitors

This is the biggest flaw. When you study your positions with a keyword and see a drop or growth, you want to see what happened to other “participants in the carousel.” You won’t do this in the Google Search Console. And to go and look with your hands the search results for each keyword, geo, type of device is not very convenient.

Do you need GA + GSC integration

Now such a question. I started playing around combining Google Analytics and Google Search Console data. Nothing complicated, you can do it yourself.

Also added some calculated metrics to the report. But for now, the data in GA and this report on New Users, Bounce Rate metrics do not converge. Surely the problem is with the import. Are you interested in such a report?

If so, then I will dig around and try to bring it to mind. Or maybe one of you has already solved this problem and will say what to do.

In summary, I have as many as five questions. Please answer them in the comments.

  • What other graphs or data do you miss in the second version of the report?
  • Which of the existing graphs or data do you consider redundant?
  • Do I need a video tutorial for the second version of the report?
  • Do you need GA + GSC integration?
  • Do you use position monitoring services? If so, what do you dislike about them or what is missing?

Leave a Comment