ChannelMix | Paid Media OneView Performance and Conversion
Below are the fields for the Paid Media 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 Performance and Conversion OneView configuration are:
- AdRoll (v_adroll_ad_performance)
- AdRoll (v_adroll_ad_geo_conversion)
- Amazon Ads (v_amazon_ads_all_ads)
- Amazon DSP (v_amazon_dsp_creative_activity)
- Apple Search Ads (v_apple_search_ads_ad_group)
- Bing Ads (v_bing_ad_group)
- Bing Ads (v_bing_ad_group_conversion)
- Digital Media via Google Sheet (v_gs_digital_media_and_conversion)
- El Toro (v_el_toro_line_item_performance)
- Facebook Ads (v_facebook_ads_standard)
- Facebook Ads (v_facebook_ads_standard_conversion)
- Google Ads (v_google_ads_api_ad_group)
- Google Ads (v_google_ads_api_ad_group_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)
- Google Search Ads 360 (v_search_ads_360_reporting_ad)
- Google Search Ads 360 (v_search_ads_360_reporting_ad_conversion)
- LinkedIn Ads (v_linkedin_ad_creative)
- LinkedIn Ads (v_linkedin_ad_creative_conversion)
- MNTN (formerly known as SteelHouse) (v_mntn_creative_group)
- Pinterest Ads (v_pinterest_ad_group)
- Pinterest Ads (v_pinterest_ad_group_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)
- Spotify Ads (v_spotify_ads_ad_performance)
- StackAdapt (v_stackadapt_ad)
- Traditional Media via Google Sheet (v_gs_traditional_media_and_conversion)
- The Trade Desk (v_ttd_basic_performance_stats)
- TikTok Ads (v_tiktok_ad_standard)
- TikTok Ads (v_tiktok_ad_standard_conversion)
- Twitter Ads (v_twitter_ads_line_item)
- Twitter Ads (v_twitter_ads_line_item_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 |
| 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 |
| Conversion Name | String | A description of the conversion |
| 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
|
| 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
|