Intermediate · 30 min · 5 steps
Do new members come back, and do they spend more?
Priya Desai, Retention Analytics Lead at FitPulse Fitness
It is Tuesday, 2:00 PM. Priya Desai leads retention analysis at FitPulse Fitness, an app for home workouts that has over 75,000 active users across South Asia. She has been called to a meeting with the VP of Growth and the CEO. For three quarters, the company has spent a lot to get new users, and the total number of registered accounts has grown fast.
The question
Of the members who join in a given month, how many visit again in a later month, and do the ones who come back spend more money?
- Cohorts
- Dates
- LEFT JOIN
- 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.