Compare cumulative customer lifetime value across monthly cohorts

Spot whether newer customer groups spend faster or retain better than older cohorts. Use this to audit acquisition quality over time.

You getKey Findings, milestone Comparison Table and underlying Drivers

Prompt

Prompt
Act as a senior growth data analyst. Analyze the monthly customer cohort lifetime value data pasted below.

Rules:
- Calculate or compare cumulative spend per user at shared maturity milestones (such as Month 1, Month 3, and Month 6).
- Highlight which specific cohort shows the highest early velocity and which shows structural decay.
- Identify whether improvements stem from higher initial order values or stronger ongoing repeat purchasing.
- Flag data limitations or missing periods before drawing final conclusions.

Output format:
1. Key Findings: 3 concise bullet points on cohort health trends.
2. Milestone Comparison Table: Columns for Cohort, Month 1 LTV, Month 3 LTV, Month 6 LTV, Trajectory (Improving, Stable, Declining).
3. Underlying Drivers: Clear breakdown of average order value versus repeat rate.
4. Recommended Next Checks: 2 specific data cuts to investigate next.

My cohort data is pasted below:

Example output

Example for: monthly customer cohort data from Q1 to Q3

1. Key Findings
  • March cohort demonstrates the fastest early ramp, reaching $48 cumulative LTV by Month 3 compared to the $39 baseline set in January.
  • July cohort displays early stagnation, running 14% behind the historical Month 1 benchmark ($18 vs $21 average).
  • Mid-stage retention is stabilizing across all cohorts by Month 4, indicating that acquisition source shifts drive the variance rather than product changes.
2. Milestone Comparison Table
CohortMonth 1 LTVMonth 3 LTVMonth 6 LTVTrajectory
Jan$21.50$39.20$58.10Baseline
Feb$20.80$38.90$56.40Stable
Mar$24.10$48.30$67.50Improving
Apr$22.00$41.00$60.20Improving
May$19.50$36.80IncompleteDeclining
Jun$18.20$35.10IncompleteDeclining
Jul$17.90IncompleteIncompleteDeclining
3. Underlying Drivers
  • Initial Basket Size: March benefited from an introductory bundle promotion, lifting Day 0 average spend by $3.40 per user.
  • Repeat Repurchase Frequency: May and June suffered a 22% drop in second-order conversion within the first 30 days, causing the cumulative curve to flatten early.
4. Recommended Next Checks
  • Segment May and June cohorts by paid marketing channel to check if paid social expansion brought lower-intent traffic.
  • Check category-level repeat purchase rates to see if single-item SKU purchases reduced reorder frequency.
Written by AI from this prompt. Your results will vary.

Paste your raw monthly cohort table directly into ChatGPT, Claude or Gemini right after the prompt text. To go deeper, ask the model to project Month 12 LTV based on the early curve of each cohort.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis