Poduct&Skin

products from:
Product segments aa, acne, rosacea, pigment, hydrate
Product categories prevent, protect, correct, hydrate, cleanse
Skin type greasy (z) and dry (s)
Normalize metrics by their respective sums, getting ratios in %
Product segments and categories with 100% ratio are assigned with “pure” segments (like «аа» or «prevent»), with ratio from 2/3 to 1 are assigned with «extended» segments (like «aa+» or «prevent+»), with ratio below 2/3 are assigned «mixed»
Skin categories and calculated the same way, with «pure» at 100%, «extended» at 80%-100%, and below 80% - «mixed»
If customer purchased item with an “undefined” products segment or skin type, appropriate metric is assigned with NA
Segmentation is recalculated after each new product purchase