Forum Discussion
Categorise by order frequency
Hi, I'm trying to find a way to categorise customers by frequency of their orders; and then use this to flag when a customer drops off from their usual order pattern. So: Customers that place...
RobbeVL
Impactful Individual
Impactful IndividualHi,
This seems like an interesting calculation.
I would start with calculating a customer treshold. (if consistancy is under this value, the customer will be "flagged")
You could do this by for example calculate the total purchases he did last year, devide it by 365. now you'll know how many purchases your customer did on average per day.
Now you have a value you could compare your actual data with.
I hope this was anything usefull?
Happy to help further.
Robbe