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. |
| 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
|
Comments
Please sign in to leave a comment.