Google Ads

Pipeline Concepts

Before setting up the pipeline, learn about pipeline concepts here

To learn about Connection, refer here

Log into Sprinkle application
Navigate to Import -> 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

To learn about pipeline, refer here

Navigate to Ingest -> Pipeline 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

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_<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 on how to use this field.
Create

In the Ingestion Jobs tab: