Back to prompts
Data AnalysisChatGPTClaudeGemini

Customer Segmentation Analysis Prompt

Analyze your customer base to identify distinct segments based on behavior, demographics, and value — then generate targeted strategies for each segment to improve retention, upsell, and marketing ROI.

Prompt Template

You are a customer analytics and segmentation expert. Help me segment my customer base for:

**Business type:** [SaaS / e-commerce / marketplace / subscription service]
**Total active customers:** [approximate count]
**Data available:** [describe what data you have — purchase history, usage data, demographics, support tickets, survey responses]
**Current segmentation:** [none / basic (plan tier) / demographic only / behavioral]
**Primary goal:** [improve retention / personalize marketing / identify upsell targets / optimize ad spend / reduce churn]
**Key business metrics:** [e.g., ARPU, LTV, churn rate, NPS]

[Paste sample data or describe your customer data fields]

Provide:

1. **Segmentation methodology** — which approach fits your data best (RFM, behavioral, needs-based, value-based, or hybrid) with explanation
2. **Segment definitions** — 4-6 distinct customer segments with:
   - Segment name (memorable, team-friendly)
   - Size (% of base)
   - Key characteristics
   - Average metrics (LTV, ARPU, engagement score)
   - Example customer profile
3. **RFM analysis framework** — scoring methodology for Recency, Frequency, Monetary value with thresholds
4. **Segment-specific strategies** — for each segment:
   - Marketing approach (messaging, channels, frequency)
   - Product/feature priorities
   - Retention tactics
   - Revenue opportunity (upsell, cross-sell, or recovery)
5. **Migration paths** — how customers move between segments and what triggers migration
6. **Implementation plan** — how to operationalize segments in your CRM/tools
7. **Tracking dashboard** — KPIs to monitor per segment monthly

Example Output

Customer Segmentation Analysis: B2B SaaS (2,400 customers)

Methodology: Behavioral + Value Hybrid

Combining usage patterns (feature adoption, login frequency) with revenue metrics (MRR, expansion history) for the most actionable segments.

Segment Definitions

| Segment | Size | Avg MRR | Churn Risk | Key Trait |

|---------|------|---------|------------|----------|

| 🌟 Champions | 12% | $340 | Very Low | High usage, growing accounts, NPS 9-10 |

| 💼 Steady Operators | 35% | $180 | Low | Consistent usage, rarely contact support |

| 🌱 Rising Stars | 18% | $120 | Medium | Growing usage, recently adopted new features |

| 😴 Sleepers | 20% | $95 | High | Login declining, using only basic features |

| 🆘 At-Risk | 10% | $150 | Very High | Support tickets up, usage down, billing page visits |

| 👻 Ghosts | 5% | $80 | Critical | No login in 30+ days, no response to outreach |

Segment Strategy: Sleepers (20% of base)

**The problem:** They're paying but barely using the product. They'll churn at renewal.

**Marketing:** Re-engagement email series highlighting features they haven't tried. Personalized based on their industry.

**Product:** In-app prompt when they log in: "Teams like yours also use [feature]. Try it in 2 min."

**Retention:** Proactive CS check-in at 60 days before renewal. Offer a guided onboarding refresh.

**Revenue opportunity:** Low upsell potential until engagement improves. Focus on retention first.

Migration Paths

Rising Stars → Champions (trigger: 2+ features adopted + usage up 30%)

Steady Operators → Sleepers (trigger: login frequency drops 50% over 30 days)

Sleepers → At-Risk (trigger: no login for 14 days + billing page visit)

At-Risk → Ghosts (trigger: no response to 3 outreach attempts)

Ghosts → Churned (trigger: cancellation or payment failure)

Tracking Dashboard

| KPI | Champions | Steady | Rising | Sleepers | At-Risk | Ghosts |

|-----|-----------|--------|--------|----------|---------|--------|

| Segment size trend | ↑ growing? | stable? | ↑ growing? | ↓ shrinking? | ↓ shrinking? | ↓ shrinking? |

| Churn rate | <1% | <3% | <4% | <8% | <15% | <40% |

| Expansion rate | >5% | >2% | >3% | 0% | 0% | 0% |

| NPS | 9-10 | 7-8 | 7-8 | 5-6 | 3-5 | N/A |

Tips for Best Results

  • 💡Start with RFM if you have purchase/usage data but limited demographics — it's simple, proven, and immediately actionable.
  • 💡Give segments memorable names your team will actually use. 'Sleepers' sticks better than 'Segment 4: Low engagement, medium value'.
  • 💡Track segment migration monthly — the rate at which customers move from Steady to Sleeper is an early warning system for churn spikes.
  • 💡Don't create more than 6 segments to start. More segments means more strategies to maintain, and most teams can't execute on 10 different approaches.

Try it with

ChatGPTClaudeGemini

Related Prompts

Data Analysis

Marketing Attribution Analysis Prompt

Analyze your marketing channel data to understand which touchpoints drive conversions and where to allocate budget.

ChatGPTClaudeGemini
Data Analysis

Dataset Summary and Insights

Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.

ChatGPTClaudeGemini
Data Analysis

SQL Query Writer for Business Reports

Generate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.

ChatGPTClaude