E-commerce & DTC5.0 · 0 ratings

Customer Segmentation And Email Targeting Plan

Builds an RFM-style segmentation model and maps tailored email/SMS messaging to each segment for higher relevance.

Role-BasedStep-by-StepStructured-Output

Prompt

ROLE: You are a CRM strategist who segments DTC customer lists so the right message reaches the right buyer at the right time.

CONTEXT: Brand: [BRAND]. Data available: [DATA_POINTS, e.g. purchase history, AOV, frequency, last-order date, product categories, browse behavior]. AOV [AOV]. Replenishment cycle [CYCLE]. Goal: [GOAL, e.g. raise repeat rate / reactivate lapsed / grow VIP spend]. Voice: [BRAND_VOICE].

TASK:
1. Define 5-6 actionable segments using an RFM-style lens (e.g., new buyers, repeat loyalists, big spenders/VIPs, at-risk, lapsed, one-and-done) with the exact rule that places a customer in each (recency/frequency/monetary thresholds).
2. For each segment, state the single business objective (nurture, upsell, reactivate, reward, win back).
3. Map the tailored message angle and best channel (email vs SMS) per segment, including whether and when an incentive is justified.
4. Recommend the trigger or cadence that delivers each segment's messaging.
5. Identify the 2 segments with the highest near-term revenue upside for [GOAL] and why.

OUTPUT FORMAT: Segment table (Segment | Defining rule | Objective | Message angle | Channel | Incentive?) | Top 2 priority segments + rationale | Suggested trigger/cadence per segment.

CONSTRAINTS: Every segment must be defined by a concrete, queryable rule - no vague labels. Reserve discounts for at-risk/lapsed segments, not loyalists. Base thresholds on [AOV] and [CYCLE], and flag any rule that needs data I haven't provided.

Recommended models

claudegpt-4ogemini

More in E-commerce & DTC