# Google Search Console
## Snapshot
| Features | Details |
| ------------------------------- | ----------------------------------------------------------------------------------------------------- |
| Release Status | Released |
| Source API Version | v3 |
| Table Selection | Yes |
| Column Selection | Yes |
| Edit Integration | Yes |
| Replication Type Selection | No |
| Authentication Parameters | Google Search Console email
Google Search Console password
Google Search Console siteUrl
|
| Replication Type | Key Based Incremental
Full based replication
|
| Replication Key | NA
Date
|
| Suggested Replication Frequency | 24 hrs |
| Tables/APIs Supported | |
| --------------------- | -------- |
| sites | sitemaps |
| searchanalytics | |
## GSC Tables Support in Daton
### **Table 1 - Sites**
Purpose: Lists the user's Search Console sites.
Click [here](https://developers.google.com/webmaster-tools/search-console-api-original/v3/sites) to be taken to the Google Search Console API Documentation for Sites API
Replication: Full Replication
Replication Key: NA
#### **Fields**
| Name | Target Datatype |
| --------------- | --------------- |
| siteUrl | STRING |
| permissionLevel | STRING |
###
### **Table 2 - Sitemaps**
Purpose:Lists the sitemaps-entries submitted for the site.
Click [here](https://developers.google.com/webmaster-tools/search-console-api-original/v3/sitemaps/list) to be taken to the Google Search Console API Documentation for Sitemaps API
Source API Documentation
Replication: Full Replication
Replication Key: NA
**Fields**
| Name | Target Datatype |
| --------------- | --------------- |
| path | STRING |
| isPending | BOOLEAN |
| isSitemapsIndex | BOOLEAN |
| type | STRING |
| lastDownloaded | STRING |
| warnings | STRING |
| errors | STRING |
| contents | RECORD |
{% hint style="info" %}
**Please note that sites and sitemap tables are loaded fully everytime a replication job runs. It is recommended to create separate integrations for sites and sitemap tables and not combine them with SearchAnalytics tables.**
{% endhint %}
### **Table 3 - SearchAnalytics**
**Purpose:** Query your search traffic data with filters and parameters that you define. The method returns zero or more rows grouped by the row keys (dimensions) that you define. You must define a date range of one or more days.
{% hint style="info" %}
Users can create multiple tables with different dimensions to extract aggregated data from Google Search Console.
{% endhint %}
Go to [**Step 3**](https://docs.sarasanalytics.com/integrations/data-sources/saas-integrations/google-search-console#step-3-configure-the-tables-to-replicate-to-the-data-warehouse) to see how to configure SearchAnalytics table.
Replication: Key based Replication
Replication Key: lastRunDate
**Fields**
| Name | Target Datatype |
| ------------ | --------------- |
| keys | STRING |
| clicks | NUMERIC |
| impresssions | NUMERIC |
| ctr | NUMERIC |
| position | NUMERIC |
## **Setting up Google Search Console Integration in Daton**
### **Step 1: Enter Integration Parameters**
### **Step 2: Enter the site URL**
{% hint style="info" %}
This parameter is **highly** sensitive. and sarasanalytics.com may take you to the same page, but they are considered as different by the Google Search Console APIs
{% endhint %}
### **Step 3: Configure the tables to replicate to the data warehouse**
Submit the integration once you are satisfied with the selections made.
## What happens once I hit Submit?
1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully in to the configured warehouse
2. Users would be able to edit/pause/re-activate/delete integration anytime
3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Click [here](https://developers.google.com/webmaster-tools/search-console-api-original/v3/searchanalytics) to be taken to the Google Search Console API Documentation.