Intermediate · 30 min · 4 steps
How many days pass before a customer books again?
Tanvi Joshi, Customer Retention Analyst at HomeHelp Technologies
It is Friday, 9:15 AM. Tanvi Joshi is a retention analyst at HomeHelp, an app that sends cleaners, plumbers, repair technicians and salon staff to the homes of over 2.5 million families in 12 Indian cities. All summer the company spent a lot on Google and Meta ads and got record numbers of first-time bookings.
The question
How many days usually pass between one booking and the next for the same customer, and how are those gaps spread?
- LAG
- Window functions
- DATEDIFF
- Customer retention
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.