Intermediate · 30 min · 5 steps
Why 15 days looked like the whole story, and what a customer really stays
Meera Sen, Senior SaaS Retention Analyst at StreamCloud OTT
It is 10:30 AM on a Monday. Meera Sen, a retention analyst at StreamCloud OTT, is called to a growth review with the Chief Product Officer. StreamCloud is a video streaming service with over 350,000 paying subscribers in South Asia. Last month's report showed monthly churn jumping to 8.4 percent, and marketing spent more than ₹22,00,000 to win new customers to replace those who left.
The question
How do we turn start and end dates into subscription lengths in pandas, and add them up for each customer to see how long they really stay?
- Subscription retention
- Datetime arithmetic
- Pandas describe
- SaaS metrics
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.