Ecommerce Pipeline OneView
Below are the fields for the Ecommerce Pipeline OneView dataset. While the only web tracking data source that can be used in this solution is Google Analytics, the Paid Media sources that populate a OneView can be customized to your data specifications and data sources. The datasets that are available in the standard Ecommerce Pipeline OneView configuration are:
- Act-On (v_act_on_message_statistics)
- Adobe Analytics (v_adobe_analytics_product)
- Adobe Analytics (v_adobe_analytics_session)
- 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)
- Campaign Monitor (v_campaign_monitor_summary)
- Constant Contact (v_constant_contact_campaign_performance)
- Digital Media via Google Sheet (v_gs_digital_media_performance_and_conversion)
- El Toro (v_el_toro_creative_performance)
- Emfluence (v_emfluence_email)
- Exact Target (v_exact_target_send)
- Facebook Ads (v_facebook_ads_standard)
- Facebook Social (v_facebook_post)
- Google Ads (v_google_ads_api_ad_group)
- 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 Analytics (v_ga_session)
- Google Analytics 4 (v_ga4_product)
- Google Analytics 4 (v_ga4_session)
- Google Campaign Manager (v_gcm_standard)
- Google Search Ads 360 (v_search_ads_360_reporting_ad)
- Google Search Console (v_google_search_console_total_queries)
- Hubspot (v_hubspot_event)
- IBM Watson (v_ibm_watson_email_mailing)
- Instagram Social (v_instagram_media)
- LinkedIn Ads (v_linkedin_ads_creative)
- LinkedIn Social (v_linkedin_update)
- Mailchimp (v_mailchimp)
- MNTN (formerly known as SteelHouse) (v_mntn_creative_group)
- ON24 (v_on24_event_registrants)
- Pardot (v_pardot_email)
- Pinterest Ads (v_pinterest_ad_group)
- Reddit Ads (v_reddit_ad_standard)
- Snapchat Ads (v_snapchat_ads)
- Snappy Kraken (v_snappy_kraken_activity)
- Spotify Ads (v_spotify_ads_ad_performance)
- StackAdapt (v_stackadapt_ad)
- The Trade Desk (v_ttd_basic_performance_stats)
- TikTok (v_tiktok_organic)
- TikTok Ads (v_tiktok_ad_geo_region_standard)
- Traditional Media via Google Sheet (v_gs_traditional_media_and_conversion)
- Twitter Ads (v_twitter_ads_line_item)
- Twitter Social (v_upload_twitter_organic_tweets / v_twitter_tweet (if available))
- YouTube Analytics (v_youtube_video_analytics)
| Field | Field Type | Description |
| Report Date | Date | Date the activity occurred |
| Data Source |
String |
The data source from where the record originated |
| Channel Strategy | String | A description of the marketing channel strategy e.g. Paid, Owned, or Earned |
| 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 unified for consistency |
| Impressions | Integer | Total times the ads were served |
| Interactions | Integer | Total times the ads were clicked |
| Cost | Money | Total cost of ads |
| Stage 1 | Integer | First Stage of the Ecom Pipeline as defined by the client |
| Stage 2 | Integer |
Second Stage of the Ecom Pipeline as defined by the client
|
| Stage 3 | Integer |
Third Stage of the Ecom Pipeline as defined by the client
|
| Stage 4 | Integer |
Fourth Stage of the Ecom Pipeline as defined by the client
|
| Stage 5 | Integer |
Fifth Stage of the Ecom Pipeline as defined by the client (if necessary)
|
| Stage 6 | Integer |
Sixth Stage of the Ecom Pipeline as defined by the client (if necessary)
|
| Stage 7 | Integer |
Seventh Stage of the Ecom Pipeline as defined by the client (if necessary)
|
| Stage 8 | Integer |
Eighth Stage of the Ecom Pipeline as defined by the client (if necessary)
|
| Stage 9 | Integer |
Ninth Stage of the Ecom Pipeline as defined by the client (if necessary)
|
| Stage 10 | Integer |
Tenth Stage of the Ecom Pipeline as defined by the client (if necessary)
|
| 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 to the data |
|
Profile ID |
String | Internal metadata |
|
Profile Name |
String |
A descriptive name for the segment of data from each data source
|