Mini-project
Retail, E-commerce & Consumer Goods
Customer segments with RFM analysis
Group online shop customers by recency, frequency and spend, and plan a different action for each group.
The brief
A shop that treats every customer the same wastes offers on people who will buy anyway and ignores those about to leave. Segment customers by how recently they bought, how often and how much, name the segments, and recommend what to do for each: reward, win back, nurture or leave. Good looks like: sensible segment sizes, revenue share per segment, and an action plan with an estimated gain.
What you will build
- Clean the transaction data
- Calculate recency, frequency and monetary value
- Score and segment customers
- Describe each segment and its revenue share
- Recommend actions with estimated gains
- Build a simple dashboard
Free, open data to build it with
Sign up free to get the data and links
It takes a minute with your email. AiTeky Pass (₹999/month or ₹9,999/year) is free for your first 30 days.