ChannelMix | 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:

  • Google Analytics (v_ga_session_geography)*
  • Google Ads (v_google_ads_geo_performance)*
  • Facebook Ads (v_facebook_ad_region)*
  • Bing Ads (v_bing_geo_performance)*
  • Google Campaign Manager (v_gcm_geo)*
  • Twitter Ads (v_twitter_ads_line_item)
  • LinkedIn Ads (v_linkedin_ads_creative)
  • Google Search Ads 360 (v_google_search_ads_ad_group)
  • Snapchat Ads (v_snapchat_ads)
  • Yahoo Gemini (v_yahoo_gemini_performance_stats)
  • Traditional Media via Google Sheet (v_gs_traditional_media)
  • Digital Media via Google Sheet (v_gs_digital_media_performance)

*Can obtain geography-level data.

Some supplemental Data Enrichment datasets are also utilized in this OneView as a standard. These are included in order to help with data cleansing and suitable aggregation of geographic dimensions, even if the geographic values from differing data sources don't match. For example, you may have four different data sources reporting country values of 'US', 'USA', 'United States' and 'United States of America'. We use these Data Enrichment datasets in order to provide the ChannelMix Country field value of 'US' which helps to aggregate all of these four variations into one. These Data Enrichment datasets are:

  • v_channelmix_standard_geo_mapping_region
  • v_channelmix_standard_geo_mapping_country
Field Field Type Description
Report Date Date Date the 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
Region String The region (as reported by the data source) where the user physically was when performing the activity
Country String The country (as reported by the data source) where the user physically was when performing the activity
ChannelMix Region String The region (as defined/cleaned up by Alight) where the user physically was when performing the activity
ChannelMix Country String The Country (as defined/cleaned up by Alight) where the user physically was when performing the activity
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)
Insert Date Timestamp
The time in which the record was inserted into ChannelMix
ChannelMix Profile String
A descriptive name for the segment of data from each data source
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.