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 the Google DCM / DFA API

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

  1. While logged in to a google email account which has access to Google Campaign Manager, go to the following URL to enable the API if this was not previously enabled: https://console.developers.google.com/flows/enableapi?apiid=dfareporting&credential=client_key&pli=1
     
     
  2. Select the Project or create a New Project. Click Continue.
     
     
  3. Click Go to Credentials.
     The APIs & Services > Credentials page displays.
     
     
     
  4. Respond to the 'Add credentials to your project' questions as follows:
     1. • Which API are you using? Campaign Manager 360 API
        • Where will you be calling the API from? Web server (e.g. node.js, Tomcat)
        • What data will be you be accessing? Application data
        • Are you planning to use this API with App Engine or Computer Engine? No, I'm not using them.
          
          
  5. Click What credentials do I need?
     
     
  6. Add Service Account credentials to the API which will be used for API access by Claravine.
     The Add credentials to your project page displays.
     
     
     
     
  7. Enter the Service Account Name (Claravine).
     
     
  8. Select a Role as Project > Owner.
     
     
  9. Select the model for Key Type as JSON.
     
     
  10. Click Continue.
      Google will download the JSON file to your computer, you will upload this to Claravine in future steps.
      
      
  11. Navigate to Campaign Manager 360 (instructions below follow the Campaign Manager 360 Help documentation).
      
      
  12. Create a new user profile: Click Admin > User profiles > New user profile. Use the email address created in step 6 above. The access you provide to this email will be what controls what campaign / advertiser data is available to be imported into Claravine.
      
      
  13. Set user profile properties on the Properties tab and select a user role (Recommended Advanced Agency Trafficker role).
      
      
  14. Add any filters you need on the Filters tab (Recommended Advertiser filter).
      
      
  15. Save the user profile.
      
      
  16. Identify and note the User Profile ID.

  Configure in Claravine

  The following steps are required in order to grant The Data Standards Cloud the correct permissions and access to the Google API to import data. See below for how to create a service account in Google.

  1. Generate a key file using a Google Service Account which Claravine will use to authenticate and access the API. It is recommended but not required that this be a separate account for Claravine.
     
     
  2. Once the JSON service account key file is created, log in to Claravine.
     
     
  3. Click on Settings in the Navigation menu.
     
     
     
     
  4. In the Integrations Sub-Navigation menu, click on Accounts.
     
     
     
     
  5. Enter the Account Name and Description (optional).
     
     
  6. Select the Doubleclick Campaign Manager icon and scroll down to enter the account credentials.
     
     
     
     
  7. Click “Upload” to upload the Service Account Key JSON file created in the above steps.
     
     
     
     

  8. Enter the Google Campaign Manager User Profile ID which the key file was created under. This is the Profile ID for the DCM User ID found under Admin (7 numerical characters long).
     
     

      
  9. Enter the Connected Email Address which was used to create the key file. The email address entered here must match the email address in the key file.
     
     
  10. Click Save.

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

  Learn More

  • Getting Started
  • Service Account Setup
  • Refer to the DCM/DFA Reporting and Trafficking API guide to read about Service Accounts in Campaign Manager
  • Creating Service Account Keys

• 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 Integrations → Accounts.
     
     
  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 Settings → Templates.
     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 ADVERTISERS,  Limit 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 Integration → Run 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.
     
     

  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 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  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.