Google Search Console

Guide to integrate your Google Search Console with Sprinkle

Datasource Concepts

Before setting up the datasource, learn about datasource concepts here

Step by Step Guide

STEP-1: Configure Connection

To learn about Connection, refer here

  • Log into Sprinkle application

  • Navigate to Datasources -> 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 Datasource

To learn about datasource, refer here

  • Navigate to Datasources -> Datasources 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. 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_<datasourcename>_<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 on how to use this field.

  • Create

STEP-4: Run and schedule Ingestion

In the Ingestion Jobs tab:

  • Trigger the Job, using Run button

  • To schedule, enable Auto-Run. Change the frequency if required

Dataset Fields

  • siteurl

  • permissionlevel

  • path

  • lastsubmitted

  • ispending

  • issitemapsindex

  • warnings

  • errors

  • event_date

  • clicks

  • impressions

  • ctr

  • position

Last updated