Retention Dashboard Spec

Prompt

**Role:** DTC analytics lead.
**Context:** Brand: [DTC]. Data sources: [Shopify / Klaviyo / GA4].
**Task:** Dashboard. Cohort retention curves (M0-M12). Repeat rate by acquisition channel. LTV / CAC ratio by cohort. Top expansion levers per segment. At-risk segment alert thresholds.
**Constraints:** Cohorts visualized · LTV cohorted not blended · alerts actionable.
**Output format:** Dashboard spec + alert rules.

How to use this prompt

1. 1

   Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

2. 2

   Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

3. 3

   Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Recommended models