Google Campaign Manager | Configure Report for ChannelMix

Overview

ChannelMix's integration with your Google Campaign Manager data will work by pulling information from a custom report that you build in the Campaign Manager user interface.  Here is the rundown for building a Campaign Manager report that will work with your ChannelMix Data Warehouse.

Head over to Campaign Manager by clicking this link and go to the report builder located in the top navigation on the page.

dcm_1.png

Google Campaign Manager | Standard Dataset - Report Configuration

There are a few configurations that are important in order for ChannelMix to pull your Campaign Manager report efficiently and accurately.  Here is how you'll need to setup your standard report:

  1. Create a name that is descriptive enough that other users don't alter the template i.e. "ChannelMix Report > Advertiser > DONT EDIT"
  2. File type needs to be set to CSV
  3. Date Range needs to be set to CUSTOM (any dates can be selected... doesn't matter which)
  4. Dimensions: Date, Advertiser, Advertiser Id, Campaign, Campaign ID, Creative, Creative Id, Placement, Placement Id, Platform Type, Site Dcm
    • These fields are what Alight recognizes as our standard configuration.  More information can be found here.
  5. Metrics: Impressions, Clicks, Media Cost, Planned Media Cost, Click Through Conversions, View Through Conversions, Total Conversions, Total Revenue, Video Completions, Video First Quartile Completions, Video Midpoints, Video Plays, Video Third Quartile Completions
    • These fields are what Alight recognizes as our standard configuration.  If you'd like to include floodlight activities then we recommend creating a separate report with the same dimensions listed above and then removing these metrics: Impressions, Clicks, Media Cost, Planned Media Cost, Video Completions, Video First Quartile Completions, Video Midpoints, Video Plays, Video Third Quartile Completions.  The standard activity dataset is documented here
  6. Turn OFF any schedules
  7. Provide the Report ID to Alight Analytics Data Solutions Team to complete the configuration

GCM_Configuration.PNG

*Right-click and open in a new tab to see this image larger

Google Campaign Manager | Activity Standard Dataset - Report Configuration

GCM_Activity_Configuration.PNG

*Right-click and open in a new tab to see this image larger

Standard Dataset Links

Google Campaign Manager | Standard Dataset

Google Campaign Manager | Activity Standard Dataset

Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.