Display and Video OneView
Below are the fields for the Display and Video OneView dataset. Please note that the sources that populate this OneView may provide data for channels other than Display or Video. Data for irrelevant channels are removed from this OneView. The sources that populate a OneView can be customized to your data specifications, however, the datasets that are available in the standard Display and Video 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)
- 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)
- Spotify Ads (v_spotify_ads_ad_performance)
- StackAdapt (v_stackadapt_ad)
- The Trade Desk (v_ttd_basic_performance_stats)
- 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
|
| Campaign Key | String | The Campaign Key associated with the campaign metadata |
| Insert Date | Timestamp | Time data was inserted into the table. |
|
Client ID |
String | Internal metadata |
|
Client Name |
String | The client associated with the data |
|
Profile ID |
String | Internal metadata |
|
Profile Name |
String |
A descriptive name for the segment of data from each data source
|