Claravine + Google Campaign Manager Integration

Haley Lademann
Haley Lademann
  • Updated

Claravine integrates with Google Campaign Manager to import campaign metadata into a template and provide data governance on the data and links. Once the data has been imported it can be enriched with business-specific data and then mapped into Adobe Analytics, Google Analytics, or any cloud storage account for further analysis.

  • Integrate Claravine with Google Campaign Manager

    Enable API, create a Service Account with the correct access to the Google Campaign Manager API, generate a Key, and create the Claravine user for the new Service Account.

    1. Enable the Google DCM / DFA API
      - While logged in to a google email account that has admin access to Google Campaign Manager, go to the following URL to enable the API.
      (If it has already been enabled, you'll see one or more projects, and no action is needed for this step.)

    2. Create a New Project. 
      - The name of this project should be readable but it is inconsequential and not tied to any functionality. 
      - Select Organization (if applicable) 
      - Click Create
      2. Create a project .png

    3. Enable the new project access to API
      Click Next
      3.  Enable access to API .png

      Click Enable
      2. Enable .png

    4. Create the service account & generate the key
      - Primary Menu > IAM & Admin > Service Accounts
      4. Service accounts copy.png

      - Click Create New Service Account4. create new service account.png

      Service Account Details
      - Enter a Service Account Name, ID, and Description. Click Create and Continue.
      4. Service account details .png

      - Select Role "Editor". Click Continue.
      4. editor.png - Optional* Grant additional admins access to service account.
      (The granted access can always be modified later but it is recommended to have atleast one other admin user in your org with granted access.)
      Click Done.

    5. Create the Service Account & Generate the Service Key
      - Next to the email address, click the ellipses > Manage Keys
      Manage Keys.png

      Click Add key > Create new key
      Add key - create new key .png

      - Select Key type: JSON > Create
      Store this key safely. You will need this key for connecting CM360 in Claravine. 
      Json - create.png

      - Navigate to Details tab, and copy the email address. We'll need this to next for CM360. 
      details tab - copy email.png

    6. In a new tab, go to Campaign manager ( 

    7. Create a new user role to associate this email/access to. 
      - Navigate to Admin > User Roles > New
      new user role.png

      New User Profile: Properties tab
      - Paste the email on your clipboard to the Email and Confirm email fields.
      - Select User Role: Advanced Agency Trafficker
      - Click to the the Filters tab
      user roles.png

      Click to expand "Advertisers"
      - Select "Choose" (Optionally, select "Allow All" if applicable). 
      - Select which advertisers to grant access to by indicating each as "allowed". 
      - Click Done
      (Recommended: Select all advertisers you wish Claravine to have access to. Configuring the specific advertiser for each integration in Claravine is handled separately in the Claravine platform.) 

      - Click Save to save the user profile.
      Note the User Profile ID. You will need this ID to connect the CM360 account in Claravine. The ID can be found in two places: 
      Profile ID.png

    Configure in Claravine

    The following steps are required to grant The Data Standards Cloud the correct permissions and access to the Google API to import data. 

    1. This step was completed in the above instructions. See Step 4 above for reference. 
      - Once the JSON service account key file is created, log in to Claravine.

    2. In Claravine, Click on Settings in the Navigation menu.
      Select Integrations > Accounts > Click the Plus button to create a new account. 

      Accounts .png

    3. Enter the Account Name and Description (optional).
    4. Select the Google Campaign Manager 360 icon and scroll down to enter the account credentials.Account - add account.png

    5. Scroll down:
      Click “Upload” to upload the Service Account Key JSON file created earlier in step 5 above.
      Enter the User Profile ID noted earlier in Step 7 above.
      Enter the Email Address used to create the User Profile in Step 7. 

      Save account.png

    6. Click Save Account.

      If needed, the User Profile ID and Email can both be found in Campaign Manager > Admin > User Roles > Select the User Role created earlier.

      user profile ID and email.png


    What's next: Follow the instructions to create a Template with Inbound Campaign Manager 360 data.

    Learn More

  • Google Campaign Manager Fields Available for Integration

    The integration allows specific fields in Campaign Manager 360 to automatically import data into a connected template. The available inbound data fields from Campaign Manager are:

    • Ad ID
    • Ad Name
    • Ad Type
    • Advertiser ID
    • Billing Invoice Code
    • Campaign End Date
    • Campaign ID
    • Campaign Name
    • Campaign Start Date
    • Comments
    • Content Category
    • Content Category ID
    • Creative ID
    • Creative Name
    • Creative Pixel Size
    • Placement Activity ID
    • Placement Cap Cost Option
    • Placement Cost Structure
    • Placement End Date
    • Placement Flight Activated
    • Placement Group Type
    • Placement ID
    • Placement Name
    • Placement Start Date
    • Placement Strategy
    • Site ID
    • Site Key Name
    • Site Name
  • Templates: Inbound Configuration

    Claravine can import ad IDs, Names, and additional metadata directly from Campaign Manager 360, avoiding manual exports, then pass data downstream for more readable classifications and enriched data for improved dimensionality and segmentation in analysis.

    To add Campaign Manager Inbound to a template:

    1. An Administrator must first connect the Campaign Manager 360 in the Accounts Sub-Navigation menu of Integrations.

    2. Open or create the Integration Template in the Templates Sub-Navigation menu. The template must contain all ID fields, platform Name fields, and any additional metadata fields in Step 2 Define and Govern.

    3. Click Step 3 - Connect.

    4. Click the plus sign (+) to add a new Inbound integration.

    5. Click Google CM360.
      The Google Campaign Manager 360 inbound configuration section displays.
    6. Select the connected CM360 Account from the drop-down list.

    7. Select Filters to apply to the imported data:
      • Include Archived Campaigns
      • Include Paste End Date Campaigns
      • Include Ads Missing Creatives
      • Include Inactive Ads
      • Include Ads Missing Placements
      • Excelue Inactive Creatives
      • Exclude Archived Placements
      • Exclude Archived Creatives
      • Exclude Archived Ads

    8. Select the Advertisers from the drop-down list.

    9. Select which Campaigns to import into Claravine. Not selecting any Campaigns will bring in all active Campaigns.

    10. Select which Placements to import into Claravine. Not selecting any Placements will bring in all active Campaigns.

    11. Select the Data Sync Frequency. It is recommended to set the frequency to daily.

    Field Mapping

    1. Ad ID, Campaign ID, Placement ID, and Campaign Name are required field mappings when adding a CM360 integration to a template. In the Map To fields, select the field names in the template to map this inbound data to. See the list of available inbound fields.

    2. Click + Add New Mapping to add additional CM360 fields to map with Claravine fields.

    3. Click Save to save the template.

    Watch a Video

    Watch a video showing you how to add a CM360 Inbound Integration to a template.

    What's Next: See how users would review and submit inbound integration data in the Pending menu.

  • Templates: Outbound URL Configuration

    Claravine can automatically send the Claravine-generated URL back to Google Campaign Manager 360.

    To add Campaign Manager 360 Outbound to a template:

    1. Open the Integration Template in the Templates tab.

    2. Click Step 3 - Connect.

    3. Click the plus sign (+) to add a new Outbound integration.

    4. Click CM360 Output.
      The CM360 Outbound configuration section displays.

    5. Select the connected CM360 Account.
      An Administrator must first connect the CM360 Account in IntegrationsAccounts.

    6. Check the box to Update clickThroughURL in Google Campaign Manager if the Claravine-generated URL should replace the clickThroughURL in CM360.

    7. Select the template schema field to push back to the Creative or CreativeAssignment clickThroughURL (template Link field).

    8. Select the Ad ID field to match in CM360. This ensures Claravine updates the correct URL to the correct Ad.

    9. Select the Creative ID field to match in CM360. This ensures Claravine updates the correct URL to the correct Ad.

    10. Click Save to save the template.
  • Add New Google Campaign Manager Ads to a Template

    Google Campaign Manager integrated templates that have been filtered to a specific Advertiser, Campaign, or Placement will need to continually manage the filters on the template. An Administrator or Manager who has been given Template permission can update the integration template to add new campaigns as needed.

    Add a New Filtered GCM Campaign

    1. Navigate to SettingsTemplates.
      The Templates page displays.


    2. Click the name of the Template to edit.
      The Edit New Template menu displays.

    3. Go to Step 3- Connect.

    4. Expand the Google DCM Inbound Integration menu.


    5. Update the Limit Import BY ADVERTISERSLimit Import BY CAMPAIGNS, and/or Limit Import BY PLACEMENTS sections, type the name or use the drop menu to select the Advertiser, Campaign, or Placement to import to this template. Select all that apply (multi-select).


    6. Click Save to save the template.

    7. The template will import all mapped data from GCM on the next sync.

      Manual syncs require the Administrator to navigate to the Template Dataset View and click IntegrationRun Integration.

      Daily, Twice Daily, Weekly, and Monthly syncs will run the next day at 6AM EST.
  • Update the API Key

    Generate a New JSON Key for Existing Claravine Doubleclick Service Account

    1. Go to the Google Cloud Service Accounts Page.

    2. Select the project that is currently tied to your Claravine integration.gcm7.png

    3. In the Service Accounts for project page, identify the email account associated with your Claravine integration.

    4. To the far right of the email, click the mceclip0.png Actions icon and select Create Key. When prompted, check JSON as the key type. Click Create.

    5. Your JSON file will automatically download and you will see your new key appear under the same email profile.

    6. In the same Service Accounts for project page,  click the mceclip1.png Actions icon, select Edit for the same services account.

    7. In the Keys section, delete the old Key. Click Save.

    Apply the New JSON Key in Claravine 

    1. Click Settings in the Navigation menu.

    2. Click Accounts in the Integrations Sub-Navigation menu.
      The Accounts page displays.

    3. Click the name of the Google Campaign Manager Account you want to modify.
      The Edit Account menu displays.

    4. Upload the new JSON service account key file.

    5. Click Save.



Article is closed for comments.