Data Studio Campaign Manager 360 (DCM) Overview Report

campaign manager 360 data studio dashboard

This Campaign Manager 360 Data Studio report visualises your Campaign Manager 360 (formerly known as DoubleClick Campaign Manager/DCM) campaign, creative and placement data.

To keep the dashboard simple, we’re only using a few of the available dimensions available in our connector. The whole list of supported metrics and dimensions is further down below in this article.

This dashboard connects to the following data source

  • Campaign Manager 360

Connecting your data

The process to set up this dashboard shouldn’t take more than 2 minutes. Before you get started please make sure that you are logged in with a Google account which is linked to Google Campaign Manager 360.

Setting up the Data Studio connector and dashboard

  1. Configure the Google Data Studio Connector: Campaign Manager 360
  2. Once you have logged in with your Google Account click Finish
  3. Back in Data Studio click CREATE REPORT

 

Available Metrics and Dimensions

IDNameDescription
Account Country IDTEXTAccount country ID.
Account Country NameTEXTAccount country name.
Account Currency CodeTEXTAccount currency code.
Account Currency IdTEXTAccount currency id
Account IDTEXTCampaign Manager 360 account ID.
Account NameTEXTAn organization that creates and distributes a commercial message.
Account ID (Duplicate)TEXTCampaign Manager 360 account ID.
Active View: Viewable ImpressionsNUMERICThe number of impressions on the site that were viewable out of all measurable impressions.
ActivityTEXTA single Floodlight tracking element used to track any action (such as a click, download, lead, or sale) performed by a user in an advertiser's app or website after that user has clicked on or seen the advertiser's ad.
Activity IDTEXTThe ID associated with an activity.
Ad Browser Targeting Major VersionTEXTMajor version number of browsers targeted by this ad
Ad Browser Targeting Minor VersionTEXTMinor version number of browsers targeted by this ad
Ad Browser TargetingTEXTBrowser names to target by the ad
Ad CompatibilityTEXTCompatibility of this ad.
Ad Targeting Connection TypeTEXTContains information about an internet connection type that can be targeted by ads.
Ad Creative Rotation TypeTEXTType of creative rotation. Can be used to specify whether to use sequential or random rotation.
Ad Creative Rotation Weight StartegyTEXTStrategy for calculating weights. Used with CREATIVE_ROTATION_TYPE_RANDOM
Ad Days SchedulingTEXTDays of the week when the ad will serve.
Ad End TimeDATEDate and time that this ad should stop serving. Must be later than the start time.
Ad Frequency Cap DurationNUMERICDuration of time, in seconds, for this frequency cap. The maximum duration is 90 days
Ad Frequency Cap ImpressionsNUMERICNumber of times an individual user can be served the ad within the specified duration.
AD IDTEXTThe ID associated with an ad.
Ad Impressions RatioNUMERICImpression ratio for this ad. This ratio determines how often each ad is served relative to the others.
Ad Is Dynamic Click TrackerTEXTWhether this ad is a dynamic click tracker. Applicable when type is AD_SERVING_CLICK_TRACKER.
Ad Targeting Mobile CarrierTEXTMobile carriers that this ad targets
Ad Targeting Mobile Carrier CountryTEXTCountry code of the country to which this mobile carrier belongs.
AD nameTEXTA commercial message that's delivered to a user. In Campaign Manager 360, an ad generally contains one or more creatives and is where you set the run dates and targeting criteria. To run, an ad must be assigned to a placement.
Ad Targeting OS Major VersionTEXTOperating system major version that this ad targets.
Ad Targeting OS Minor VersionTEXTOperating system minor version that this ad targets.
Ad Targeting OSTEXTOperating systems that this ad targets. Applicable when type is AD_SERVING_STANDARD_AD.
Ad Targeting OS is DesktopTEXTWhether this operating system is for desktop.
Ad Targeting OS is MobileTEXTWhether this operating system is for mobile.
Ad Platform TargetingTEXTThe hardware platform to which ads were delivered or on which a conversion took place (desktop, tablet, or smartphone).
Ad PriorityTEXTServing priority of an ad, with respect to other ads. The lower the priority number, the greater the priority with which it is served.
Ad Start TimeDATEDate and time that this ad should start serving. If creating an ad, this field must be a time in the future.
Ad Time SchedulingTEXTHours of the day when the ad will serve.
AD TypeTEXTThe type of ad
AdvertiserTEXTAn organization that creates and distributes a commercial message.
Advertiser Group IDTEXTThe group ID associated with an advertiser.
Advertiser Group NameTEXTThe group name associated with an advertiser.
Advertiser IDTEXTThe ID associated with an advertiser.
Average Display TimeNUMERICThe average amount of time, in seconds, that Rich Media creatives were displayed to users during the specified date range.
Audio CompletionsNUMERICThe number of impressions for which an audio clip played to completion.
Audio First Quartile CompletionsNUMERICIn-stream audio. The number of impressions for which an ad clip played to the end of the first quarter of the audio content’s total length.
Audio MidpointsNUMERICIn-stream audio. The number of impressions for which an ad clip played to the midpoint of the audio content’s total length.
Audio Third Quartile CompletionsNUMERICThe number of impressions for which an ad clip played to the end of the third quarter of the audio content’s total length
CampaignTEXTAssociated with an advertiser, a campaign is a basic framework for managing your advertising.
Campaign End DateDATEThe end date of a campaign.
Campaign Start DateDATEThe start date of a campaign.
Campaign ID (duplicate)TEXTThe ID associated with a campaign. (duplicate)
ClicksNUMERICThe number of times that users clicked on a creative during the specified date range.
Total ConversionsNUMERICThe number of conversions
CountryTEXTA geographical area, used for targeting and geographic reporting.
CPCNUMERICThe media cost per user click.
CreativeTEXTThe media package that's delivered to users to convey your advertising message. Generally, each creative consists of at least one asset, such as an image file.
Creative Auto Advance ImagesTEXTWhether images are automatically advanced for image gallery creatives.
Creative Background colorTEXTThe 6-character HTML color code, beginning with `#`, for the background of the window area where the Flash file is displayed. Default is white.
Creative Backup Image Window TypeTEXTType of browser window for which the backup image of the flash creative can be displayed.
Creative HeightNUMERICCreative height
Creative IDTEXTThe ID associated with a creative.
Creative Last Modified TimeDATETimestamp of the last change
Creative Media DescriptionTEXTDescription of the audio or video ad.
Creative Media DurationTEXTCreative audio or video duration in seconds.
Creative Min Flash VersionTEXTThe minimum required Flash plugin version for this creative. For example, 11.2.202.235.
Creative Redicrect URLTEXTURL of hosted image or hosted video or another ad ta
Creative SkippableTEXTWhether the user can choose to skip the creative.
Creative Video Skip Offset PercentageTEXTAmount of time (in percentage) to play the video before the skip button appears.
Creative Video Skip Offset SecTEXTAmount of time (in seconds) to play the video before the skip button appears.
Creative Video View Offset (In Percentage)TEXTAmount of time (in percentage) to play the video before counting a view.
Creative Video View Offset (In Seconds)TEXTAmount of time (in seconds) to play the video before counting a view.
Creative WidthNUMERICCreative width
Creative TypeTEXTThe type of creative that was delivered, such as Display, In-stream video, rich media, and so on.
CTRNUMERICThe percentage of impressions that result in users clicking an ad.
DateDATEThe date when the reported events took place.
Feed 1 Reporting LabelTEXTOne of the possible options in a feed.
ImpressionsNUMERICThe number of times that a user’s client (browser or mobile device) sent a ping to our ad server that creative content was requested and has started to download during the specified date range.
Landing Page URLTEXTThe URL a user is sent to when they click on an ad. Usually the landing page URL points to a webpage in the advertiser’s website. If the creative served has multiple exits, each exit will be displayed as its own row.
Media CostNUMERICThe cost of all impressions, clicks, and activities during the specified date range, based on the schedule and pricing information that was entered for each placement.
PlacementTEXTA Placement resource represents a fixed block of ad space on a site. It defines where an advertisement can serve, its physical dimensions, pricing information, and other key properties. One or more ads are linked to each placement.
Placement IDTEXTThe ID associated with a placement.
Profile IDTEXTID of CM360 user that provides access to the account.
Profile nameTEXTName of CM360 user that provides access to the account..
Profile ID (alias)TEXTID of CM360 user that provides access to the account.
Profile name (alias)TEXTName of CM360 user that provides access to the account..
RevenueNUMERICThe total amount of revenue
Site (CM360)TEXTA representation in your Campaign Manager 360 account of a website, part of a website, or group of websites from which an advertiser or agency has purchased ad space.
Site ID (CM360)TEXTThe ID associated with a Campaign Manager 360 site.
SourceTEXTAlias for Site (CM360).
SpendNUMERICSpend (alias for DBM (DV360) Cost)
Video Plays at 100 percentNUMERICThe number of impressions for which an ad clip played to completion.
Video Plays at 25 percentNUMERICThe number of impressions for which an ad clip played to the end of the first quarter of the video's total length.
Video Plays at 50 percentNUMERICThe number of impressions for which an ad clip played to the midpoint of the video's total length.
Video Plays at 75 percentNUMERICThe number of impressions for which an ad clip played to the end of the third quarter of the video's total length.
Total CostNUMERICTotal Cost (alias for DBM (DV360) Cost)
Video SkipsNUMERICThe number of times a user has skipped a video clip that was playing.
Video StartNUMERICAlias for Video Starts.
Video StartsNUMERICThe number of served video impressions, counted when the video clip was played or started by the user.
Video ViewsNUMERICThe number of impressions for which a video clip was played.

To get other channels connected and visualised please check out our Template Gallery.