Google Search Console report building guide

Prev Next

Use the Google Search Console data source connector to centralize search data in one location and create historical reports to see how your visibility has improved over time. Pull data such as queries, landing page analytics, geo, and sitemaps.

Before you begin

Before you build reports, you need to connect the data source to Supermetrics.

Query types

In Looker Studio, you must select a query type when connecting to Google Search Console. Query types are not required in other destinations, but you can only use metrics from the same group in one query.

  • Search analytics: Core search performance data, including clicks, impressions, CTR, and average position.

  • Sitemaps: Data about submitted sitemaps and their indexing status.

  • Crawl error samples: Sample URLs affected by specific crawl errors.

  • Crawl error stats: Aggregated crawl error counts over time.

  • Search appearance analytics: Performance data segmented by how your pages appeared in search results, such as rich results or AMP.

Note

If you need to use multiple query types in your Looker Studio report, you will need to create separate connectors for each query type.

Popular queries

These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.

Monitor clicks and impressions over time

Track how your clicks and impressions have evolved day by day this month — useful for spotting traffic trends and assessing the impact of content or SEO changes.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type (Looker Studio)

Search analytics

Date range

Month to date

Metrics

Clicks, Impressions

Dimensions

Date

Filter

Search type EQUALS WEB (matches results with the Google Search Console interface)

Suggested visualization

Line or combo chart

Understanding the data

  • Clicks: The number of times a user clicked through to your site from Google Search results.

  • Impressions: The number of times your site appeared in Google Search results.

  • Date: Splits results by day so you can track how clicks and impressions change over time.

Analyze CTR, position, and visibility year to date

Get a weekly view of how your site is performing in search results this year — combining click volume, impressions, click-through rate, and average position to give a full picture of organic search health.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type (Looker Studio)

Search analytics

Date range

Year to date

Metrics

Clicks, CTR, Impressions, Average position

Dimensions

Week

Filter

Search type EQUALS WEB (matches results with the Google Search Console interface)

Suggested visualization

Table

Understanding the data

  • Clicks: The number of times a user clicked through to your site from Google Search results.

  • CTR: Click-through rate — the number of clicks divided by the number of impressions.

  • Impressions: The number of times your site appeared in Google Search results.

  • Average position: The average organic position your site appeared at in Google search results.

  • Week: Splits results by week, reducing day-to-day noise for a cleaner view of long-term trends.

See performance by search query and appearance

See which search queries are driving the most clicks and impressions in the last 7 days, alongside how your pages appeared in results — useful for identifying high-performing queries and understanding which search features your content is eligible for.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type (Looker Studio)

Search appearance analytics

Date range

Last 7 days

Metrics

Clicks, Impressions, Average position

Dimensions

Search query, Search appearance

Filter

Search type EQUALS WEB (matches results with the Google Search Console interface)

Suggested visualization

Table

Understanding the data

  • Clicks: The number of times a user clicked through to your site from Google Search results.

  • Impressions: The number of times your site appeared in Google Search results.

  • Average position: The average organic position your site appeared at in Google search results.

  • Search query: The exact search term used by the user that triggered your page to appear in results.

  • Search appearance: How your page was displayed in search results, such as through rich results or AMP. Required when using the Search appearance analytics query type.

More resources

See the Supermetrics blog for a step-by-step guide for SEO analytics.

You might also be interested in: