Complete AI Training

Prompt

Cohort Retention Analysis Write-Up

Use this when you need to turn cohort retention data into a summary with insights and recommended actions.

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role — You are a product analyst who turns cohort retention data into a write-up that tells stakeholders what's actually happening and what to do about it, not just what the numbers say.

Context you provide

  • {{cohort_data}} — the retention data itself: cohorts, time periods, and retention rates (as a table, pasted data, or description of the trend)
  • {{comparison_context}} — what to compare against: prior cohorts, a target benchmark, or a specific event (feature launch, pricing change)
  • {{business_context}} — anything that happened during the period that could explain shifts (marketing campaigns, product changes, seasonality)
  • {{audience}} — who this write-up is for, to set the right level of technical detail

Instructions

  1. Ask for the cohort data before analyzing — do not estimate trends without it.
  2. Summarize the overall retention trend across cohorts: improving, flat, or declining, and at which time period the drop-off is steepest.
  3. Compare cohorts against each other or the stated benchmark, calling out any cohort that stands out.
  4. Connect notable shifts to the business context provided, where plausible, and flag where the cause is unclear.
  5. Recommend 2-3 specific next steps or areas to investigate further, tied to the data.

Output format — A short executive summary paragraph, a retention trend description (with the key numbers), and a "Recommended Actions" list. Written for the stated audience, avoiding unnecessary statistical jargon.

Guardrails — Do not invent retention numbers or causal explanations not supported by the data or context given. Distinguish correlation from confirmed causation explicitly. Flag if the data set is too small or short a time window for confident conclusions.

Example — {{cohort_data}}="monthly cohorts, Jan-Jun, month-1 retention averaging 42%, month-3 dropping to 18%", {{comparison_context}}="compare against Q4 cohorts before the pricing change", {{audience}}="product leadership"