1 Reply Latest reply on Jan 19, 2016 5:28 PM by Esther Aller

    Flagging customers that should be buying a product based on prior purchases

    joe.rodriguez.3

      Hey Guys,

       

      This might be simpler than I think, but I want to flag customers that should be buying a product because they bought other related products. In the example attached, Tom bought a motorcycle in 2009. I want to be able to flag Tom because he should have also bought a Helmet, but didn't.

       

      In my data set, I'll have several dependencies like if Motorcycle, then Helmet, or if Boat, then Fish Finder. But, we would only flag these in Tom's example if Helmet sales are zero. I want to be able to show this in a column next to Tom's Motorcycle purchase, but I'm open to whatever you suggest.

       

      Thanks guys,

       

      Joe