Setting Up CPM to BigQuery Integration

To set up CPM to BigQuery Rapid API integration, follow the steps outlined below.

  1. From the Consent & Preferences platform navigation panel, select Setup > Integrations. Then, select CPM to BigQuery.

    CPM_CPM to BigQuery Integration Landing Page.png

  2. From the Login tab, select Google Service Account OAuth from the Authentication Type dropdown menu. This login requires the following information:

    • ISS (Service account) - This is the email address of the service account.
    • Scope - This is a space-delimited list of the permissions that the application requests.
    • Private Key
    • Email Addresses - Enter the email address(es) that CPM can use to contact the administrator in case of any integration issues. You may add up to 10 email addresses.

NOTE: To register the email address, you have to type a comma (“,”) after the email address.

CPM_BigQuery Login Tab.png

  1. Click the Test Connection button to allow CPM to connect to the authentication selected. Once authentication is successful, click Next.

    CPM_BigQuery Test Connection.png

  2. From the Consent Form or Data Subject Types tab, under Mappings, select a Consent Form or Data Subject Type you wish to integrate.

    CPM_BigQuery Consent Form or Data Subject Type.png