Skip to main content

Configure Google Ads Data Hub

You can configure Google Ads Data Hub (ADH) and LiveRamp Clean Room to enable report automation and visualization in the Clean Room UI.

In order to configure the API connection between Clean Room and Google ADH, two levels of access are needed: Google ADH UI access and Google ADH API access.

Google ADH UI

Google ADH API

Used for prototyping and test queries

Used for productizing queries into the software

Used to troubleshoot and escalate with ADH Support as needed

Used for recurring reporting and building a library of queries

See the sections below for the steps to configure both Google ADH UI and Google ADH API access in order to complete the ADH configuration.

Overall Steps

Perform the following overall steps in Google Cloud Platform to configure Google ADH:

  1. Create a Google BigQuery project

  2. Enable the Ads Data Hub API

  3. Create a new service account

  4. Add the Job User permission to the service account

  5. Create a new BigQuery dataset

  6. Add the service account to the dataset

Once you've completed the steps in Google Cloud Platform, perform the following step in Google ADH:

  1. Add the Google service account to Ads Data Hub

Once you've completed the step in Google ADH, perform the following steps in LiveRamp Clean Room:

  1. Add the credentials

  2. Create the data connection

  3. Send information to LiveRamp

For information on performing these steps, see the sections below.

Perform Steps in Google Cloud Platform

Perform the steps in the sections below in Google Cloud Platform to configure Google ADH.

Create a Google BigQuery Project

If you don't already have a Google BigQuery project perform the following steps in Google Cloud Platform:

Note

If you have an existing Google BigQuery project created, skip this procedure.

  1. From Google Cloud Platform, select Project Name → Create.

    1386

  2. Note the Project ID, which will be used in a later procedure. The Project ID Clean Room will need is found in your Google Console or BigQuery interface.

    1638

Enable the Ads Data Hub API

Once you've created the Google BigQuery project, enable the ADH API in Google Cloud Platform:

Note

If you're using an existing Google BigQuery project, verify that the ADH API has already been enabled or follow the steps below.

  1. From Google Could Platform, search for "Ads Data Hub API".

    1524

  2. Click Ads Data Hub API.

    1516

  3. Click ENABLE.

    1522

Create a New Service Account

The service account enables Clean Room access to BigQuery programmatically and represents a non-human user to access data and services via the Google APIs. As part of the process, you'll also generate a JSON file to be sent to LiveRamp.

To create a service account in Google Cloud Platform:

  1. From Google Cloud Platform, select IAM & Admin → Service Accounts.

    452

  2. Click Create Service Account.

  3. Enter the service account name and click DONE.

    1885

  4. Select Service Accounts.

  5. In the row for the service account, select Manage keys from the Actions menu.

    1882

  6. Select Keys and then click ADD KEY.

    1048

  7. Select JSON for the key type and then click CREATE.

    1670

  8. Download and save the JSON file.

The JSON file will need to be provided to the Clean Room team as an email attachment in the "Send Information to LiveRamp" section below.

Add the Job User Permission to the Service Account

To add the Job User permission to the service account in Google Cloud Platform:

  1. From the IAM and Admin menu in Google Cloud Platform, click Add.

  2. Enter the Clean Room Service Account email created in the "Create a New Service Account" section above.

  3. Select the BigQuery Job User role and then click SAVE.

    1676

Create a New BigQuery Dataset

To create a new BigQuery dataset in Google Cloud Platform:

  1. From Google Cloud Platform, navigate to BigQuery.

    1674

  2. Click Create Dataset.

    1672

  3. Enter the Dataset ID using the naming convention "LIVERAMP_ADH_ORGANIZATION NAME (for example, "LIVERAMP_ADH_ACME").

  4. Under Data Location, select us (multiple regions in United States)

    1672

  5. Click CREATE DATASET.

    1674

Add the Service Account to the Dataset

Once you've created the new BigQuery dataset, add the service account to the dataset in Google Cloud Platform:

  1. Select SHARING → Permissions.

    1676

  2. Click ADD PRINCIPAL.

    1674

  3. Enter the LiveRamp Service Account email created in the "Create a New Service Account" section above.

  4. Select the BigQuery Data Owner role and then click SAVE.

    1674

Add the Google Service Account to Ads Data Hub

To enable LiveRamp to connect to your ADH and BigQuery accounts to execute queries, add the Google service account to ADH:

  1. From Ads Data Hub, navigate to Settings → Users.

    1036

  2. Click Add.

  3. Enter the BigQuery Service Account email previously created in the "Create a New Service Account" section above.

    808

  4. Under Roles, select Superuser.

  5. To bring in data from an account outside of your standard ADH account:

    1. Navigate to Settings → Ads Data Hub.

    2. Enter your Account ID.

    3. Enable permissions for Ads Data, Match Tables, and Audience Lists.

Perform Steps in LiveRamp Clean Room

Once the above steps have been performed in Google Cloud Platform and ADH, perform the overall steps in the sections below in LiveRamp Clean Room.

Add the Credentials

To add the credentals in LiveRamp Clean Room:

  1. From the LiveRamp Clean Room navigation pane, select Data Management → Credentials.

  2. Click Add Credential.

    add_credential.png

  3. Enter a descriptive name for the credential.

  4. For the Credentials Type, select "Google Service Account".

    CR-Export_to_GCS-edit_credential.png

  5. For the Project ID, enter the project ID.

  6. Enter your Credential JSON (credential JSON is hidden by default, viewable here for demonstration purposes).

    CR-Export_to_GCS-_credential_JSON.png

  7. Click Save Credential.

  8. Verify that your credentials have been added to LiveRamp Clean Room:

    CR-Export_to_GCS-_verify_credential.png

Create the Data Connection

To create the data connection:

  1. From the LiveRamp Clean Room navigation pane, select Data Management → Data Connections.

  2. From the Data Connections page, click New Data Connection.

    data_cxn_new.png

  3. From the New Data Connection screen, select Google Ads Data Hub.

    Screenshot 2024-03-28 at 21.45.15.png

  4. Select the credentials created in the previous procedure from the list.

    Screenshot 2024-03-28 at 21.46.07.png

  5. Configure the data connection:

    Screenshot 2024-06-17 at 11.43.12.png

    • Name: Enter a name of your choice.

    • Category: Enter a category of your choice.

    • Dataset Type: Select Google Ads Data Hub: Event-Level Ad Campaign Data.

    • Account ID: Enter your ADH account ID (which can be found at Ads Data Hub → Settings).

    • Ads Data ID: Enter your Ads Data ID (which can be found at Ads Data Hub → Settings → Ads Data Hub links).

    • Advertiser IDs

    • ADH Service Account (email): Enter the service account email created in the "Create a New Service Account" section above.

  6. Review the data connection details and click Save Data Connection.

    Note

    All configured data connections can be seen on the Data Connections page.

Send Information to LiveRamp

Once all steps are completed, send an email to LiveRamp that includes the JSON file downloaded in the "Create a New Service Account" section above and the following parameter information:

Parameter

Parameter Location

BigQuery Project ID

Google Cloud Platform → Dashboard

ADH Account ID

Ads Data Hub → Settings

Ads Data ID

Ads Data Hub → Settings → Data Links → Ads Data Hub links

Customer / Advertiser ID

Optional based on the Clean Room question

Google service account credential JSON

Ads Data Hub → Settings → Details

ADH service account email

Ads Data Hub → Settings → Account Settings

In this section: