Google Search Console Overview

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

Featureslink

Setup guidelink

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

Schema informationlink

This schema applies to all Google Search Console connectors.

To zoom, open ERD in new window

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 modeslink

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.

Reportslink

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 it’s corresponding metrics. The metrics are aggregated by Page. Dimensions include:

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

• 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 it’s corresponding metrics. The metrics are aggregated by Property. Dimensions include:

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

• 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 it’s corresponding metrics. Dimensions include:

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

• 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
  • Search Type (web/image/video)

• 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
  • Search Type (web/image/video)

• 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
  • Page
  • Search Type (web/image/video)

We support fresh data in reports.

NOTE: Fresh data may be incomplete and Fivetran may overwrite it during the subsequent syncs. Refer to Google’s Search Console documentation for more details.