Forum Discussion
Defining new customer
File attached.
Solution SageThe definitions are flawed.
I want to define new customers and old customers, starting from the year 2020.
New customer = When a customer is in the first 12 months of its first purchase. So, customer buys in January 2020 and in the following 12 months this customer is categorized as a "new customer"
Old customer = When a customer is still making purchases after the 12 months prior.
When a customer made their first purchase on day A, month B, then regardless of what the customer had been doing in the next 11 months, they are classified as "new" in the very next 11 months (plus the month on which they made their first purchase, of course). What happens after the 11th month after the purchase? What is the classification? Does it depend on whether the customer has made a purchase after the 11th month or not? If they did, then they are "old" and if not, they're still "new" or already "old"? It's not clear.
Hi,
After the 11th months after their first purchase they move to the category "Old customers". It does not matter if they made a purchase after the 11 months. A new customer moves to the category "Old customer" after 11 months no matter what. If they bought something in the 10th month, they are categorised as "new customer", and if the next time that they buy something is 3 months after the 10th month, they are categorised as "old customer".
Hope this makes it more clear.
