wowprompt

Cohort retention analysis from signup and activity data

Builds a cohort retention table from signup and activity records and explains where users drop off and which cohorts behave differently. Use it to judge whether product or onboarding changes are actually keeping users longer.

A cohort triangle table of retention percentages by signup month and period, a retention curve summary and four findings with figures
The output this prompt produced, unedited.

The prompt

Goal

Turn raw user activity into a cohort retention table and explain what it says about how long users stay.

Inputs

  • Product and what counts as active: [e.g. a meal planning app; active means opened a plan]
  • Cohort period: [weekly or monthly]
  • Number of periods to track: [e.g. 6 months]
  • Data: [paste rows with user ID, signup date and activity dates, or pre-counted cohorts]
  • Changes shipped during this time: [e.g. new onboarding in March]

Steps

  1. Assign each user to the cohort of their signup period.
  2. For each cohort, count users active in period 0, 1, 2 and onward.
  3. Divide by cohort size to get retention percentages.
  4. Compare cohorts before and after each listed change.

Output format

  1. Cohort table: rows are cohorts with their size, columns are periods, cells are retention percentages.
  2. Average curve: the weighted average retention for each period.
  3. Drop-off point: the period with the steepest loss and its size.
  4. Findings: four numbered points, each with a figure and a comparison.
  5. Next questions: three things to investigate, such as which actions retained users share.

Check before answering

  • Period 0 is 100 percent for every cohort by definition.
  • Cells for periods that have not happened yet are left blank, not zero.
  • Averages are weighted by cohort size, not a simple mean of percentages.
  • Cohorts under 50 users are marked as low sample.
  • Any link to a product change is stated as possible, not proven.
  • The definition of active is repeated above the table.
cohort analysisretention analysiscustomer retention ratechurn analysisuser retention table

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity