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 | check | Column level and table level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | ||
| API configurable | check | |
| Priority-first sync | check | Reporting tables |
| Private networking | ||
| Fivetran data models |
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 the ERD in a 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/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 it’s 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 it’s corresponding metrics. Dimensions include:
- Date
- Country
- Device
- Pages
- 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
- 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
- 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
- Page
- Search Type (web/image/video/news)
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.