Customer Segmentation Plan

A data-backed customer segmentation plan with defined segments, validation criteria, and activation recommendations.

Best For

•A CS ops lead deciding whether to segment customers by usage depth or company size before prioritizing CSM coverage
•A lifecycle marketer defining segment thresholds using product usage events to personalize onboarding emails
•A data analyst validating that a proposed k-means clustering approach produces stable, meaningful segments before it's activated in the CRM

Prompt Template

Design a customer segmentation plan for [COMPANY_NAME]'s [CUSTOMER_BASE, e.g., B2B SaaS customer base / e-commerce buyers]. Business objective of the segmentation: [OBJECTIVE, e.g., personalize onboarding emails / prioritize CSM coverage / identify expansion targets]. Available data for segmentation: [AVAILABLE_DATA, e.g., firmographic data, product usage events, CRM fields, purchase history]. The plan must include: (1) Segmentation hypothesis, propose 3–4 candidate segmentation approaches (e.g., by company size, by usage depth, by use case, by lifecycle stage) and recommend the best one with a rationale, (2) Segment definitions, for the recommended approach, define each segment with: name, description, qualifying criteria (using specific fields and thresholds), estimated % of customer base, and strategic value, (3) Data requirements, list every data field needed and its source system, (4) Analysis method, specify the technique (rule-based, k-means clustering, RFM scoring, etc.) and the tool/environment ([TOOL, e.g., SQL + Python, Tableau, dbt]), (5) Validation, how will you confirm the segments are meaningful and stable? (6) Activation plan, for each segment, the recommended action.

Pro Tip

Require an estimated percentage of the customer base for each proposed segment early on, since a segmentation scheme that produces one segment covering 80% of customers isn't actually useful for targeting.

Example Output

A sample of what this prompt produces once you fill in the placeholders.

Recommended approach: usage-depth segmentation over company-size, since usage predicts expansion better than firmographics in this dataset. Segments: Power Users (used 3+ core features weekly, roughly 18% of base, high expansion value), At-Risk (login frequency down 50%+ month over month, roughly 12% of base, CSM priority).