Skip to main content
Support Articles
Feature Requests Documentation Status Dashboard

Google Search Console Overview

  • Updated
Fivetran System User Fivetranner

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

Featureslink

Feature Name Supported Notes
Capture Deletes
Custom Data
Data Blocking Table level
Column Hashing
Re-sync Connector level
History
API Configurable
Priority-first sync Reporting tables
dbt Package

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 support the synchronization of the sitemaps-entries for domains because it is not supported at the Google Search Console API level.

Google Search Console delivers 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)

To know more about aggregation types, refer this page.

Related articles

Didn’t find what you need?

Contact support