Forum Discussion
Problem calculating retaining customers
Could anybody please explain why it doesn't work when I'm trying to identify if a new customer is retained. The logic I'm having is that if a customer have never made any purchase before current purc...
Hi v-diye-msft and parry2k
Here is the sample data and calculation I have
I'm hoping to have retaining customers = 2 for January because customer 2 and 3 are new customers and make another purchase within 30 days of their first purchase. Customer 1 is not a new customer for January so I won't be counted and customer 4 doesn't make any purchase after first purchase, so it won't be counted as well.
But my calculation gives me retaining customers = 3 and it seems to be problem with customer 4