Skip to main content Skip to complementary content

Google Search Console 

Google Search Console provides information on how Google crawls, indexes, and serves websites.

Google Search Console integration replicates data using the Google Search Console API.

See the Schema section for a list of objects available for replication.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Information noteMake sure that the account you use has read access to the tables you want to fetch.

The Admin access persmission is required in your Google Search Console account to change settings required for the connection.

To obtain your client ID and secret:

  1. Log into your Google Search Console account.
  2. Create or select a project.
  3. Select the Credentials tab on the left.
  4. Select your OAuth app in the OAuth 2.0 Client IDs section. The client ID and secret are displayed.
  5. Make sure Authorized Redirect URIs is set to https://connector.qlik.com/auth/oauth/v3.htm.
  6. To create a new client ID, click Create Credentials.

Creating the connection

For more information, see Connecting to SaaS applications.

  1. Click Authenticate when you have filled in the required connection settings.

    You may be asked to log in to the source application.

    A window is displayed with an authentication code.

  2. Copy the code to the clipboard and return to the connection dialog.

  3. Paste the code in Complete authentication with the code provided by the source and click Verify.

    Tip noteYou may need to scroll down to see this field.

    When status is Verified, the authentication is verified.

  4. Provide a name for the connection in Connection name.

  5. Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings
SettingDescription
Data gateway

Select a Data Movement gateway if required by your use case.

Information note

This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.

For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement.

Start Date

Enter the date, in the format MM/DD/YYYY, from which the data must be replicated from your source to your target.

Site URLsThe URL for the site from which you are collecting search data.

Example: https://www.qlik.com

Client IDClient ID.
Client SecretClient secret.

Schema

Information note

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

Depending on your destination, table and column names may not appear as they are outlined below.

performance_report_country

The performance_report_country table contains information about the performance of your sites in Google searches. This particular table is filtered and grouped by country.

Replication Method

CDC

Primary Keys

site_url

search_type

country

date

Replication Key

date

Useful links

Google Search Console documentation

Google Search Console API method

performance_report_custom

The performance_report_custom table contains information about the performance of your sites in Google searches. This particular table is filtered and grouped by your custom dimensions.

Replication Method

CDC

Primary Keys

search_type

site_url

dimensions_hash_key

date

Replication Key

date

Useful links

Google Search Console documentation

Google Search Console API method

performance_report_date

The performance_report_date table contains information about the performance of your sites in Google searches. This particular table is filtered and grouped by date.

Replication Method

CDC

Primary Keys

search_type

site_url

date

Replication Key

date

Useful links

Google Search Console documentation

Google Search Console API method

performance_report_device

The performance_report_device table contains information about the performance of your sites in Google searches. This particular table is filtered and grouped by the user’s device type.

Replication Method

CDC

Primary Keys

search_type

site_url

device

date

Replication Key

date

Useful links

Google Search Console documentation

Google Search Console API method

performance_report_page

The performance_report_page table contains information about the performance of your sites in Google searches. This particular table is filtered and grouped by your landing page URLs that show up in Google search results.

Replication Method

CDC

Primary Keys

search_type

site_url

page

date

Replication Key

date

Useful links

Google Search Console documentation

Google Search Console API method

performance_report_query

The performance_report_query table contains information about the performance of your sites in Google searches. This particular table is filtered and grouped by the users’ search queries that resulted in your sites appearing in the search results.

Replication Method

CDC

Primary Keys

search_type

site_url

query

date

Replication Key

date

Useful links

Google Search Console documentation

Google Search Console API method

sitemaps

The sitemaps table contains information about the sitemap entries in your Google Search Console.

Replication Method

Full Table

Primary Keys

site_url

path

last_submitted

Useful links

Google Search Console documentation

Google Search Console API method

sites

The sites contains information about your Google Search Console sites at a permission level.

Replication Method

Full Table

Primary Key

site_url

Useful links

Google Search Console documentation

Google Search Console API method

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!