Shopee — Cohort Retention

Shopee's growth team pulled a slice of order history and wants a cohort retention read: sign up in month zero, then track who comes back. Four sequential steps, one shared dataset — solve them in order, since each builds on the concept before it.

Schema

▸shopee_orders

order_id	SERIAL
customer_id	INT
order_date	DATE
order_amount	NUMERIC(10,2)

4 steps

1Find each customer's cohort month
2Build the cohort × month-offset activity matrix
3Convert counts into retention percentages
4Find the anomalous cohort

Basic

This is a Basic take-home

Multi-step case rounds — several questions on one shared dataset — unlock with a Basic plan.

See Basic plans

RM 25/mo · cancel anytime

Company names are trademarks of their respective owners, used here only to describe practice material. mahir_data is not affiliated with, endorsed by, or sponsored by any company named on this site. Terms.