🛒 Customer & Sales Analytics
End-to-end pipeline on 50,000 customers · 200,000 orders · ₹69.7Cr revenue — RFM · Cohort · LTV · Churn
Total Customers
50,000
Across 12 cities
Total Revenue
₹69.7Cr
Delivered orders only
Total Orders
200,000
163,999 delivered
Avg Order Value
₹4,250
Per delivered order
Avg LTV
₹17,127
Per customer
Churn Rate
59.28%
Inactive >6 months
Monthly Revenue Trend (₹ Millions) 2022–2024
Segment Distribution 4 Clusters
🟡 At Risk
8,258 users · Avg LTV ₹7,202 · Freq 1.9x
⭐ Champion
11,318 users · Avg LTV ₹25,684 · Freq 5.8x
🔴 Dormant
8,894 users · Avg LTV ₹3,431 · Freq 2.0x
✅ Loyal
19,623 users · Avg LTV ₹16,120 · Freq 3.3x
🛍️ Category & Channels
Performance
Churn Rate by Channel (%) Acquisition
01. Electronics leads revenue at ₹43.3Cr
→ Expand electronics catalog, premium SKUs High
02. Champion segment (41.7% of RFM revenue) from top customers
→ Build VIP loyalty program for Champions Critical
03. Churn rate: 59.28% of customers inactive >6 months
→ Launch win-back campaign for At Risk + Dormant Critical
04. Weekend revenue 22% higher than weekday average
→ Schedule flash sales for Sat–Sun Medium
05. 26–35 age group has highest avg LTV
→ Target this cohort for premium subscriptions High