Something went wrong!
Hang in there while we get back on track
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.
Input
What you provide to the skill
Analyze weekly cohort retention for our SaaS product. Attached CSV has user_id, signup_date, login_date with data from Aug-Sep 2025. Track 8 weeks of retention.
Output
What the skill generates for you
====================================================================================================
COHORT RETENTION ANALYSIS
Cohort Retention Table
| Cohort | Size | Week 0 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 |
|---|---|---|---|---|---|---|---|---|---|---|
| 2025-07-28 | 4 | 100.0% | 100.0% | 25.0% | 50.0% | 0.0% | 25.0% | 0.0% | 0.0% | 0.0% |
| 2025-08-04 | 8 | 100.0% | 87.5% | 62.5% | 50.0% | 50.0% | 12.5% | 0.0% | 0.0% | 0.0% |
| 2025-08-11 | 7 | 100.0% | 85.7% | 57.1% | 42.9% | 28.6% | 0.0% | 0.0% | 0.0% | 0.0% |
| 2025-08-18 | 7 | 100.0% | 85.7% | 42.9% | 42.9% | 14.3% | 0.0% | 0.0% | 0.0% | 0.0% |
| 2025-08-25 | 7 | 100.0% | 100.0% | 42.9% | 57.1% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
| 2025-09-01 | 7 | 100.0% | 100.0% | 57.1% | 42.9% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
| 2025-09-08 | 7 | 100.0% | 100.0% | 57.1% | 14.3% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
| 2025-09-15 | 3 | 100.0% | 100.0% | 33.3% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
====================================================================================================
KEY RETENTION METRICS
Week 1 Retention: 94.9% (avg across 8 cohorts)
Week 4 Retention: 11.6% (avg across 8 cohorts)
Week 8 Retention: 0.0% (avg across 8 cohorts)
====================================================================================================
COHORT PERFORMANCE ANALYSIS
Week 1 Retention Statistics:
- Mean: 94.9%
- Range: 85.7% - 100.0%
Best Performing Cohort: 2025-07-28
- Week 1 Retention: 100.0% (+5.1pp vs average)
Lowest Performing Cohort: 2025-08-11
- Week 1 Retention: 85.7% (-9.2pp vs average)
Trend Detected: Retention is improving
- Early cohorts avg: 89.7%
- Recent cohorts avg: 100.0%
- Change: +10.3pp
====================================================================================================
INSIGHTS & RECOMMENDATIONS
Findings:
-
GOOD: Week 1 retention at 94.9% shows solid initial engagement.
- Nearly all users who sign up return within the first week
- This indicates strong initial value delivery
-
CRITICAL CONCERN: Large drop-off from Week 1 to Week 4 (83.3pp)
- Only 11.6% of users remain active by Week 4
- This represents the primary retention challenge for your SaaS product
- Action Required: Identify Week 2-4 engagement drivers, implement re-engagement campaigns
-
SEVERE: Week 8 retention is 0.0%
- No cohorts in this dataset show activity beyond 5 weeks
- This indicates a fundamental long-term retention problem
- Action Required: Investigate why users churn before establishing habit formation
-
POSITIVE TREND: Recent cohorts showing improvement
- Week 1 retention has improved +10.3pp from early to recent cohorts
- Recent cohorts (Sept 2025) achieve 100% Week 1 retention
- This suggests recent product improvements or better user targeting
Recommended Next Steps:
-
Immediate Actions:
- Implement automated email campaigns at Days 7, 14, and 21 to prevent Week 2-4 drop-off
- Survey users who churned between Week 1-4 to understand friction points
- Add in-app value reinforcement during Week 2-3 (the critical drop-off period)
-
Investigation & Analysis:
- Segment cohorts by acquisition channel to identify high-quality sources
- Analyze feature usage patterns among retained vs churned users
- Track “aha moments” and correlate with retention success
- Identify if there’s a paywall, feature limit, or onboarding gap causing Week 4 cliff
-
Product Improvements:
- Strengthen Week 2-4 engagement hooks (notifications, reminders, social proof)
- Consider implementing a milestone-based progression system
- Test retention interventions on new cohorts and measure impact
-
Long-term Strategy:
- Run user interviews with any users who reach Week 4+ to understand success patterns
- Build retention prediction model to identify at-risk users early
- Establish Week 4 retention as a North Star metric for product team
Output Files:
- Retention table saved to:
/tmp/cohort_retention_table.csv
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.
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.