# Google Search Console

## Pipeline Concepts

Before setting up the pipeline, learn about pipeline concepts [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines)

## Step by Step Guide

### STEP-1: Configure Connection

To learn about Connection, refer [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines)

* Log into Sprinkle application
* Navigate to Ingest -> Connections Tab -> New Connection -> 
* Select Google Search Console
* Provide all the mandatory details
  * *Name*: Name to identify this connection
  * Connect to Google
* After pressing Connect to Google, you will see authorise screen to allow permissions required for sprinkle to read data. Press Allow
* Test Connection
* Create

### STEP-2: Configure Pipeline

To learn about pipeline, refer [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines)

* Navigate to Ingest -> Pipeline Tab -> Add -> 
* Select Google Search Console
* Provide the name -> Create
* **Connection Tab**: 
  * From the drop-down, select the name of connection created in STEP-2
  * Update

### STEP-3: Create Dataset

**Datasets Tab**: To learn about Dataset, refer [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines). Add Dataset for each report/dataset that you want to integrate, providing following details

* *Report Type* (Required) : 
  * *Sites*
  * *Sitemaps*
    * *Site URL*: Select from drop-down
  * *SearchAnalytics*
    * *Site URL*: Select from drop-down
    * *Dimensions*: Search Appearance dimension should be queried alone whereas other dimensions can be queried together.
    * *Start Date*: date from which the data needs to be pulled and ingested, in the YYYY-MM-DD format
    * *Search Type*: Select from Web, Images, Videos
* *Destination Schema* (Required) : Data warehouse schema where the table will be ingested into
* *Destination Table name* (Required) : It is the table name to be created on the warehouse. If not given, sprinkle will create like ds\_\<pipelinename>\_\<tablename>
* *Destination Create Table Clause*: Provide additional clauses to warehouse-create table queries such as clustering, partitioning, and more, useful for optimizing DML statements. [Learn more](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines/databases/features/destination-create-table-clause) on how to use this field.
* Create

### STEP-4: Run and schedule Ingestion

In the **Ingestion Jobs** ta&#x62;**:**

* Trigger the Job, using Run button
* To schedule, enable Auto-Run. Change the frequency if required

### Dataset Fields

<details>

<summary>Sites</summary>

* siteurl
* permissionlevel

</details>

<details>

<summary>Sitemaps</summary>

* path
* lastsubmitted
* ispending
* issitemapsindex
* warnings
* errors

</details>

<details>

<summary>SearchAnalytics</summary>

* event\_date
* clicks
* impressions
* ctr
* position

</details>