This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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"?
@Tanai 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.