Integrate with Google Ads using CData connector. We utilise official CData Python (opens in a new tab) connector to ingest your data.
We support data extraction from all views (opens in a new tab) listed in the official CData documentation.
To connect to Google Ads, you need access to a Google Ads account to proceed with an authorization flow.
Create a new source and enter a Name for it and select "Google Ads (CData)" from a connector type list, then click Create
Create a new secret (or reuse an existing one). Select the only available option to authenticate - OAuth.
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,7890004440'. You need to provide the lowest-level IDs to retrieve data.
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.
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.
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.
- 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.