Google Search Console is Google’s free web service that helps you monitor, maintain, and troubleshoot your site’s presence in Google Search results. It provides Search performance analytics, such as search queries, clicks, impressions, and average ranking positions, along with tools to submit sitemaps, inspect URLs, and identify indexing issues, enabling you to improve your site’s visibility in Google Search.
Hevo uses the Google Search Console API to replicate data from your Google account to the Destination of your choice. To ingest data, you must authenticate your account with Hevo using Open Authorization (OAuth).
Supported Features
| Feature Name | Supported |
|---|---|
| Capture deletes | No |
| History mode | No |
| Custom data (user-configured tables & fields) | No |
| Data blocking (skip objects and fields) | Yes |
| Resync (objects and Pipelines) | Yes |
| API configurable | No |
Prerequisites
-
An active Google Search Console account with at least one verified property (site) to ingest data from.
-
You have Owner or Full user permission for the properties you want to sync, so that you can grant Hevo the required access during authentication.
Configure Google Search Console as a Source in your Pipeline
Perform the following steps to configure your Google Search Console Source:
-
Click Pipelines in the Navigation Bar.
-
Click + Create Pipeline in the Pipelines List View.
-
On the Select Source Type page, select Google Search Console.
-
On the Select Destination Type page, select the type of Destination you want to use.
-
On the Select Pipeline Type page, click Edge, and then click Continue.
This page appears only if the selected Destination type is supported in Edge and your Team has an existing Google Search Console Pipeline with the same Destination type. Otherwise, you can proceed to create an Edge Pipeline.
-
In the Configure Source screen, specify the following:
-
Source Name: A unique name for your Source, not exceeding 255 characters. For example, Google Search Console Source.
-
In the Connect to your Google Search Console account section, click Authenticate With Google Search Console, log in to your Google account, and grant Hevo access to your account.
-
From the Sites sync mode drop-down, select whether Hevo syncs data for all sites accessible to the authenticated account, or only specific ones:
-
Sync all sites: Hevo syncs data for all properties accessible to your authorized Google account, including any properties added later.
-
Sync specific sites: Hevo syncs data only for the properties you select from the Sites to sync drop-down.
-
-
Historical Sync Duration: From the drop-down, select the duration for which you want to ingest existing data from the Source. This cannot be changed after the Pipeline is created. Default value: 12 months.
-
-
Click Test & Continue to test the connection to your Google Search Console Source. Once the test is successful, you can proceed to set up your Destination.
Data Replication
Hevo replicates data for all the objects selected on the Configure Objects page during Pipeline creation. By default, all supported objects and their available fields are selected. However, you can modify this selection while creating or editing the Pipeline.
Hevo ingests the following types of data from your Source objects:
-
Historical Data: The first run of the Pipeline ingests historical data for the selected objects, based on the Historical Sync Duration specified when configuring the Source, and loads it into the Destination.
-
Incremental Data: Once the historical load is complete, new and updated records for objects are ingested as per the sync frequency.
For the Sitemap object, Hevo ingests the entire data in subsequent Pipeline runs. For all other objects, Hevo ingests only the incremental data in subsequent Pipeline runs.
Google Search Console enforces a rate limit on the number of calls that can be made to its API in a given time period. If these limits are exceeded, a rate limit exception occurs. To understand how Hevo handles such scenarios, read Handling Rate Limit Exceptions.
You can create a Pipeline with this Source only using the Merge load mode. The Append mode is not supported for this Source.
Schema and Primary Keys
Hevo uses the following schema to upload the records to the Destination. For a detailed view of the objects, fields, and relationships, click the ERD.
Data Model
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
| Object | Description |
|---|---|
| Hourly Keyword Page Report | Contains hourly search performance data for each keyword and page, including clicks, impressions, click-through rate, and average search position. |
| Hourly Keyword Site Report By Page | Contains hourly search performance data for each keyword, with metrics calculated separately for each page. |
| Hourly Keyword Site Report By Site | Contains hourly search performance data for each keyword, with metrics calculated for your entire site. |
| Hourly Page Report | Contains hourly search performance data for each page on your site, including clicks, impressions, click-through rate, and average search position. |
| Hourly Site Report By Page | Contains hourly search performance data for your site, with metrics calculated separately for each page. |
| Hourly Site Report By Site | Contains hourly search performance data for your site, with metrics calculated for the entire site. |
| Keyword Page Report | Contains daily search performance data for each keyword and page, including clicks, impressions, click-through rate, and average search position. |
| Keyword Search Appearance Page Report | Contains daily search performance data for each keyword and page, including the search result feature where the page appeared. |
| Keyword Search Appearance Site Report | Contains daily search performance data for each keyword and search result feature across your site. |
| Keyword Site Report By Page | Contains daily search performance data for each keyword, with metrics calculated separately for each page. |
| Keyword Site Report By Site | Contains daily search performance data for each keyword, with metrics calculated for your entire site. |
| Page Overview Report | Contains an overview of daily search performance data for each page on your site. |
| Page Report | Contains daily search performance data for each page on your site, including clicks, impressions, click-through rate, and average search position. |
| Pages | Contains information about pages on your site that have appeared in Search results. |
| Search Appearance Page Report | Contains daily search performance data for each page and the search result feature in which the page appeared. |
| Search Appearance Site Report | Contains daily search performance data for the search result features in which your site appeared. |
| Site Overview Report | Contains an overview of daily search performance data for your site. |
| Site Report By Page | Contains daily search performance data for your site, with metrics calculated separately for each page. |
| Site Report By Site | Contains daily search performance data for your entire site. |
| Sitemap | Contains information about the files that tell Google which pages are available on your site, including the sitemap path and type, the number of URLs submitted, any warnings or errors, and when the file was last submitted and downloaded by Google. |
Additional Information
Read the detailed Hevo documentation for the following related topics:
Source Considerations
- The data for most reports from Google Search Console usually becomes available to site owners after 2-3 days. This happens because reports in Google Search Console are not updated in real-time.