2 Replies Latest reply: Feb 9, 2018 3:20 PM by omar bensalem RSS

    I have a set of records (excel file) with customer and subscription details. For every customer, based on the order date, I would like to see who made a different product purchase.

    Sudeshna Salian

      for eg:

      Customerdateproduct
      A12/10/2016ProductX
      A04/10/2017ProductX
      B11/07/2016ProductM
      B10/06/2017ProductM
      C05/10/2017ProductH
      A01/01/2018ProductY

       

       

      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.