Below are the measures and dimensions Alight Analytics considers standard for
the Google Campaign Manager dataset.
Pro Tip: When requesting this data set please let the Data Solutions
team know what kind of attribution window is configured for your conversions
in Campaign Manager. This will help determine the proper window of time that
your data set will be refreshed each day.
| Field Name | Field Type | Description |
| Date | DATE | The date the activity occurred |
| Advertiser | STRING | Advertiser |
| Advertiser ID | STRING | Advertiser ID |
| Campaign | STRING | Campaign |
| Campaign ID | STRING | Campaign ID |
| Placement | STRING | Placement |
| Placement ID | STRING | Placement ID |
| Creative | STRING | Creative |
| Creative ID | STRING | Creative ID |
| Platform Type | STRING | The platform description |
| Site DCM | STRING | The site where the ad was served |
| Impressions | INTEGER | Number of times the ad was served |
| Clicks | INTEGER | Number of times the ad was clicked |
| Media Cost | FLOAT | The media cost for the ad |
| Planned Media Cost | FLOAT | The cost planned for the ad |
| Click Through Conversions | FLOAT | Number of times a conversion occurred for the ad, in the attribution window, following a click |
| View Through Conversions | FLOAT | Number of times a conversion occurred for the ad, in the attribution window, following an impression |
| Total Conversions | FLOAT | Number of times a conversion occurred for the ad, in the attribution window |
| Total Revenue | FLOAT | Number of times a conversion occurred for the ad, in the attribution window |
| Video Completions | INTEGER | Number of times a video ad was viewed until the end of the video |
| Video First Quartile Completions | INTEGER | Number of times a video ad was viewed 25% of the way through |
| Video Midpoints | INTEGER | Number of times a video ad was viewed 50% of the way through |
| Video Third Quartile Completions | INTEGER | Number of times a video ad was viewed 75% of the way through |
| Video Plays | INTEGER | Number of times a video ad was started |
| Insert Date | TIMESTAMP | ChannelMix Field - When the row was inserted into ChannelMix |
| ChannelMix Profile | STRING | ChannelMix Field - The descriptive name assigned to this data segment |
Comments
Please sign in to leave a comment.