Google Ads Connector for Bold Data Hub

Google Ads is a service for online advertising that enables businesses to track and manage ad campaigns, providing data on ad performance and audience engagement across Google platforms.

Grab Google OAuth 2.0 Credentials

To obtain API credentials using a GCP account, follow these steps:

1. Sign in to https://console.cloud.google.com.

2. Ensure you’re logged in with the Google account associated with your project.
3. Select the project for which you want to find the OAuth 2.0 credentials.
4. In the left-hand navigation menu, go to “APIs & Services” and then select “Credentials.”
5. On the “Credentials” page, you’ll see a list of your credentials. Click on the name of the OAuth 2.0 client ID you’re interested in.
6. This will open the details page for that client ID, where you can view the “Client ID” and “Client secret.”

Connection Properties

The config section in a YAML file includes the following properties:

Connectorname: Google Ads
project_id: Project ID
client_id: Client id
client_secret: client secret
dev_token: dev token
customer_id: customer id

Configure the Bold Data Hub to connect Google ADS

1. Click the Data Hub icon on the Navigation Pane.

2. Click Plus icon and provide the new pipeline’s name.

3. Select the newly created pipeline

4. Enter the Client ID and Client Secret and click ok. The Template will be added with credentials.

Configuration Parameters

5. Update the details required in the template. and save it to the Bold BI Data Store.

Schedule Bold Data Hub Job

1. To configure interval-based scheduling, click on the schedules tab and select the created pipeline and click on the schedule icon and configure it.

2. For on-demand refresh, click Run Now button.

3. The Schedule history can be checked using the history option as well as logs.

4. Click on Logs to see if the run is completed and data source is created in Bold BI.

5. Click the Edit DataSource Option to view the created table(s), such as the ‘votes’ table.