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!