Google Ads

Guide to integrate your Google Ads data to 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 Ads

• Provide all the mandatory details

  • Name: Name to identify this connection

  • Developer Token: Sign in MANAGER ACCOUNT, then navigate to TOOLS & SETTINGS > SETUP > API Center. for more details -> Google docs

  • Client Id: This is present at top right corner near to account id.

• Connect to Google

• Test Connection

• Create

STEP-2: Configure Datasource

To learn about datasource, refer here

• Navigate to Datasources -> Datasources Tab -> Add ->

• Select Google Ads

• 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

• Table Type (Required)

  • CampaignData

    • CampaignData Name(Required)

      • adgroup

      • campaign

  • Reports

    • Report Name( Required)

      • ad_performance_report

      • campaign_performance_report

      • keywords_performance_report

      • search_query_performance_report

  • Query

    • AWQL: Only reports type queries are supported

• 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 needed