Something went wrong!
Hang in there while we get back on track
Mobile App Monthly Retention with Product Update Analysis
Analyze monthly cohort retention for a mobile app to evaluate if a product update improved user retention, comparing pre and post-update cohort performance.
Input
What you provide to the skill
I have user event data: columns are customer_id, install_date, last_active. Monthly cohorts preferred, tracking 6 months. The CSV shows mobile app usage starting June 2025. Need to identify if retention is improving post-product update in August.
Output
What the skill generates for you
COHORT RETENTION ANALYSIS SUMMARY
====================================================================================================
Generated: 2025-12-12 01:40:36
Total Cohorts Analyzed: 6
Date Range: June 2025 to November 2025
====================================================================================================
KEY METRICS
Month 1 Retention: 69.4% (avg across 6 cohorts)
Month 3 Retention: 20.0% (avg across 1 cohort)
====================================================================================================
RETENTION TABLE
| Cohort | Size | Month 0 | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 |
|---|---|---|---|---|---|---|---|---|
| 2025-06 | 10 | 100.0% | 50.0% | 40.0% | 20.0% | 10.0% | — | — |
| 2025-07 | 12 | 100.0% | 41.7% | 16.7% | — | — | — | — |
| 2025-08 | 12 | 100.0% | 100.0% | 66.7% | — | — | — | — |
| 2025-09 | 12 | 100.0% | 100.0% | 33.3% | — | — | — | — |
| 2025-10 | 12 | 100.0% | 91.7% | — | — | — | — | — |
| 2025-11 | 12 | 100.0% | 33.3% | — | — | — | — | — |
====================================================================================================
COHORT PERFORMANCE ANALYSIS
Month 1 Retention Statistics:
- Mean: 69.4%
- Range: 33.3% - 100.0%
Best Performing Cohort: 2025-08
- Month 1 Retention: 100.0% (+30.6pp vs average)
Lowest Performing Cohort: 2025-11
- Month 1 Retention: 33.3% (-36.1pp vs average)
PRE vs POST PRODUCT UPDATE (August 2025):
- Pre-August cohorts (Jun-Jul): 45.8% avg Month 1 retention (2 cohorts)
- Post-August cohorts (Aug+): 81.2% avg Month 1 retention (4 cohorts)
- Change: +35.4pp
STRONG IMPROVEMENT - Product update appears to have significantly improved retention!
====================================================================================================
INSIGHTS & RECOMMENDATIONS
Key Findings:
-
Product update in August shows dramatic impact: Month 1 retention jumped from 45.8% (pre-August) to 81.2% (post-August) - a +35.4 percentage point improvement.
-
August & September cohorts performing exceptionally well: Both achieved 100% Month 1 retention, suggesting the product changes are highly effective at keeping users engaged in their first month.
-
November cohort shows concerning decline: At 33.3% Month 1 retention, this represents the worst performance. Investigate if any changes were made in late October/November that may have degraded the user experience.
-
Long-term retention needs more data: Only June cohort has sufficient data for Month 3-4 tracking. While Month 3 shows 20% retention, more time is needed to evaluate long-term impact of the August update.
RECOMMENDED NEXT STEPS:
- Deep-dive on August cohort: Document exactly what changed in the product update that drove 100% Month 1 retention
- Compare power user behaviors: Analyze feature usage patterns between high-performing (Aug/Sep) vs low-performing (Jul/Nov) cohorts
- Survey churned users: Contact users from June/July who churned to understand pre-update pain points
- Track feature adoption: Identify which specific features August+ cohorts use differently than earlier cohorts
- Investigate November decline: Urgently review any product/UX changes made in late October that may explain the sharp November drop
- A/B test further improvements: With such strong post-update performance, test incremental onboarding enhancements to push Month 1 retention even higher
- Monitor Month 2-3 retention for newer cohorts: Track August/September cohorts through Month 3-6 to validate long-term retention improvements
====================================================================================================
OUTPUT FILES
CSV Table: /tmp/cohort_analysis/output/cohort_retention_table.csv
Full Summary: /tmp/cohort_analysis/output/analysis_summary.txt
====================================================================================================
About This Skill
Build cohort retention analysis from user event data. Generate retention tables, visualizations, key metrics (D1, D7, D30), and actionable insights for product and growth teams.
View Skill DetailsMore Examples
E-commerce Daily Cohort Retention with Anomaly Detection
Analyze daily cohort retention for e-commerce transaction data using custom column names, identifying anomalies in cohort performance and providing actionable recommendations for improving repeat purchase rates.
SaaS Product Weekly Retention Analysis
Analyze weekly cohort retention for a SaaS product, tracking 8 weeks of user engagement with retention tables, key metrics, trend detection, and actionable recommendations for reducing churn.