Below are the measures and dimensions Alight Analytics considers standard for the Google Campaign Manager dataset. The last 30 days of data are pulled each day.
This is an activate-able dataset through ChannelMix Control Center.
Pro Tip: If needing greater than 30 days of data refresh, please let the Product Support team know and they can adjust the refresh window to your preference.
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.