Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

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.