Expand my Community achievements bar.

Report classifications on ~none~ values in Data Warehouse

Avatar

Level 4

8/26/20

In each classification table, there are 2 groups of unclassified data. One group is activity with no variable set and the other is activity on a set variable that hasn't been classified. As an example, direct traffic without s.Campaign variable and campaign traffic with an s.Campaign variable that has not been defined by processing rules or a SAINT upload yet. 

In fully processed data, these can be distinguished by adding classifications to the null (or ~none~) variable. For example, set the classification 'Marketing Channel' = Direct Traffic when the s.Campaign key is null.

Data Warehouse treats these two groups the same. It would be very useful for reporting to have Data Warehouse recognize classifications on null/~none~ variables.