Google Ads

Overview

Integrate with Google Ads using CData connector. We utilise official CData Python (opens in a new tab) connector to ingest your data.

Features

Feature NameSupported
Full ImportYes
Incremental ImportYes

Supported streams

We support data extraction from all views (opens in a new tab) listed in the official CData documentation.

Getting started

Requirements and prerequisites

To connect to Google Ads, you need access to a Google Ads account to proceed with an authorization flow.

Set up guide

Create a source

Create a new source and enter a Name for it and select "Google Ads (CData)" from a connector type list, then click Create

Configure a secret

Create a new secret (or reuse an existing one). Select the only available option to authenticate - OAuth.

Configure Customer ID

Enter a comma-separated list of the Customer ID(s) (opens in a new tab) for your account. You can specify multiple IDs by separating them with a comma. The format is a 10-digit number without dashes or spaces. Example: '1230004560' or '1230004560,7890004440'. You need to provide the lowest-level IDs to retrieve data.

(Optional) Specify Manager ID

If your account has access directly to the client customer account as a User, this property is not required. If access to a client customer account is inherited only through a manager account, this property is required and must be set to the customer ID of the manager account. In other words, the client customer's Tools & Settings --> Account Access must show your email under the Users tab in order to access the account without this property, otherwise, access has been granted via the manager account, under the Managers tab.

(Optional) Start Date

There is an option to configure a start date for Campaign and AdGroup tables. Note that this date will work only for those two and will not affect other tables.

Schema configuration

Configure the schema by selecting desired columns and tables. Please consider the limitations Google API has that are mentioned below in terms of column dependencies.

Limitations

  • Google Ads does not allow every column to be selected as some metrics, segments, and attributes will conflict if selected together. Therefore, avoid selecting all columns in a table that contains multiple dimensions and segments. You can validate your selection using Google's query builder (opens in a new tab).
  • Not all tables allow incremental imports, as Google does not always provide a feasible incremental key.