These prompts help product teams use AI to analyze cohort retention data. Replace [bracketed placeholders] with your specifics.
Prompt 1: Analyze a cohort retention table
Here is a cohort retention table for [product name]:
[Paste the table — rows: cohort (by signup week/month), columns: Day 0, Day 1, Day 7, Day 14, Day 30, Day 60, Day 90; cells: retention percentage]
Product context: [brief description, any major changes during the period]
Please:
1. Identify the time point with the steepest retention drop across all cohorts
2. Compare the same retention metric (e.g., Day-7) across cohorts — is it trending up, down, or stable?
3. Flag any cohort with anomalously high or low retention and suggest possible causes
4. Calculate the average retention curve and the best/worst performing cohort
5. Recommend 2-3 actions to improve retention at the steepest drop point
6. Suggest which behavioral events to investigate as predictors of long-term retentionPrompt 2: Compare retention by behavioral cohorts
I have retention data split by a behavioral event: [event name, e.g., "completed onboarding"].
Group A (did the event): [number] users
[Paste retention data: Day 1, Day 7, Day 14, Day 30 retention rates]
Group B (did not do the event): [number] users
[Paste retention data: Day 1, Day 7, Day 14, Day 30 retention rates]
Product context: [what the event is, when it typically occurs, any recent changes]
Please:
1. Calculate the retention gap between groups at each time point
2. Determine if the gap is statistically significant (chi-square test)
3. Estimate the business impact: if we increased the event completion rate by [X]%, how many more users retained at Day 30?
4. Suggest ways to increase the event completion rate
5. Assess whether this event is a true driver or a correlationPrompt 3: Design a retention measurement framework
I need to set up cohort retention tracking for [product name/type].
Context:
- Product type: [B2B SaaS / consumer app / e-commerce / etc.]
- Primary user action (core value): [what users come back to do]
- Current retention tracking: [what exists now]
- Business goal: [target retention level]
Please create a retention measurement framework:
1. Define the retention event
2. Recommend cohort grouping (daily/weekly/monthly) with rationale
3. List the time intervals to track and why each matters
4. Suggest 3-5 behavioral cohorts to compare
5. Recommend acquisition channel splits
6. Provide industry retention benchmarks for this product type
7. Describe the dashboard layout
8. Set alert thresholds