Product Docs
  • What is Dataworkz?
  • Getting Started
    • What You Will Need
    • Advanced RAG Quickstart
      • Configure LLM's
        • AWS Bedrock
      • Connecting Your Data
        • Finding Your Data Storage: Collections
      • Ingesting Unstructured Data
      • Create Vector Embeddings
        • How to Build the Vector embeddings from Scratch
        • How do Modify Existing Chunking/Embedding Dataflows
      • Response History
    • Embed RAG into your App
    • Data Lake to Salesforce
  • Concepts
    • Datasets
    • No-code Transformations
    • Lineage
      • Features of Lineage:
      • Viewing a dataset's lineage:
    • Discovery
      • How to: Discovery
    • Dataflows
      • Single Dataflows:
      • Composite dataflows:
      • Benefits of Dataflows:
  • Guides
    • Working With Rag Applications
      • High Precision RAG
      • Advanced RAG - Access Control for your data corpus
      • Creating RAG Experiments with Dataworkz
      • Embedding Models
        • Privately Hosted Embedding Models
        • Amazon Bedrock Hosted Embedding Model
        • OpenAI Embedding Model
      • Unstructured Data Ingestion
        • File Ingestion
        • Html/Sharepoint Ingestion
    • Transformation Functions
      • Column Transformations
        • String Operations
          • Format Operations
          • String Calculation Operations
          • Remove Stop Words Operation
          • Fuzzy Match Operation
          • Masking Operations
          • 1-way Hash Operation
          • Copy Operation
          • Unnest Operation
          • Convert Operation
          • Vlookup Operation
        • Numeric Operations
          • Tiles Operation
          • Numeric Calculation Operations
          • Custom Calculation Operation
          • Numeric Encode Operation
          • Mask Operation
          • 1-way Hash Operation
          • Copy Operation
          • Convert Operation
          • VLookup Operation
        • Boolean Operations
          • Mask Operation
          • 1-way Hash Operation
          • Copy Operation
        • Date Operations
          • Date Format Operations
          • Date Calculation Operations
          • Mask Operation
          • 1-way Hash Operation
          • Copy Operation
          • Encode Operation
          • Convert Operation
        • Datetime/Timestamp Operations
          • Datetime Format Operations
          • Datetime Calculation Operations
          • Mask Operation
          • 1-way Hash Operation
          • Copy Operation
          • Encode Operation
          • Page 1
      • Dataset Transformations
        • Utility Functions
          • Area Under the Curve
          • Page Rank Utility Function
          • Transpose Utility Function
          • Semantic Search Template Utility Function
          • New Header Utility Function
          • Transform to JSON Utility Function
          • Text Utility Function
          • UI Utility Function
        • Window Functions
        • Case Statement
          • Editor Query
          • UI Query
        • Filter
          • Editor Query
          • UI Query
    • Working with CSV files
    • Connect to data source(s)
      • Cloud Data Platforms
        • AWS S3
        • BigQuery
        • Google Cloud Storage
        • Azure
        • Snowflake
        • Redshift
        • Databricks
      • Databases
        • MySQL
        • Microsoft SQL Server
        • Oracle
        • MariaDB
        • Postgres
        • DB2
        • MongoDB
        • Couchbase
        • Aerospike
        • Pinecone
      • SaaS Applications
        • Google Ads
        • Google Analytics
        • Marketo
        • Zoom
        • JIRA
        • Salesforce
        • Zendesk
        • Hubspot
        • Outreach
        • Fullstory
        • Pendo
        • Box
        • Google Sheets
        • Slack
        • OneDrive / Sharepoint
    • IP safelist
    • Data Prep
      • Joins
        • Configuring a Join
      • Union
        • Configuring a Union
    • Job Monitoring
    • Authentication
    • User Management
  • API
    • Generate API Key in Dataworkz
  • Open Source License Types
Powered by GitBook
On this page
  • Create Connector for Google Ads
  • Add Configuration
  1. Guides
  2. Connect to data source(s)
  3. SaaS Applications

Google Ads

PreviousSaaS ApplicationsNextGoogle Analytics

Last updated 8 months ago

This document describes the Dataworkz connector configuration required to access Google Ads. Dataworkz requires one of the following OAuth setup before proceeding with the configuration

  1. OAuth

  2. Service Account Outh

OAuth

Ensure that user's domain has access to the Google Ads property. This can be done by navigating to Settings -> "Access & Security" of the appropriate Google Ads account and adding domain of the user to the domain.

Service Account

In order to setup service account OAuth follow the Setup Service Account instructions. Ensure that service account that has been created has access to the Google Ads property. This can be done by navigating to Settings -> "Access & Security" of the appropriate Google Ads account and adding domain of the service account to the domain.

After this goto “APIs & Services” -> “Enabled APIs & services” and enable the following.

  1. Google Ads API

Create Connector for Google Ads

  1. Login to Dataworkz Application

  2. Goto Configuration -> SaaS Applications -> Google Ads

  3. Click the + icon to add a new configuration

  1. Enter name for the configuration in the above screen

  2. Select the authentication option for your account (OAuth / Service Account OAuth)

OAuth

  1. This requires using Google OAuth to authorize Dataworkz to access Google Ads

  2. Select the workspace & collection

  3. Click Save

Service Account OAuth

  1. Enter the developer token

  2. Enter the Client ID

  3. Enter the Client email ID

  4. Select the certification option & type

  5. Enter the Private Key

  6. Test the connection

  7. If successful select the workspace & collection

  8. Click Save

Newly created connector would show up in the list of Google Ads configurations

Add Configuration

Click the newly created connector and then click + icon to add configuration for Google Ads

  1. Provide name for the dataset comprising the ads data

  2. Select the account to sync

  3. Select the report

  4. Select fields to be collected

  5. Select either a date range or “all historical records”

  6. Enable/disable recurring job

  7. Click Add

This would complete the Dataworkz configuration for Google Ads