Google Ads Connection
See the Connector Marketplace topic. Please request your administrator to start a trial or subscribe to the Premium Google Ads connector.
Google Ads is a versatile cloud-based tool that integrates the functionality of spreadsheets and databases, making it ideal for a wide range of applications.
This topic describes how to authenticate to Google Ads and configure any necessary connection properties in the Google Ads connection connector.
Prerequisites
Enable the Google Ads API
Follow these steps to enable the Google Ads API:
Navigate to the Google Cloud Console.
Select Library from the left-hand navigation menu. This opens the Library page.
In the search field, enter “Google Ads API” and select Google Ads API from the search results.
On the Google Ads API page, click ENABLE.
Connection Configuration
Each connection property available in the Google Ads connector is explained below.
Connection Name
The name of the connection to be created should be provided. This is the name that will display on the list of available connections.
Developer Token
The developer token of the Google Ads account.
To retrieve your developer token, sign in to your manager account.
You must be signed in to a Google Ads manager account before continuing.
Navigate to TOOLS & SETTINGS > SETUP > API Center.
This option appears only for Google Ads manager accounts.
If your developer token is pending approval, you can start developing immediately with the pending token you received during signup, using a test manager account.
Your pending developer token must be approved before using it with production Google Ads accounts.
Client Customer ID(s)
The client customer Ids of the Google Ads account.
You can find this value in your Google Ads account. This value is not the same as the Id of the MCC account.
You need to provide the lowest-level Ids to retrieve data.
This is useful when you have a Google Ads MCC account that includes numerous accounts/ClientCustomerIds.
You can specify multiple IDs by separating them with a comma, or you can get all IDs by setting the value to All.
Example: 2055114546,3055114546
Or mention the Client Customer Id(s) as All.
You can also query and get data from the accounts you want by specifying Customer Id(s) in the WHERE clause, during Google Ads data source connector configuration, in the Query field.
The Client Customer Id(s) connection property will be ignored if you specify the Customer Id in the WHERE clauses during Google Ads data source connector configuration, in the Query field.
Auth Scheme
The type of authentication to use when connecting to Google Ads.
Possible Values
OAuth2
Set this to use OAuth2 authentication.
If OAuth2 is selected, additional configuration parameters will get listed.
Client ID
The client ID assigned when you register your application with an OAuth authorization server.
Client Secret
The client secret assigned when you register your application with an OAuth authorization server.
Refresh Token
The OAuth refresh token for the corresponding OAuth access token.
Service Account
Set this to use Service Account as authentication.
If Service Account is selected, additional configuration parameters will get listed.
Certificate Type
The type of key store containing the Service Account Certificate.
Possible Values
JSON
Set this to use a certificate with type as JSON, for authentication.
If JSON is selected, proceed by providing the Certificate Subject and uploading the keystore file.
PFX
Set this to use a certificate with type as P12, for authentication.
If PFX is selected, additional configuration parameters will get listed.
Certificate Issuer: Set this to the email address of the service account. This address will usually include the domain iam.gserviceaccount.com.
Certificate Password: Set this to the .pfx file password. In most cases you must provide this since Google encrypts PFX certificates.
Certificate Subject
The service account should be part of a GSuite domain, with delegation enabled. The value of this property should be the email address of the user whose data you want to access.
Upload File
Upload Service Account Certificate. Use JSON file if Certificate Type is JSON, else use PFX(P12).
Advanced Configuration
This section contains advanced configuration parameters.
Manager Id
The Id of the MCC (MyClientCenter) account.
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.
If your account has access directly to the client customer account as a User, it is not required.
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.
API Version
The latest Google Ads API version.
After entering all the details, click on the TEST button.
If the connection service identification and authentication details are provided correctly, a success message stating “connection available” is generated.
Click on the CREATE button to save the changes.
If the details are incorrect or the server is down, you will get a message “Connection unavailable”.
If you have any feedback on Gathr documentation, please email us!