# Google Search Console (v1) Information note **Google Search Console extraction is supported by Stitch** This integration is powered by [Singer's](https://www.singer.io/) Google Search Console tap and certified by Stitch. [Check out and contribute to the repo on GitHub](https://github.com/singer-io/tap-google-search-console). For support, contact [Support](https://community.qlik.com/t5/Support/ct-p/qlikSupport). ## Google Search Console integration summary Stitch’s Google Search Console integration replicates data using the [Google Search Console API](https://developers.google.com/webmaster-tools/search-console-api-original/v3/how-tos/search_analytics). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#schema) section for a list of objects available for replication. ## Google Search Console feature snapshot A high-level look at Stitch's Google Search Console (v1) integration, including release status, useful links, and the features supported in Stitch. | **STITCH** | | | | | --- | --- | --- | --- | | **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Released on September 2, 2020 | **Supported by**

the Info icon

Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) | | **Stitch plan**

the Info icon

The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**

the Info icon

Indicates if the integration is available as a source in Stitch Connect. | the Success icon

This version of the integration is available via the API.


Available | | **Singer GitHub repository** | [singer-io/tap-google-search-console](https://github.com/singer-io/tap-google-search-console) | | | | **REPLICATION SETTINGS** | | | | | **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**

the Info icon

A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon

This feature is supported for this version of the integration.


Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**

the Info icon

A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Success icon

This feature is supported for this version of the integration.


Supported | | **Table-level reset**

the Info icon

Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon

Table-level resets are not supported for this integration. Resets are only supported at the integration level.


Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**

the Info icon

Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon

Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.


Unsupported | | **DATA SELECTION** | | | | | **Table selection**

the Info icon

The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.


Supported | **Column selection**

the Info icon

The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.


Supported | | **Select all**

the Info icon

Indicates if the integration supports selecting all available tables and columns. | the Success icon

Supported


Supported | | | | **TRANSPARENCY** | | | | | **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**

the Info icon

Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.


Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**

the Info icon

Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.


Supported | ## Connecting Google Search Console ### Google Search Console setup requirements To set up Google Search Console in Stitch, you need: * **Admin access in Google Search Console**. Admin access is required in your Google Search Console account to change settings required to connect Stitch. ### Step 1: Set up your Google Search Console Information note **If you don’t have any URLs set up in your Google Search Console account**, use the following instructions. Otherwise skip to [step 2](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#create-project). 1. Login to your Google account and navigate to [Google Search Console](https://search.google.com/search-console). 2. Add the domains or websites for your organization. If adding a domain, it will cover all URLs across all of its subdomains. If adding a website, only the entered websites will be counted for. 3. Verify your site ownership by clicking **CONTINUE**. Depending on your verification method, this can take up to a day. 4. Once your link(s) are verified, add them to the `sitemap.xml` files in the **Sitemaps** section of your Google Search Console account. Click **Submit**. ### Step 2: Create a Google Search Console project Information note **If you don’t have a project set up in Google Search Console** use the following instructions. Otherwise skip to [step 3](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#enable-apis). 1. Login to your [**Google Cloud Console**](https://console.cloud.google.com/). 2. Click **Create New Project**. 3. Enter a **Project name** and select a project **Location**. 4. Click **CREATE**. ### Step 3: Enable Google Search Console API 1. Login to your **Google Cloud Platform** account. Make sure you’re in the project that you want to use for your Google Search Console integration. 2. Select **APIs & Services** from the left-hand menu panel. This will take you to the **APIs & Services** dashboard. 3. In the dashboard, click **ENABLE APIS AND SERVICES**. You will be redirected to the **API Library**. 4. Search for Google Search Console and select `Google Search Console API`. 5. Click **ENABLE**. ### Step 4: Verify API domain 1. Staying in the **APIs & Services** section, click on **Domain verification** in the left-hand menu panel. 2. Click **Add domain**. 3. Add the domain you’re using for this project. ### Step 5: API OAuth consent 1. Staying in the **APIs & Services** section, click on the **OAuth consent screen** in the left-hand menu panel. 2. Select your project. 3. Make the **Application type** `Public`. 4. Make the **Application name** `tap-google-search-console`. 5. Optionally, you can add an image for a logo to help you identify your app. 6. In the **Support email** field, enter your email that you will use for this app. 7. In the **Scope** section, click **Add scope**. 8. Add the following scope: `Google Search Console API ../auth/webmasters.readonly`. 9. In the **Authorized domains** section, add the domains that you added to Google Search Console in [step 1](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#set-up-console). 10. Click **SAVE**. 11. You will be taken to a screen that says **OAuth grant limits**. The default limit is 100 grants per minute, per day. You can request to raise the grant limit for your project by clicking **Raise limit**. You can also change the time interval grant resets. The options for time intervals are: `1h`, `6h`, `1d,`, `7d`, and `30d`. ### Step 6: Create OAuth credentials 1. Staying in the **APIs & Services** section, click on **Credentials** in the left-hand menu panel. 2. Click on the **Create credentials** dropdown menu. 3. Select **OAuth client ID**. 4. In the **Create OAuth client ID** page, select **Web application** for the Application type. 5. In the **Name** field, enter `tap-google-search-console`. 6. In the **Authorized redirect URIs** section, add the domains that you added in [step 1](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#set-up-console). 7. Click **CREATE**. ### Step 7: Add Google Search Console as a Stitch data source 1. [Sign into your Stitch account](https://app.stitchdata.com/). 2. On the Stitch Dashboard page, click the **Add Integration** button. 3. Click the **Google Search Console** icon. 4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination. For example, the name “Stitch Google Search Console” would create a schema called `stitch_google_search_console` in the destination. **Note**: Schema names cannot be changed after you save the integration. 5. In the **Site Urls** field, enter the URLs you added to your sitemap file in [step 1](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#set-up-console). The URLs should be comma delimited and begin with `https://` or `http://`. Example: `https://yoursite.com, http://yourothersite.com`. **Note**: If you get an error saying that the user doesn’t have sufficient permissions or that the URL is not a verified Google Search Console site, try replacing `https://` or `http://` with `sc-domain:`. Example: `sc-domain:yoursite.com`. ### Step 8: Define the historical replication start date The Sync Historical Data setting defines the starting date for your Google Search Console integration. This means that data **equal to or newer than this date** will be replicated to your data warehouse. Change this setting if you want to replicate data beyond Google Search Console’s default setting of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide. ### Step 9: Create a replication schedule Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information. In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins. Google Search Console integrations support the following replication scheduling methods: * [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency) * [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling) * [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only) To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage. ### Step 10: Set objects to replicate Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements). The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#schema) **Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts. * Selection options * Individual tables and columns * All tables and columns For Google Search Console integrations, you can select: 1. **Individual tables and columns** 2. **All tables and columns** Click the tabs to view instructions for each selection method. 1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate. 2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate. 3. To track a column, click the **checkbox** next to the column’s name. A blue checkmark means the column is set to replicate. 4. Repeat this process for all the tables and columns you want to replicate. 5. When finished, click the **Finalize Your Selections** button at the bottom of the screen to save your selections. Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature. 1. Click into the integration from the Stitch Dashboard page. 2. Click the **Tables to Replicate** tab. 3. In the list of tables, click the box next to the **Table Names** column. 4. In the menu that displays, click **Track all Tables and Fields**: ![The Track all Tables and Fields menu in the Tables to Replicate tab](https://help.qlik.com/en-US/stitch/images/replication/select-all-tables-menu.png)The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab 5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections. ### Initial and historical replication jobs After you finish setting up Google Search Console, its **Sync Status** may show as **Pending** on either the Stitch Dashboard or in the Integration Details page. For a new integration, a **Pending** status indicates that Stitch is in the process of scheduling the initial replication job for the integration. **This may take some time to complete.** Information note **Initial replication jobs with Anchor Scheduling** If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information. #### Free historical data loads The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota. Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** the integration to prevent unwanted usage. ## Google Search Console table reference Information note **Schemas and versioning** Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing. The schema and info displayed below is for **version 1** of this integration. This is the latest version of the Google Search Console integration. Information note **Table and column names in your destination** Depending on your destination, table and column names may not appear as they are outlined below. For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info. ### 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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | site\_url

search\_type

country

date | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | date | | **Useful links** | [Google Search Console documentation](https://support.google.com/webmasters/answer/7576553?hl=en "Opens in new tab: Google Search Console documentation")


[performance_report_country schema on GitHub](https://github.com/singer-io/tap-google-search-console/blob/master/tap_google_search_console/schemas/performance_report_country.json "Opens in new tab: performance_report_country schema on GitHub")


[Google Search Console API method](https://developers.google.com/webmaster-tools/search-console-api-original/v3/searchanalytics/query "Opens in new tab: Google Search Console API method") | performance\_report\_country table foreign keys | Join performance\_report\_country with | on | | --- | --- | | [sites](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sites) | ```
performance_report_country.site_url = sites.site_url
``` | | [sitemaps](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sitemaps) | ```
performance_report_country.site_url = sitemaps.site_url
``` | | [performance_report_custom](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-custom) | ```
performance_report_country.site_url = performance_report_custom.site_url
```

```
performance_report_country.search_type = performance_report_custom.search_type
``` | | [performance_report_date](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-date) | ```
performance_report_country.site_url = performance_report_date.site_url
```

```
performance_report_country.search_type = performance_report_date.search_type
``` | | [performance_report_device](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-device) | ```
performance_report_country.site_url = performance_report_device.site_url
```

```
performance_report_country.search_type = performance_report_device.search_type
``` | | [performance_report_page](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-page) | ```
performance_report_country.site_url = performance_report_page.site_url
```

```
performance_report_country.search_type = performance_report_page.search_type
``` | | [performance_report_query](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-query) | ```
performance_report_country.site_url = performance_report_query.site_url
```

```
performance_report_country.search_type = performance_report_query.search_type
``` | performance\_report\_country table schema | **clicks**


INTEGER | | --- | | **country**


STRING | | **ctr**


NUMBER | | **date**


DATE-TIME | | **impressions**


INTEGER | | **position**


NUMBER | | **search\_type**


STRING | | **site\_url**


STRING | ### 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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | search\_type

site\_url

dimensions\_hash\_key

date | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | date | | **Useful links** | [Google Search Console documentation](https://support.google.com/webmasters/answer/7576553?hl=en "Opens in new tab: Google Search Console documentation")


[performance_report_custom schema on GitHub](https://github.com/singer-io/tap-google-search-console/blob/master/tap_google_search_console/schemas/performance_report_custom.json "Opens in new tab: performance_report_custom schema on GitHub")


[Google Search Console API method](https://developers.google.com/webmaster-tools/search-console-api-original/v3/searchanalytics/query "Opens in new tab: Google Search Console API method") | performance\_report\_custom table foreign keys | Join performance\_report\_custom with | on | | --- | --- | | [sites](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sites) | ```
performance_report_custom.site_url = sites.site_url
``` | | [sitemaps](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sitemaps) | ```
performance_report_custom.site_url = sitemaps.site_url
``` | | [performance_report_country](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-country) | ```
performance_report_custom.site_url = performance_report_country.site_url
```

```
performance_report_custom.search_type = performance_report_country.search_type
``` | | [performance_report_date](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-date) | ```
performance_report_custom.site_url = performance_report_date.site_url
```

```
performance_report_custom.search_type = performance_report_date.search_type
``` | | [performance_report_device](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-device) | ```
performance_report_custom.site_url = performance_report_device.site_url
```

```
performance_report_custom.search_type = performance_report_device.search_type
``` | | [performance_report_page](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-page) | ```
performance_report_custom.site_url = performance_report_page.site_url
```

```
performance_report_custom.search_type = performance_report_page.search_type
``` | | [performance_report_query](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-query) | ```
performance_report_custom.site_url = performance_report_query.site_url
```

```
performance_report_custom.search_type = performance_report_query.search_type
``` | performance\_report\_custom table schema | **clicks**


INTEGER | | --- | | **country**


STRING | | **ctr**


NUMBER | | **date**


DATE-TIME | | **device**


STRING | | **dimensions\_hash\_key**


STRING | | **impressions**


INTEGER | | **page**


STRING | | **position**


NUMBER | | **query**


STRING | | **search\_type**


STRING | | **site\_url**


STRING | ### 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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | search\_type

site\_url

date | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | date | | **Useful links** | [Google Search Console documentation](https://support.google.com/webmasters/answer/7576553?hl=en "Opens in new tab: Google Search Console documentation")


[performance_report_date schema on GitHub](https://github.com/singer-io/tap-google-search-console/blob/master/tap_google_search_console/schemas/performance_report_date.json "Opens in new tab: performance_report_date schema on GitHub")


[Google Search Console API method](https://developers.google.com/webmaster-tools/search-console-api-original/v3/searchanalytics/query "Opens in new tab: Google Search Console API method") | performance\_report\_date table foreign keys | Join performance\_report\_date with | on | | --- | --- | | [sites](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sites) | ```
performance_report_date.site_url = sites.site_url
``` | | [sitemaps](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sitemaps) | ```
performance_report_date.site_url = sitemaps.site_url
``` | | [performance_report_country](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-country) | ```
performance_report_date.site_url = performance_report_country.site_url
```

```
performance_report_date.search_type = performance_report_country.search_type
``` | | [performance_report_custom](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-custom) | ```
performance_report_date.site_url = performance_report_custom.site_url
```

```
performance_report_date.search_type = performance_report_custom.search_type
``` | | [performance_report_device](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-device) | ```
performance_report_date.site_url = performance_report_device.site_url
```

```
performance_report_date.search_type = performance_report_device.search_type
``` | | [performance_report_page](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-page) | ```
performance_report_date.site_url = performance_report_page.site_url
```

```
performance_report_date.search_type = performance_report_page.search_type
``` | | [performance_report_query](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-query) | ```
performance_report_date.site_url = performance_report_query.site_url
```

```
performance_report_date.search_type = performance_report_query.search_type
``` | performance\_report\_date table schema | **clicks**


INTEGER | | --- | | **ctr**


NUMBER | | **date**


DATE-TIME | | **impressions**


INTEGER | | **position**


NUMBER | | **search\_type**


STRING | | **site\_url**


STRING | ### 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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | search\_type

site\_url

device

date | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | date | | **Useful links** | [Google Search Console documentation](https://support.google.com/webmasters/answer/7576553?hl=en "Opens in new tab: Google Search Console documentation")


[performance_report_device schema on GitHub](https://github.com/singer-io/tap-google-search-console/blob/master/tap_google_search_console/schemas/performance_report_device.json "Opens in new tab: performance_report_device schema on GitHub")


[Google Search Console API method](https://developers.google.com/webmaster-tools/search-console-api-original/v3/searchanalytics/query "Opens in new tab: Google Search Console API method") | performance\_report\_device table foreign keys | Join performance\_report\_device with | on | | --- | --- | | [sites](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sites) | ```
performance_report_device.site_url = sites.site_url
``` | | [sitemaps](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sitemaps) | ```
performance_report_device.site_url = sitemaps.site_url
``` | | [performance_report_country](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-country) | ```
performance_report_device.site_url = performance_report_country.site_url
```

```
performance_report_device.search_type = performance_report_country.search_type
``` | | [performance_report_custom](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-custom) | ```
performance_report_device.site_url = performance_report_custom.site_url
```

```
performance_report_device.search_type = performance_report_custom.search_type
``` | | [performance_report_date](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-date) | ```
performance_report_device.site_url = performance_report_date.site_url
```

```
performance_report_device.search_type = performance_report_date.search_type
``` | | [performance_report_page](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-page) | ```
performance_report_device.site_url = performance_report_page.site_url
```

```
performance_report_device.search_type = performance_report_page.search_type
``` | | [performance_report_query](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-query) | ```
performance_report_device.site_url = performance_report_query.site_url
```

```
performance_report_device.search_type = performance_report_query.search_type
``` | performance\_report\_device table schema | **clicks**


INTEGER | | --- | | **ctr**


NUMBER | | **date**


DATE-TIME | | **device**


STRING | | **impressions**


INTEGER | | **position**


NUMBER | | **search\_type**


STRING | | **site\_url**


STRING | ### 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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | search\_type

site\_url

page

date | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | date | | **Useful links** | [Google Search Console documentation](https://support.google.com/webmasters/answer/7576553?hl=en "Opens in new tab: Google Search Console documentation")


[performance_report_page schema on GitHub](https://github.com/singer-io/tap-google-search-console/blob/master/tap_google_search_console/schemas/performance_report_page.json "Opens in new tab: performance_report_page schema on GitHub")


[Google Search Console API method](https://developers.google.com/webmaster-tools/search-console-api-original/v3/searchanalytics/query "Opens in new tab: Google Search Console API method") | performance\_report\_page table foreign keys | Join performance\_report\_page with | on | | --- | --- | | [sites](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sites) | ```
performance_report_page.site_url = sites.site_url
``` | | [sitemaps](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sitemaps) | ```
performance_report_page.site_url = sitemaps.site_url
``` | | [performance_report_country](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-country) | ```
performance_report_page.site_url = performance_report_country.site_url
```

```
performance_report_page.search_type = performance_report_country.search_type
``` | | [performance_report_custom](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-custom) | ```
performance_report_page.site_url = performance_report_custom.site_url
```

```
performance_report_page.search_type = performance_report_custom.search_type
``` | | [performance_report_date](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-date) | ```
performance_report_page.site_url = performance_report_date.site_url
```

```
performance_report_page.search_type = performance_report_date.search_type
``` | | [performance_report_device](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-device) | ```
performance_report_page.site_url = performance_report_device.site_url
```

```
performance_report_page.search_type = performance_report_device.search_type
``` | | [performance_report_query](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-query) | ```
performance_report_page.site_url = performance_report_query.site_url
```

```
performance_report_page.search_type = performance_report_query.search_type
``` | performance\_report\_page table schema | **clicks**


INTEGER | | --- | | **ctr**


NUMBER | | **date**


DATE-TIME | | **impressions**


INTEGER | | **page**


STRING | | **position**


NUMBER | | **search\_type**


STRING | | **site\_url**


STRING | ### 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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | search\_type

site\_url

query

date | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | date | | **Useful links** | [Google Search Console documentation](https://support.google.com/webmasters/answer/7576553?hl=en "Opens in new tab: Google Search Console documentation")


[performance_report_query schema on GitHub](https://github.com/singer-io/tap-google-search-console/blob/master/tap_google_search_console/schemas/performance_report_query.json "Opens in new tab: performance_report_query schema on GitHub")


[Google Search Console API method](https://developers.google.com/webmaster-tools/search-console-api-original/v3/searchanalytics/query "Opens in new tab: Google Search Console API method") | performance\_report\_query table foreign keys | Join performance\_report\_query with | on | | --- | --- | | [sites](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sites) | ```
performance_report_query.site_url = sites.site_url
``` | | [sitemaps](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sitemaps) | ```
performance_report_query.site_url = sitemaps.site_url
``` | | [performance_report_country](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-country) | ```
performance_report_query.site_url = performance_report_country.site_url
```

```
performance_report_query.search_type = performance_report_country.search_type
``` | | [performance_report_custom](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-custom) | ```
performance_report_query.site_url = performance_report_custom.site_url
```

```
performance_report_query.search_type = performance_report_custom.search_type
``` | | [performance_report_date](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-date) | ```
performance_report_query.site_url = performance_report_date.site_url
```

```
performance_report_query.search_type = performance_report_date.search_type
``` | | [performance_report_device](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-device) | ```
performance_report_query.site_url = performance_report_device.site_url
```

```
performance_report_query.search_type = performance_report_device.search_type
``` | | [performance_report_page](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-page) | ```
performance_report_query.site_url = performance_report_page.site_url
```

```
performance_report_query.search_type = performance_report_page.search_type
``` | performance\_report\_query table schema | **clicks**


INTEGER | | --- | | **ctr**


NUMBER | | **date**


DATE-TIME | | **impressions**


INTEGER | | **position**


NUMBER | | **query**


STRING | | **search\_type**


STRING | | **site\_url**


STRING | ### sitemaps The `sitemaps` table contains information about the sitemap entries in your Google Search Console. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | site\_url

path

last\_submitted | | **Useful links** | [Google Search Console documentation](https://developers.google.com/webmaster-tools/search-console-api-original/v3/sitemaps "Opens in new tab: Google Search Console documentation")


[sitemaps schema on GitHub](https://github.com/singer-io/tap-google-search-console/blob/master/tap_google_search_console/schemas/sitemaps.json "Opens in new tab: sitemaps schema on GitHub")


[Google Search Console API method](https://developers.google.com/webmaster-tools/search-console-api-original/v3/sitemaps/list "Opens in new tab: Google Search Console API method") | sitemaps table foreign keys | Join sitemaps with | on | | --- | --- | | [sites](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sites) | ```
sitemaps.site_url = sites.site_url
``` | | [performance_report_country](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-country) | ```
sitemaps.site_url = performance_report_country.site_url
``` | | [performance_report_custom](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-custom) | ```
sitemaps.site_url = performance_report_custom.site_url
``` | | [performance_report_date](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-date) | ```
sitemaps.site_url = performance_report_date.site_url
``` | | [performance_report_device](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-device) | ```
sitemaps.site_url = performance_report_device.site_url
``` | | [performance_report_page](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-page) | ```
sitemaps.site_url = performance_report_page.site_url
``` | | [performance_report_query](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-query) | ```
sitemaps.site_url = performance_report_query.site_url
``` | sitemaps table schema | **contents**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand contents

indexed

INTEGER

submitted

INTEGER

type

STRING

| | --- | | **errors**


INTEGER | | **is\_pending**


BOOLEAN | | **is\_sitemaps\_index**


BOOLEAN | | **last\_downloaded**


DATE-TIME | | **last\_submitted**


DATE-TIME | | **path**


STRING | | **site\_url**


STRING | | **type**


STRING | | **warnings**


INTEGER | ### sites The `sites` contains information about your Google Search Console sites at a permission level. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | site\_url | | **Useful links** | [Google Search Console documentation](https://developers.google.com/webmaster-tools/search-console-api-original/v3/sites "Opens in new tab: Google Search Console documentation")


[sites schema on GitHub](https://github.com/singer-io/tap-google-search-console/blob/master/tap_google_search_console/schemas/sites.json "Opens in new tab: sites schema on GitHub")


[Google Search Console API method](https://developers.google.com/webmaster-tools/search-console-api-original/v3/sites/get "Opens in new tab: Google Search Console API method") | sites table foreign keys | Join sites with | on | | --- | --- | | [sitemaps](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#sitemaps) | ```
sites.site_url = sitemaps.site_url
``` | | [performance_report_country](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-country) | ```
sites.site_url = performance_report_country.site_url
``` | | [performance_report_custom](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-custom) | ```
sites.site_url = performance_report_custom.site_url
``` | | [performance_report_date](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-date) | ```
sites.site_url = performance_report_date.site_url
``` | | [performance_report_device](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-device) | ```
sites.site_url = performance_report_device.site_url
``` | | [performance_report_page](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-page) | ```
sites.site_url = performance_report_page.site_url
``` | | [performance_report_query](https://help.qlik.com/en-US/stitch/integrations/saas/google-search-console#performance-report-query) | ```
sites.site_url = performance_report_query.site_url
``` | sites table schema | **permission\_level**


STRING | | --- | | **site\_url**


STRING |