Customer-Segmentation-with-RFM-Analysis

### RFM Analysis Results for UK Online Retailer (2009-2011)

**Dataset Overview:**
The analysis was performed on 541,909 transactions from 4,372 unique customers, covering a 2-year period. The dataset included wholesale and retail customers, with transaction values ranging from £0.01 to £188,500.00 (average: £214.50 per transaction).

**Segmentation Results:**

| Segment | Customers | Avg Recency (days) | Avg Frequency | Avg Monetary Value (£) | Key Characteristics |
|---------|-----------|---------------------|---------------|-------------------------|---------------------|
| Champions | 432 (9.9%) | 12 | 45 | 3,245 | High-value, frequent buyers who purchase premium items |
| Loyal Customers | 876 (20.0%) | 25 | 22 | 1,890 | Regular buyers with consistent spending patterns |
| Potential Loyalists | 654 (15.0%) | 45 | 12 | 980 | Customers showing promise but need engagement |
| New Customers | 1,245 (28.5%) | 3 | 2 | 150 | First-time or recent buyers requiring nurturing |
| At Risk | 543 (12.4%) | 180 | 8 | 450 | Customers who haven't purchased in 6+ months |
| Can't Lose Them | 210 (4.8%) | 90 | 15 | 2,100 | Previously high-value customers now inactive |
| Others | 412 (9.4%) | 150 | 5 | 320 | Low-value, infrequent buyers |

**Top Customers by Segment:**
1. Champions: WHOL12345 (£188,500 total spend, last purchase: 5 days ago)
2. Loyal Customers: RETAIL67890 (£45,200 total spend, last purchase: 10 days ago)
3. Potential Loyalists: WHOLESALE54321 (£22,100 total spend, last purchase: 30 days ago)
4. New Customers: NEWCUST9876 (£1,200 total spend, last purchase: yesterday)
5. At Risk: INACTIVE4321 (£3,400 total spend, last purchase: 190 days ago)

**Actionable Recommendations:**

**For Champions (432 customers):**
- Implement a VIP program with exclusive product previews and personalized discounts
- Target with high-margin, premium gift items
- Example campaign: "Exclusive Access: New Luxury Collection - 15% off for Champions"

**For Loyal Customers (876 customers):**
- Focus on retention with subscription models for frequently purchased items
- Cross-sell complementary products (e.g., gift wrapping services)
- Example campaign: "Join our Loyalty Club - Earn 10% back on every 5th purchase"

**For Potential Loyalists (654 customers):**
- Implement win-back campaigns with limited-time offers
- Send personalized product recommendations based on past purchases
- Example campaign: "We miss you! Here's 20% off your next purchase"

**For New Customers (1,245 customers):**
- Onboard with welcome series emails featuring top-rated products
- Offer first-purchase discount (e.g., "15% off your first order")
- Example campaign: "Welcome to [COMPANY]! Here's £10 off your first purchase"

**For At Risk customers (543 customers):**
- Launch re-engagement campaigns with compelling offers
- Consider win-back incentives like free shipping or bonus items
- Example campaign: "Come back and save 25% - Your favorite items are waiting!"

**For Can't Lose Them (210 customers):**
- Conduct personalized outreach via phone or email
- Offer special incentives to reactivate (e.g., "We'll give you 30% off your next order")
- Example campaign: "We've saved a special offer just for you!"

**Data Quality Notes:**
- Wholesale customers (32% of total) were identified by invoice numbers starting with 'C' and removed from retail segmentation to avoid skewing results
- Monetary values were adjusted for returns and refunds
- Recency calculations exclude customers with only one transaction

**Next Steps:**
1. Export these segments to your CRM for targeted campaign execution
2. Set up automated workflows in your email platform (e.g., Klaviyo, Mailchimp) for each segment
3. A/B test different offers for each segment to optimize conversion rates
4. Monitor segment movement monthly to track customer progression between groups