1 Reply Latest reply on Aug 1, 2018 4:27 PM by Patrick A Van Der Hyde

    Cohorts Exercise

    francesco.fincato.1

      Hi All,

       

      I am trying to build different sets of Cohorts and I had success in creating the two I am attaching in my Workbook: one is taking into account the Cohort Month (the % of users repeating the purchase after x months), while the other one is telling me how many customers with first order in a given month have placed x orders in total.

       

      Starting from this second cohort, I would also like to be able to calculate the % of the users purchasing a second time, a third time, a fourth, fifth etc. I would like to have for every month the group of users placing the very first order as the 100% full group, which will enable me to understand how many users out of that group actually stayed loyal for a second, third, fourth.... purchase in the following months.

       

      So far I have had no luck in this last effort. I would be extremely grateful if someone could shed some light on this!

       

      Thank you very much in advance!

       

      Cheers,

       

      Francesco