Customer Status - Calculate Churn and Return

Question

Dear all,

I have a very basic question, that I'm having problem to calculate the churn and returned customers.

I've seen a lot of churn prediction, but nothing about churn calculating.

I've attached the example sheet.

I want to truncate the customer status by month, and the Customer 1 is "new" in Jully, "current" in august, "churn" on September, and "returned" on October, and again "current" on november and december.

I'm having problems to find the churn and returned values. Because as he has no value on september, i can't allocate him. And after that, how to use the "returned"?

Any ideas?

Best Regards,

Customer Churn.xlsx

neilgallen · Accepted Answer

@Tanai_Goncalves The trick here is to generate a template that contains every month for every customer. That's done using a generate rows tool. From that you can use a multi row formula tool to establish the churn status of each customer by month.

The attached workflow should give you a good start. It's probably not complete, but you'll hopefully get the idea.