Customer Churn Diagnosis
Given a cohort table, propose 3 falsifiable hypotheses with test queries.
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
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
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
Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniqueAsks the model to reason step by step before answering — ideal for multi-step, logical, or analytical tasks.
Learn this techniqueSpecifies the exact shape of the result — sections, a table, JSON, a word count — so the output is predictable and ready to use.
Learn this techniqueRecommended models
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.