ChannelMix | Ecommerce Geo OneView

Below are the fields for the Ecommerce Geo 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 Geo 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)

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
Clicks Integer Total times the ads were clicked
Cost Money Total cost of ads
Sessions Integer Total number of website sessions
Transactions Integer Total number of transactions
Transaction Revenue Money Total revenue from transactions
Item Quantity  Integer Total number of items purchased. For example, if users purchase 2 frisbees and 5 tennis balls, this will be 7
Item Revenue  Money The total revenue from purchased product items.
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.