Intermediate · 25 min · 4 steps
Splitting shoppers into four equal groups by how much they spend
Ananya Sen, Growth Data Engineer at ShopKart Retail
It is Tuesday, 9:00 AM. Ananya Sen is a data analyst at ShopKart, an online shop for fashion and electronics with over 8 million registered shoppers in India. She is in the weekly marketing meeting. The Vice President of Growth says there is a Rs 1.5 crore budget to bring shoppers back for the Diwali sale. But earlier mass emails with the same offer got only a 1.4% click rate.
The question
How do we split customers into four equal groups by spending, and pick out the top group of VIP shoppers?
- NTILE
- Window functions
- Customer segmentation
- CTEs
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.