Google Search Console
Google Search Console helps you monitor and maintain your site's presence in Google Search results.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture Deletes | ||
Custom Data | ||
Data Blocking | check | Table level |
Column Hashing | ||
Re-sync | check | Connector level |
History | ||
API Configurable | check | |
Priority-first sync | check | Reporting tables |
dbt Package |
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.
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. The metrics are aggregated by Page. Dimensions include:
- Date
- Country
- Device
- Keyword
- Page
- Search Type (web/image/video)
To know more about aggregation types, refer this page.