ChannelMix | Ecommerce Pipeline OneView – ChannelMix

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)
Reddit Ads (v_reddit_ad_standard)

*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
ChannelMix Type	String	A description of the marketing channel strategy e.g. Paid, Owned, or Earned
ChannelMix Channel	String	A description of the marketing channel unified for consistency
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)
ChannelMix Key	String	The ChannelMix Key associated with the campaign metadata
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

ChannelMix | Ecommerce Pipeline OneView

Comments

Articles in this section