I am building a dashboard that includes customer purchase data by months. I want to calculate how soon or often the customer drops and comes back.
I tried using cohort analysis but did not give me the right results.
So for e.g.
Customer 1 had purchased some items in Jan, Feb, March..... and dropped in April, May,June bought again in July. In this case the customer dropped after 3 months and came back after 3 months.
Customer 2 had purchased some items in Jan and dropped in Feb,March, April, May,June bought again in July. In this case the customer dropped after 1 months and came back after 5 months.
I just want to give the users a high level count of how many customers dropped after 1,2,3,4,5,6........months.
Any suggestions would be helpful?
I ran into a similar problem.
to recognize the custom is the real new custom(never purchase) or the custom is which had been my custom 6 months before,
it too complex ， I solved by SQL
Hope it is helpful