Below are the fields Alight Analytics provides as the ChannelMix Standard Geo Mapping Metro dataset. This is a Data Enrichment dataset that can be provided upon request. The data itself is provided directly by Alight and does not need to be manufactured or provided by the end user.
The purpose of this dataset is to help with data cleansing and to create suitable aggregation of geographic dimensions, even if the geographic values from differing data sources don't match. For example, you may have three different data sources reporting metro values of 'Abilene-Sweetwater',
'Abilene-Sweetwater TX, Texas, United States', and 'Abilene-Sweetwater, TX'. You can use this Data Enrichment dataset to provide the ChannelMix Metro field value of 'Abilene-Sweetwater TX' which helps to aggregate all of these four variations into one.
|Field Name||Field Type||Description|
|Data Source Metro||String||The metro field value as provided directly from the data source|
|ChannelMix Metro||String||The metro, provided by Alight|
|Insert Date||Time||The time the record was inserted into ChannelMix|
|ChannelMix Profile||String||Alight assigned field in ChannelMix|