Google Ads

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 project’s name.

3. Select the newly created project

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 BoldBI Data Store.

Schedule Bold Data Hub Job

1. Click Schedules and select the created googleads project.

2. For an on-demand refresh, click Run icon.

3. Click the Schedule Icon to schedule the refresh hourly.

4. The data source was created by ETL in Bold BI.

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