ChannelMix | Paid Media Ad OneView Performance and Conversion
Matt Rodenberg
Below are the fields for the Paid Media Ad Performance and Conversion OneView dataset. The sources that populate a OneView can be customized to your data specifications, however, the datasets that are available in the standard Paid Media Ad Performance and Conversion OneView configuration are:
- AdRoll (v_adroll_ad_performance)
- AdRoll (v_adroll_ad_geo_conversion)
- Apple Search Ads (v_apple_search_ads_ad)
- Bing Ads (v_bing_ad_performance)
- Bing Ads (v_bing_ad_performance_conversion)
- Digital Media via Google Sheet (v_gs_digital_media_performance_and_conversion)
- El Toro (v_el_toro_creative_performance)
- Facebook Ads (v_facebook_ads_standard)
- Facebook Ads (v_facebook_ad_standard_conversion_window)
- Facebook Ads (v_facebook_ad_creative_dimensions)
- Flashtalking (v_flashtalking_creative)
- Flashtalking (v_flashtalking_conversion)
- Google Ads (v_google_ads_api_ad_performance)
- Google Ads (v_google_ads_api_ad_performance_conversion)
- Google Ads (v_google_ads_api_campaign) - This is included just to provide insights to data that is only available at the campaign level (like "Performance Max Campaigns").
- Google Ads (v_google_ads_api_campaign_conversion) - This is included just to provide insights to data that is only available at the campaign level (like "Performance Max Campaigns").
- Google Campaign Manager (v_gcm_standard)
- Google Campaign Manager (v_gcm_activity)
- LinkedIn Ads (v_linkedin_ads_creative)
- LinkedIn Ads (v_linkedin_ads_creative_conversion)
- MNTN (formerly known as SteelHouse) (v_mntn_creative_group)
- Pinterest (v_pinterest_pin_promotion)
- Pinterest (v_pinterest_pin_promotion_conversion)
- Reddit Ads (v_reddit_ad_standard)
- Reddit Ads (v_reddit_ad_standard_conversion)
- Snapchat Ads (v_snapchat_ads)
- Snapchat Ads (v_snapchat_ads_conversion)
- TikTok Ads (v_tiktok_ad_standard)
- TikTok Ads (v_tiktok_ad_standard_conversion)
- Traditional Media via Google Sheet (v_gs_traditional_media_and_conversion)
| Field | Field Type | Description |
| Report Date | Date | The date activity occurred |
| Data Source | String | The data source from where the record originated |
| Platform | String | The platform from where the data originated |
| Site Publisher Network | String | The network or site where the ad was served |
| Account | String | The account name from the platform the data was pulled |
| Campaign | String | The campaign name |
| Ad Group | String | The Ad Group or Placement name |
| Channel | String | A description of the marketing channel |
| Ad Type | String | The type of the Ad |
| Ad Id | String | The ID for the ad |
| Ad Name | String | The ad name |
| Creative | String | The creative name |
| Display Url | String | Display URL of the Ad |
| Image Creative Name | String | Name for the image ad. |
| Image Ad Url | String | The image ad specific value. |
| Headline | String | The ad headline for a TextAd. |
| Description | String | The descriptive text of an expanded text ad or responsive display ad. |
| Impressions | Integer | Total times the ads were served |
| Clicks | Integer | Total times the ads were clicked |
| Cost | Decimal | Total cost of ads |
| Video Views | Integer |
Total number of Video Views
|
| Video Completions | Integer |
Total number of Video Completions |
| Conversion Name | String |
Describes the conversions included in this record
|
| Conversions | Decimal |
Total conversions based on data source conversion tracking
|
| Click Through Conversions | Decimal |
Number of times a conversion occurred for the ad, in the attribution window, following a click
|
| view Through Conversions | Decimal | Number of times a conversion occurred for the ad, in the attribution window, following an impression |
| Conversion value | Decimal |
Total conversion value based on data source conversion tracking
|
| ChannelMix Key | String | The ChannelMix Key associated with the campaign metadata |
| Insert Date | Timestamp |
The time in which the record was inserted into ChannelMix - Data freshness indicator
|
| ChannelMix Profile | String |
A descriptive name for the segment of data from each data source
|