Google Search Console

This component allows you to extract statistics and site data of domains that are linked to your Google account. Using the Google Search Console API. The component supports the Search Analytics endpoint and the Sitemaps endpoint.

Configuration

Create a new configuration of the Google Search Console extractor. Then click Authorize Account to authorize the configuration.

Screenshot - Component Config

Row configuration

Add a row to the configuration to extract a specific report.

Screenshot - Component Config

Search analytics endpoint

To extract a search analytics report select the “Search analytics” endpoint.

Screenshot - Search analytics Config

  • Fill in the domain to extract data from, it should not contain “https://www.” before the name of the domain.
  • Fill in the dimensions you wish extract data from. Possible dimensions are; country, device, page, query,searchAppearance (searchAppearance cannot be combined with other fields)
  • Select a date range to extract data from, either set dynamic date ranges; last week or last month, or a set custom date range where you specify a date from and a date to. Custom dates can be filled in with :
    • Relative dates like: ‘1 min ago’, ‘2 weeks ago’, ‘3 months, 1 week and 1 day ago’, ‘in 2 days’, ‘tomorrow’.
    • Exact dates like: ‘August 14, 2015 EST’, ‘July 4, 2013 PST’, ‘21 July 2013 10:15 pm +0500’
  • Fill in the output table name. The name should only contain alphanumeric characters and underscores
  • Next you can add filters to the data using the Filters section
    • Filters are managed with filter groups, filters within a group work with AND, therefore all statements must be true. While filter groups work with OR, therefore at least one filter group must be true to return data
  • To create a new filter group click the Add Filter Group button

Screenshot - Search analytics Config

Screenshot - Search analytics Config

  • To create a new filter within a filter group click the Add Filter button and specify the dimension, operator and expression.

When using filters make sure to use the Incremental load option, otherwise there are possibilities for duplicate data.

Screenshot - Search analytics Config

Loading options

There is an option to select a load type, Full load is set by default meaning the table in storage is overwritten every time. Incremental appends new data and updates existing rows in the table using a primary key. The primary key is always set as the dimensions set in the configuration.

Screenshot - Sitemaps Config

Click save and run the configuration.

Sitemaps endpoint

To extract a search analytics report select the “Sitemaps” endpoint.

Screenshot - Sitemaps Config

  • Fill in the domain to get the data from, it should not contain “https://www.” before the name.
  • Fill in the output table name. The name should only contain alphanumeric characters and underscores

Click save and run the configuration.