Open navigation

Google Search Console report building guide

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


For a full list of metrics and dimensions available in our Google Search Console data source connector, take a look at our Google Search Console documentation.


Once you've connected to Google Search Console, you're ready to create your first query in Google Sheets, Looker Studio (formerly Data Studio), or Excel.


Query types for this data source

When connecting to the Google Search Console data source in Looker Studio, you must select a query type to use. The query type defines what sort of metrics and dimensions are available. 

  • Search analytics
  • Sitemaps
  • Crawl error samples
  • Crawl error stats
  • Search appearance analytics

Note that if you need to use multiple query types in your Looker Studio report, you'll need to create separate connectors for each query type you use.


Query types are not used in other data destinations, but you can only use metrics from the same group in one query.


Try these queries

See the following use cases for examples on how to set up queries.


See clicks and impressions

Take a look at how your clicks and impressions have evolved over the month.


In Looker Studio, use the "Search analytics" query type.


For best results in Looker Studio, use the line or combo chart type.

  1. Set the date range to Month to date.
  2. Select the Clicks and Impressions metrics.
  3. Select the Date dimension to split the query results by date.
  4. Set a filter with the Search type field and the EQUALS operator, and set the value to WEB. This matches your query results with the Google Search Console user interface. 


See clicks, click-through-rate, impressions, and average position over time

Get a wider view of the interactions of your audience. See how you're positioned in search results, and how many people have seen you in their search results. In this example, we take a look at the data for the year so far.


The “CTR” metric shows the Click Through Rate (clicks divided by impressions). The "Average position" metric shows the average organic position in Google search results. 


In Looker Studio, use the "Search analytics" query type.


For best results in Looker Studio, use the table chart type.

  1. Set the date range to Year to date.
  2. Select the Clicks, CTR, Impressions, and Average position metrics.
  3. Select the Week dimension to split the query results by week.
  4. Set a filter with the Search type field and the EQUALS operator, and set the value to WEB. This matches your query results with the Google Search Console user interface.


See clicks, impressions, and average position per query

Take a look at the most popular search queries your audience uses. 


In Looker Studio, use the "Search appearance analytics" query type. Select the search appearance dimension to use this query type.


For best results in Looker Studio, use the table chart type.

  1. Set the date range to Last 7 days.
  2. Select the Clicks, Impressions, and Average position metrics.
  3. Select the Search query and Search appearance dimensions. 
  4. Set a filter with the Search type field and the EQUALS operator, and set the value to WEB. This matches your query results with the Google Search Console user interface.


Set up scheduled refreshes for your reports

You can set up scheduled refreshes for your reports created in Google Sheets and Excel. Follow the instructions on how to create and manage scheduled reports in Google Sheets and how to set up scheduled report triggers in Excel.


In Looker Studio, you can have a copy of your report emailed to you and important stakeholders at regular intervals.


More resources

See the Supermetrics blog for how to use Google Search Console for SEO audit and keyword research.


You might also be interested in:

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.