This Google Search Console Looker Studio report template saves a lot of time during everyday work with Google Search Console data.

3 elements make this template unique: better filtering, rank tracker charts with daily keyword ranking data, and custom metrics. 

The template consists of 10 pages.

1. General dashboard

2. Keyword Rankings

3. Keyword CTR vs Average Position

4. Keywords grouped by pages

5. Keyword cannibalization

6. Landing pages rankings

7. Keyword Δ with position

8. Keyword Δ without position

9. Landing pages Δ

10. Country Δ

How custom metrics are calculated?

Ranked keywords

1. Formula

COUNT_DISTINCT(Query)

2. Value

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

Ranked pages

1. Formula

COUNT_DISTINCT(Landing Page)

2. Value

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

Potential Rank

1. Formula

Impressions / Average Position

2. Value

It helps determine which keywords to work on first. The key value is that it helps to determine the keyword’s profitability based on 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)

1. Formula

(Impressions / Average Position) / Impressions

2. Value

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

Lost Clicks

1. Formula

(Impressions * 0.2) – Url Clicks

2. Value

It shows how many clicks you lose on a keyword, page, or site, while not standing at 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.