Announcements
cancel
Showing results for
Did you mean:
Contributor

## Retention rate/repeat customer

Hi!

I'm having some issues calculating customers with repeat purchases.

I have a table similar to this:

 Week CustomerId OrderId 5 200 1000 5 300 2000 6 400 3000 6 200 4000 7 300 5000 7 200 6000

How would I do to get a value of how many repeat customer purchases there are in week 7 for example? As you can see, CustomerId 200 and 300 are both recurring, so the value I'm looking for for week 7 would be "2" repeat customers.

I was thinking Set Analysis but can't get it to work, anyone have any ideas?

Best

/P

1 Solution

Accepted Solutions
MVP

May be like this

Count(DISTINCT {<Week = {'\$(=Max(Week))'}, CustomerId = p({<Week = {"\$(='<' & Max(Week))"}>} CustomerId)>} CustomerId)

6 Replies

May be use

Count(CustomerId)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Contributor
Author

Hi,

Sorry if I was unclear, but when selected only week  7 I would like to count if there is any previous orders by each customer

MVP

May be like this

Count(DISTINCT {<Week = {'\$(=Max(Week))'}, CustomerId = p({<Week = {"\$(='<' & Max(Week))"}>} CustomerId)>} CustomerId)

MVP

Based on selection in Week 6, I am getting only 1 repeat customer

Not applicable

hi,

how do you use the same formula to check how many repeats called in 24 hours, 48hours and 72 hours?

Contributor III

Do you know a way to do the same thing for consecutive giving years to find the retention rate for donors?

Community Browser