Google Ads

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.