Intermediate · 30 min · 5 steps
Finding the best customers before you give discounts away
Pooja Hegde, Lead Retention Analyst at StyleKart Fashion
It is 10:15 AM on a Monday. Pooja Hegde, a retention analyst at StyleKart Fashion, is called to a review with the VP of Marketing. StyleKart is an online fashion store in India that ships over 450,000 orders a month. Over the weekend, marketing ran a 'Monsoon Mega Sale' and sent the same 15 percent discount code by SMS and WhatsApp to all 800,000 registered accounts.
The question
How can we count each customer's orders and total spending in pandas, then use percentiles to pick out the real VIP shoppers?
- RFM analysis
- Pandas groupby
- Aggregations
- Customer tiers
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.