RFM Segmentation for E-commerce with Personalized Campaigns

Implement an RFM segmentation system for [STORE/COMPANY NAME], an e-commerce store in the [NICHE] space with [NUMBER] customers in the database and monthly revenue of [CURRENCY] [AMOUNT].

**Data required for analysis:**
- Purchase history: [NUMBER] months (minimum 12)
- Fields: Customer ID, purchase date, purchase value
- Data source: [PLATFORM: Shopify/VTEX/WooCommerce/CRM]
- Email platform: [ACTIVECAMPAIGN/KLAVIYO/RD STATION/MAILCHIMP]

**1) RFM Calculation:**

*Metric definitions:*
- **R (Recency):** How many days since last purchase? (lower is better)
- **F (Frequency):** How many purchases in the period? (higher is better)
- **M (Monetary):** What is total spend? (higher is better)

*Scoring 1-5 for each dimension:*

**Recency:**
| Score | Days since last purchase |
|-------|--------------------------|
| 5 | 0-30 days |
| 4 | 31-60 days |
| 3 | 61-90 days |
| 2 | 91-180 days |
| 1 | 181+ days |

**Frequency:**
| Score | Number of purchases in period |
|-------|-------------------------------|
| 5 | [X]+ purchases |
| 4 | [X-1] purchases |
| 3 | [X-2] purchases |
| 2 | 2 purchases |
| 1 | 1 purchase |

**Monetary:**
| Score | Total spend |
|-------|-------------|
| 5 | [CURRENCY] [AMOUNT]+ |
| 4 | [CURRENCY] [AMOUNT] to [CURRENCY] [AMOUNT] |
| 3 | [CURRENCY] [AMOUNT] to [CURRENCY] [AMOUNT] |
| 2 | [CURRENCY] [AMOUNT] to [CURRENCY] [AMOUNT] |
| 1 | Up to [CURRENCY] [AMOUNT] |

*Adjust the values above based on your average order value and customer behavior.*

**2) RFM Segments and profiles:**

| Segment | RFM Score | Characteristics | Estimated % of list |
|---------|-----------|-----------------|---------------------|
| **Champions** | R5F5M5 | Purchased recently, buy frequently, spend the most | [X]% |
| **Loyal** | R3+F4+M4+ | Regular buyers, respond to promotions | [X]% |
| **Potential Loyalists** | R4+F2-3M3+ | Recent customers who buy with some frequency | [X]% |
| **New Customers** | R5F1M1-3 | Made first purchase recently | [X]% |
| **At Risk** | R3F3M3 | Above-average customers who haven't purchased recently | [X]% |
| **Can't Lose Them** | R2F3+M3+ | High-value historical customers who stopped purchasing | [X]% |
| **Hibernating** | R2F2M2 | Low activity, minimal engagement | [X]% |
| **Lost** | R1F1M1 | One old purchase, never returned | [X]% |

**3) Campaign strategy by segment:**

**Champions (VIP treatment):**
- Goal: Keep engaged + turn into brand ambassadors
- Frequency: High (2-3x/week)
- Campaigns:
  - Early access to new launches
  - Exclusive referral program (commission or store credit)
  - Personal thank-you note (founder email)
  - Invitation to product beta testing
- KPI: Maintain Recency ≤ 30 days

**Loyal:**
- Goal: Increase frequency and order value
- Frequency: Moderate-high (1-2x/week)
- Campaigns:
  - Points/loyalty program
  - Upsell based on purchase history ("You bought X, try Y")
  - Exclusive offers for loyal customers
  - Smart cross-sell recommendations
- KPI: Increase average order value by [%]

**Potential Loyalists:**
- Goal: Convert to Loyal (second and third purchases are critical)
- Frequency: Moderate (1x/week)
- Campaigns:
  - 5-email nurturing series with valuable content
  - "Buy Again" offer with incentive
  - Testimonials from similar customers
  - Progressive discount for second purchase
- KPI: Second purchase rate

**New Customers:**
- Goal: Welcome sequence and first repeat purchase
- Campaigns:
  - 7-email welcome series (see dedicated prompt)
  - Product tutorial/usage guide
  - Second purchase incentive (valid for 30 days)
- KPI: Second purchase rate within 60 days

**At Risk / Can't Lose Them:**
- Goal: Urgent recovery
- Frequency: High for limited time
- Campaigns:
  - Personalized win-back campaign
  - Aggressive offer (discount or free shipping)
  - Personal email simulating human contact
  - Survey: Why did you stop purchasing?
- KPI: Reactivation rate

**Lost:**
- Goal: Final attempt, then remove from list
- Campaigns:
  - Single email with best possible offer
  - "Can we remove you from our list?"
  - List cleaning (improves deliverability)
- KPI: Reactivation cost vs. new customer CAC

**4) Technical implementation:**

*Classification workflow:*
- Export data from [E-COMMERCE PLATFORM]
- Calculate R, F, M and composite score in Google Sheets or Python
- Import segments into email tool with tags/lists
- Re-segmentation frequency: monthly (scores change over time)

*Event-based automation:*
- Customer moves from Loyal to At Risk → automatic win-back trigger
- Customer makes first purchase → enters New segment + welcome series
- Champion who hasn't purchased in 45 days → customer service alert

**5) Metrics by segment:**

| Segment | Current Revenue | Target Revenue | Priority Campaign |
|---------|----------------|---------------|-------------------|
| Champions | [CURRENCY] [X] | [CURRENCY] [X]+10% | VIP program |
| Loyal | [CURRENCY] [X] | [CURRENCY] [X]+20% | Loyalty program |
| At Risk | [CURRENCY] [X] | [CURRENCY] [X]+50% | Win-back |

Expected ROI from RFM segmentation vs. mass sends: [%] increase in email revenue without increasing send volume.