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 |
| Click Through Revenue | FLOAT | The total amount of revenue attributed to click-through conversions. Revenue is calculated for Floodlight sales activities. |
| View Through Revenue | FLOAT | The total amount of revenue attributed to view-through conversions. Revenue is calculated for Floodlight sales activities. |
| Total Revenue | FLOAT | The total amount of revenue attributed to conversions. |
| 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.