Google Display & Video 360 | Standard Dataset
Jared Sloan
Below are the measures and dimensions ChannelMix considers standard for the Google Campaign Manager dataset. ChannelMix will update your datasets with the most recent 30 days of data every day to account for 30 day conversion attribution windows. If you have adjusted your conversion window in Campaign Manager's user interface to be longer than 30 days, please let the ChannelMix Support team know so that we can adjust your ChannelMix datasets to account or that and ensure that all your conversions are being reported!
This is not currently an activate-able dataset through ChannelMix Control Center. To activate this dataset:
- Follow these instructions to make a custom report: Google Display & Video 360 | Configure Report for ChannelMix.
- Submit a request to load that report daily.
This process is a one-time setup.
| Field Name | Field Type | Description |
| Date | DATE | The date on which the marketing action occured or was attributed to |
| Advertiser | VARCHAR | The name of an advertiser |
| Advertiser Id | VARCHAR | The ID of an advertiser |
| Insertion Order | VARCHAR | The name of an insertion order |
| Insertion Order Id | VARCHAR | The ID of an insertion order |
| Campaign | VARCHAR | The name of a campaign |
| Campaign Id | VARCHAR | The ID of a campaign |
| Line Item | VARCHAR | The name of a line item |
| Line Item Id | VARCHAR | The ID of a line item |
| App Url | VARCHAR | The name of a site, or mobile app |
| App Url Id | VARCHAR | The ID of a site, or mobile app |
| Creative | VARCHAR | A creative in Display & Video 360 is a placement in Campaign Manager 360. These placements should be named to identify the creative that is served. |
| Creative Id | VARCHAR | The ID of the creative |
| Creative Type | VARCHAR | The type of creative that was delivered, such as Display, In-stream video, rich media, and so on. |
| Device Type | VARCHAR | The type of device, such as "Desktop", “Connected TV”,"Smartphone", and "Tablet". |
| Advertiser Currency | VARCHAR | |
| Partner Currency | VARCHAR | |
| Impressions | INTEGER |
The 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. Considerations If a user starts to load a webpage then closes the browser before the creative has started to download, an impression is not recorded. |
| Billable Impressions | INTEGER |
|
| Clicks | INTEGER |
The number of times a person has clicked on an ad. |
| Total Conversions | DOUBLE PRECISION | The aggregate total of all Post-View Conversions and Post-Click Conversions. |
| Post Click Conversions | DOUBLE PRECISION |
The number of times a person has landed on a success page, after clicking on an ad. Note: Display & Video 360 only records conversions if your line item is associated with a pixel for conversion counting. |
| Post View Conversions | DOUBLE PRECISION |
Note: Display & Video 360 only records conversions if your line item is associated with a pixel for conversion counting. |
| CPM Fee 1 (USD) | FLOAT | Line item CPM Cost 1 × Impressions / 1000. |
| Media Fee 1 (USD) | FLOAT | Media Fee 1 % × Media Cost |
| Client Cost (Advertiser Currency) | FLOAT | |
| Starts (Video) | FLOAT |
|
| Complete Views (Video) | FLOAT | The number of times a video has been played to its end. |
| Engagements | Integer |
|
| Insert Date | TIMESTAMP | The time (GMT) when the record was updated in ChannelMix |
| Channelmix Profile | VARCHAR | The name of the ChannelMix Profile |