From pm-data-analytics
Analyzes user retention, feature adoption, and engagement trends by cohort from CSV data or descriptions, producing markdown reports, tables, CSVs, and recommendations.
npx claudepluginhub lamngit1995/phuryn-pm-skills<data file or description of what to analyze># /analyze-cohorts -- Cohort Analysis Analyze user retention and engagement patterns by cohort. Upload your data or describe what you need, and get retention curves, feature adoption trends, and actionable insights. ## Invocation ## Workflow ### Step 1: Accept Data or Define Analysis Two paths: - **With data**: User uploads a CSV/spreadsheet with user-level data (user_id, signup_date, activity_date, event_type, etc.) - **Without data**: User describes the analysis they need → generate the SQL query and analysis framework ### Step 2: Define Cohorts Ask: - What defines a cohort? (sig...
/analyze-cohortsAnalyzes user retention, feature adoption, and engagement trends by cohort from CSV data or descriptions, producing markdown reports, tables, CSVs, and recommendations.
/analyze-cohortsAnalyzes user retention, feature adoption, and engagement trends by cohort from CSV data or descriptions, producing markdown reports, tables, CSVs, and recommendations.
/analyze-cohortsAnalyzes user retention, feature adoption, and engagement trends by cohort from CSV data or descriptions, producing markdown reports, tables, CSVs, and recommendations.
/analyze-cohortsAnalyzes user retention, feature adoption, and engagement trends by cohort from CSV data or descriptions, producing markdown reports, tables, CSVs, and recommendations.
/analyze-cohortsAnalyzes user retention, feature adoption, and engagement trends by cohort from CSV data or descriptions, producing markdown reports, tables, CSVs, and recommendations.
Analyze user retention and engagement patterns by cohort. Upload your data or describe what you need, and get retention curves, feature adoption trends, and actionable insights.
/analyze-cohorts [upload a CSV of user activity data]
/analyze-cohorts Monthly retention for users who signed up in Jan-Jun, grouped by acquisition channel
/analyze-cohorts Help me set up a cohort analysis for our onboarding redesign
Two paths:
Ask:
Apply the cohort-analysis skill:
If data is provided:
If describing an analysis:
## Cohort Analysis: [Description]
**Date**: [today]
**Cohort definition**: [e.g., signup month]
**Retention event**: [e.g., completed a project]
**Granularity**: [weekly/monthly]
### Retention Table
| Cohort | Size | Week 1 | Week 2 | Week 3 | ... | Week 12 |
|--------|------|--------|--------|--------|-----|---------|
### Key Findings
1. **[Finding]** — [supporting data]
2. ...
### Cohort Comparison
- **Best-performing cohort**: [which, why]
- **Worst-performing cohort**: [which, why]
- **Trend**: [improving/declining/stable over time]
### Retention Benchmarks
| Period | Your Rate | Industry Benchmark | Gap |
|--------|----------|-------------------|-----|
### Recommendations
1. [What to investigate or change based on findings]
2. ...
### Follow-Up Queries
[SQL queries for deeper investigation]
If data was provided, save analysis as both markdown report and CSV/spreadsheet.