Google Search Console: Setup guide

On this page

This guide explains how to collect data from Google Search Console.

Limitations

Collecting data from Google Search Console comes with the following limitations:

Google Search Console keeps data for the last 16 months. You cannot fetch older data.
Data from the last 2 to 3 days may not yet be available, as Google Search Console takes 2 to 3 days to finalize data. If you need to collect the most recent unconfirmed data, enable the Include fresh data (not finalized yet) setting. For more information, see Configuring data collection from Google Search Console.
The searchAppearance dimension, cannot be used with any other dimensions.
The hour dimension retrieves data for up to 10 latest days with an hourly breakdown. No data can be retrieved for dates beyond the 10 day lookback window.

Creating a datastream to collect data from Google Search Console

The basics of creating a datastream to collect data from any data source are explained in our guide to Collecting data in Adverity. This guide contains information about the specific steps to create a datastream to fetch data from Google Search Console.

Authorization: Allow Adverity to access Google Search Console

If you choose Access using your credentials or Access using someone else’s credentials, in Set up or edit Site URLs, you or the person granting access must choose one of the following options:
- Choose Grant access to all items, including those created in the future to give Adverity Site URLs to access all existing items and all items created in the future.
- Choose Select specific items to which you want to grant access to only give Adverity Site URLs to access the selected items. Adverity will not automatically have access to items created in the future. You will need to grant Adverity access to any items created in the future.
Warning
If you use your credentials to grant Adverity access to Google Search Console, all the items available to you using your credentials will be visible in the Authorizations page to all Adverity users with permission to edit this authorization.
If someone else uses their credentials to grant Adverity access to Google Search Console, the same applies to the items available using their credentials.
This is important to consider if you do not want all Adverity users with permission to edit the authorization to be able to see the details of the authorization items. For more information about user permissions, see Managing user permissions.

Configuration: Choose the data you want to collect from Google Search Console

To choose what data to collect and customize the Google Search Console datastream configuration, follow these steps:

(Optional) Rename your datastream.
In Report type, select the type of data to collect from Google Search Console.
In Site URLs, select the websites for which to collect data. If you do not select any items in a drop-down list, Adverity collects data for all items in the drop-down list.
In Dimensions, change the list of fields that you want to see in your data extract.

What’s next?

Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.
Transform your data to meet your needs by creating and applying transformations to your datastream.
Load your data into a warehouse to continue working with your data in Adverity.
Load your data into an external destination of your choice.

Advanced Google Search Console tips

Configuring data collection from Google Search Console

In the Settings tab of your Google Search Console datastream overview, you can configure a number of additional settings:

Search type

Select the Google search type for which to collect data. This option only has an effect if you select Search Analytics in the Report type field.

Aggregation type

To specify how Adverity aggregates the collected data, select one of the following options:

(Default) Select Auto (Let the service decide) to let Google Search Console decide the appropriate aggregation type
Select Aggregate values by URI to aggregate data by page
Select Aggregate values by property to aggregate data by property

For more information on aggregating Google Search Console data, see the Google Search Console API documentation.

Filters

To include only specific dimension values in the data extract, specify dimension filters in JSON format. You can use the operators contains, equals, notContains, notEquals.

An example is shown below:

[ { "dimension": "column1", "operator": "notContains", "expression": "value1" }, { "dimension": "column1", "operator": "notContains", "expression": "value2" }, { "dimension": "column2", "operator": "contains", "expression": "value3" } ]

Include preliminary data

Select this checkbox to collect the most recent data which has not yet been confirmed. This is usually data from the last three days.

Include fresh data (not finalized yet)

Select this checkbox to include fresh (not finalized) data. This setting is ignored when the hour dimension is selected, as hourly data may be partial.

Troubleshooting

PERMISSION_DENIED error when collecting data from Google Search Console

When collecting data from Google Search Console, a PERMISSION_DENIED error is raised if access to a configured Site URL is lost.