Hi all,
Please help me to calculate the retentaion rate of customer over months
For example,
- In January I have 4 new customer.
- In February, 3 out of 4 continue to purchase my product > retention rate is 3/4 = 75%.
- In July, 1 out of 4 purchase my product > retention rate is 1/4 = 25%
I did a example below. Please help me with the rest of the table
Thank you so much
File: https://files.fm/u/cp9cnugm
Please help me to calculate the retentaion rate of customer over months
For example,
- In January I have 4 new customer.
- In February, 3 out of 4 continue to purchase my product > retention rate is 3/4 = 75%.
- In July, 1 out of 4 purchase my product > retention rate is 1/4 = 25%
I did a example below. Please help me with the rest of the table
Thank you so much
File: https://files.fm/u/cp9cnugm
![596638d1541259764-help-with-calculation-of-customer-retention-rate-in-excel-file-cohort-analysis-examples-excel.jpg](/board/proxy.php?image=https%3A%2F%2Fwww.excelforum.com%2Fattachments%2Fexcel-general%2F596638d1541259764-help-with-calculation-of-customer-retention-rate-in-excel-file-cohort-analysis-examples-excel.jpg&hash=2c0cd878ba108abd16000a05d7eaa35a)