Google Campaign Manager API Connector

• Channel: Display
• Data Stream Type: Ads, Ads Verification, Conversion Tag
• Data Lag: 1 day

Setup Google Campaign Manager

1. Log in to the Google Campaign Manager platform with an Admin user.
2. Go to "Admin" --> "User profiles".
3. Examine the Profile of the Marketing Cloud Intelligence Data Pipelines user whose permissions you wish to create:
   • Make sure it has an API access.
   • Note what “User role” is assigned to this user.
4. Go to "Admin" --> "User roles"
5. Find the User role assigned to the Intelligence Data Pipelines user (as noted before) and edit it to match your requirements. There are two sections in the "User role" page: “Trafficking” and “Reporting”. Make sure you set the right permissions in both sections.

Details

• Removed entities aren’t retrieved by the API.
• Multiple Advertisers are retrieved in a single Data Stream.

General Setup

After an Account is selected, you can choose to retrieve a single or several Advertisers, or leave the field empty to retrieve all.

Retrieving many Advertisers could result in a large amount of data causing a timeout. If a timeout occurs, reduce the number of Advertisers per data stream.

Extended Properties

• Breakdown - Select one of the available options to add further breakdowns to the data retrieved by the API, resulting in a higher level of granularity on which the Measurements can be sliced. You can only select one type of Breakdown in any given Google Campaign Manager API Data Stream. The following Additional Breakdowns are available when pulling data from the Google Campaign Manager API in addition to the standard data being pulled:
  • Country - Select to pull country data and add the Dimension ‘Country’ to the report.
  • Browser and Platform Type - Select to pull browser and platform data and add the Dimensions ‘Browser/Platform’ and ‘Device Type’.
  • Platform Type - Select to pull just platform data and add the Dimensions ‘Platform Type’.
  • Region - Select to pull Regional data and add the Dimension ‘Region’ to the dataset.
  • City - Select to pull City data and add the Dimension ‘City’ to the dataset.
  • DMA/Metro - Select to pull DMA/Metro data and add the Dimension ‘Designated Market Area (DMA)’ to the dataset.
  • Zip Code - Select to pull Zip Code data and add the Dimension ‘ZIP/Postal Code’ to the dataset.
• Get Media Cost Data - Select this checkbox to retrieve Media Cost and Planned Media Cost Measurements.
• Get Creative Level Data - Select this checkbox to retrieve Creative data. It includes the following fields:
  • Creative ID
  • Creative
  • Creative Type
  • Creative Click-through URL
• Get Conversions Data - Select this checkbox to retrieve Conversion data and map to the Conversion Tag Data Stream Type. The following fields are included:
  • Activity ID
  • Activity
  • Activity Group
  • View-through Conversions
  • Click-through Conversions
  • Floodlight: DFA Conversions
• Get Revenue (Only valid when “Get Conversions Data” is checked) - Select this checkbox to retrieve the following fields, and map to the Conversion Tag Data Stream Type:
  • View-through Revenue
  • Click-through Revenue
  • Floodlight: DFA Revenue
• Get Basic Rich Media Metrics - Select this checkbox to retrieve Basic Video Measurements and map to the Ads Data Stream Type. The following fields are retrieved:
  • Backup Image
  • Rich Media Clicks
  • Rich Media Impressions
  • Video Completions
  • Video Views
• Get Advanced Rich Media Metrics - Select this checkbox to retrieve Advanced Video Measurements, and map to the Ads Data Stream Type. The following fields are retrieved:
  • Full-Screen Video Completions
  • Full-Screen Video Plays
  • Total Display Time
  • Expansion Time
  • Full-Screen Impressions
  • Interactive Impressions
  • Video Companion Clicks
  • Video Full-Screen
  • Video Interactions
  • Video Replays
  • Video Stops
  • Expansions
  • Total Interactions
  • Total Interaction Time
  • Video First Quartile Completions
  • Video Midpoints
  • Video Third Quartile Completions
  • Video Mutes
  • Video Pauses
  • Video Plays
  • Video Skips
  • Video Unmutes
• Get Cross Device Conversions (Only valid when "Get Conversions Data" is checked) - Select this checkbox to retrieve the following fields and map to the Conversion Tag Data Stream Type:
  • Click-through Conversions + Cross-Environment
  • Click-through Revenue + Cross-Environment
  • Click-through Conversion Events + Cross-Environment
  • Total Conversions + Cross-Environment
  • Total Revenue + Cross-Environment
  • Total Conversion Events + Cross-Environment
  • View-through Conversions + Cross-Environment
  • View-through Revenue + Cross-Environment
  • View-through Conversion Events + Cross-Environment
• Get ViewAbility (ActiveView) Metrics - Select this checkbox to retrieve the following fields and map to the Ads Verification Data Stream Type:
  • Eligible Impressions
  • Impressions Visible 10 Seconds
  • Measurable Impressions
  • Viewable Impressions
  • Average Viewable Time Seconds
  • Impressions Audible and Visible At Completion
  • Not Measurable Impressions
  • Not Viewable Impressions
• Get DBM Cost - If you've set up the connection between Google Display & Video 360 and Google Campaign Manager (can be done in DV360), you can retrieve the 'DV360 Cost' Measurement in your Data Stream, which is mapped to the Ads Data Stream Type. Note: This measurement is pulled only when the Breakdown settings are set to 'None', 'Country' or 'Region'. When the Breakdown is set to anything else the DV360 Cost Measurement won’t be retrieved.
• Remove Unsupported Metrics - Select this checkbox to stop Marketing Cloud Intelligence Data Pipelines from pulling an unsupported measurement from the API, and therefore preventing the retrieval from failing.

How to QA Your Data

• Create the desired report in the Google Campaign Manager platform for the required date range.
• Next, process the relevant Data Stream in Intelligence Data Pipelines for the same date range.
• Create a Report/Pivot Table within Intelligence Data Pipelines containing the exact same Dimensions and Measurements for the same report and date range.
• Compare the Measurement Totals and make sure they are aligned.