Google Campaign Manager | Geography Dataset
Below are the measures and dimensions Alight Analytics considers standard for the Google Campaign Manager Geography 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 |
| Country | STRING | The country where the ad was served |
| State/Region | STRING | The state/region where the ad was served |
| Designated Marketing Area (DMA) | STRING | The designated marketing area (DMA) 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 | 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 |