This content has been marked as final. Show 2 replies
I would like to come to a conclusion that Customer A bought different products. ( or just a count of how many people went on to purchase different products) Further on, I would also like to know how many went on to buy product Y from product X.
In SQL, it would be something like this:
Partition by Customer, Order by date,
select customer with count(product)>1
My objective is to analyse customer journey and I would like to hear any suggestions or recommendations on the best way to do it.