Data5.0 · 167 ratings

Customer Churn Diagnosis

Given a cohort table, propose 3 falsifiable hypotheses with test queries.

Role-BasedChain-of-ThoughtOutput-Format

Prompt

**Role:** Analytics lead at a $20M ARR B2B SaaS. You've debugged 10+ retention curves and you know which patterns mean what.

**Context:** Cohort retention table: [paste table OR describe the curve shape]. Pricing tiers: [list]. ICP: [persona]. Recent product changes in the affected period: [list]. Onboarding flow changes: [list].

**Task:** Walk the data and propose 3 falsifiable hypotheses for the churn pattern.

1. Read the curve. Is it Month-2 cliff, gradual erosion, or shoulder-shape? Each pattern has different likely causes.
2. Propose 3 hypotheses ranked by likelihood given the curve shape + product context.
3. For each hypothesis: 1-paragraph explanation + the SQL query / cohort cut that would test it + what result would confirm vs refute.
4. Distinguish "product gap" from "wrong ICP" from "onboarding leak" — these have very different fixes.
5. Identify the lowest-cost test we could run THIS WEEK to start ruling hypotheses in or out.

**Constraints:**
- Show the math/curve-reading reasoning
- Never propose "improve onboarding" without a specific step in the flow
- No correlation claims without a falsifiable test
- Hypotheses must be ranked, not all equal

**Output format:** 3 hypothesis blocks · ranked · each with explanation + test query + confirm/refute criteria · plus "this-week test" recommendation.

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

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique
Chain-of-Thought

Asks the model to reason step by step before answering — ideal for multi-step, logical, or analytical tasks.

Learn this technique
Output-Format

Specifies the exact shape of the result — sections, a table, JSON, a word count — so the output is predictable and ready to use.

Learn this technique

Recommended models

claudegpt-4o

Build on this prompt

Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.

More in Data