Google Search Console

Google Search Console helps you monitor and maintain your site's presence in Google Search results.

Features

Setup guide

Follow our step-by-step Google Search Console setup guide to connect Google Search Console with your destination using Fivetran connectors.

Schema information

This schema applies to all Google Search Console connectors.

NOTE: We do not sync sitemap entries for domains because sitemap entries for domains are not supported at the Google Search Console API level.

Aggregation modes

Google Search Console aggregates metrics by property or by page, depending on the report type. The difference between these two aggregation modes is explained in the Google Search Console documentation.

NOTE: For reports with the same aggregation mode, Google Search Console may still aggregate metrics differently, depending on the selected dimension set and search type. This may lead to discrepancies between the data in the Google Search Console dashboard and the data in your destination.

Reports

Google Search Console delivers the following reports:

• SITE_REPORT_BY_PAGE: Search traffic data for a site. Each record shows how the site appeared in the search results on a particular day and its corresponding metrics. The metrics are aggregated by Page. Dimensions include:

  • Date
  • Country
  • Device
  • Search Type (web/image/video/news)

• SITE_REPORT_BY_SITE: Search traffic data for a site. Each record shows how the site appeared in the search results on a particular day and its corresponding metrics. The metrics are aggregated by Property. Dimensions include:

  • Date
  • Country
  • Device
  • Search Type (web/image/video/news)

• PAGE_REPORT: Search traffic data for the pages of the site. Each record shows how a particular page on the site appeared in the search result on a particular day and its corresponding metrics. Dimensions include:

  • Date
  • Country
  • Device
  • Page
  • Search Type (web/image/video/news)

• KEYWORD_SITE_REPORT_BY_PAGE: Search traffic data of the site based on the query strings user searched for on Google. Each record shows how the site appeared in the search result for a particular search query. The metrics are aggregated by Page. Dimensions include:

  • Date
  • Country
  • Device
  • Keyword (only for connectors created before August 12, 2022)
  • Query (only for connectors created after August 11, 2022)
  • Search Type (web/image/video/news)

• KEYWORD_SITE_REPORT_BY_SITE: Search traffic data of the site based on the query strings user searched for on Google. Each record shows how the site appeared in the search result for a particular search query. The metrics are aggregated by Property. Dimensions include:

  • Date
  • Country
  • Device
  • Keyword (only for connectors created before August 12, 2022)
  • Query (only for connectors created after August 11, 2022)
  • Search Type (web/image/video/news)

• KEYWORD_PAGE_REPORT: Search traffic data of the pages of the site based on the query string user searched for on Google. Each record shows how the site appeared in the search result for a particular search query. Dimensions include:

  • Date
  • Country
  • Device
  • Keyword (only for connectors created before August 12, 2022)
  • Query (only for connectors created after August 11, 2022)
  • Page
  • Search Type (web/image/video/news)

NOTE: We support fresh data in reports. Fresh data may be incomplete and Fivetran may overwrite it during the subsequent syncs. Refer to Google's Search Console documentation for more details.

Sync overview

Rollback sync

A rollback sync is a sync that automatically runs once a day. Rollback syncs capture the changes that happen outside of the incremental sync time frame. The rollback sync time frame for our Google Search Console connector is 7 days.