Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Report classifications on ~none~ values in Data Warehouse

Avatar

Avatar
Springboard
Level 4
_bel_
Level 4

Likes

46 likes

Total Posts

16 posts

Correct reply

0 solutions
Top badges earned
Springboard
Give Back 5
Give Back 3
Ignite 3
Ignite 1
View profile

Avatar
Springboard
Level 4
_bel_
Level 4

Likes

46 likes

Total Posts

16 posts

Correct reply

0 solutions
Top badges earned
Springboard
Give Back 5
Give Back 3
Ignite 3
Ignite 1
View profile
_bel_
Level 4

26-08-2020

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. 

data warehouse SAINT Classifications