Agent skill

Cohort Analysis and Retention Explorer

by phuryn in phuryn/pm-skills

Analyzes uploaded cohort data to compute retention curves and feature adoption trends, builds heatmaps and charts, and suggests qualitative follow-up research.

MITAuto-check passedData & Analytics

Install Cohort Analysis and Retention Explorer

skills CLI
$ npx skills add phuryn/pm-skills --skill cohort-analysis -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install phuryn/pm-skills cohort-analysis --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/phuryn/pm-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/pm-data-analytics/skills/cohort-analysis .claude/skills/cohort-analysis && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
cohort-analysis
GitHub stars
27k
Token cost
~1.3k tokens
SKILL.md length
482 words
Files
1
Skills in repo
67
Repo updated
First seen
Licence
MIT

At a glance

Analyzes uploaded cohort data to compute retention curves and feature adoption trends, builds heatmaps and charts, and suggests qualitative follow-up research.

  • Works in 5 steps: Read and Validate Your Data → Generate Quantitative Analysis → Create Visualizations → …
  • Understanding retention differences across user cohorts
  • SKILL.md covers Purpose, How It Works, Usage Examples and Key Capabilities, plus 2 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Starting from a CSV, Excel or JSON file, the skill first checks the data structure for a cohort identifier, time periods and engagement metrics, flags missing values, and summarizes cohort sizes and date ranges before any analysis runs. It then calculates retention rates, drop-off patterns, feature adoption rates across cohorts, and period-over-period changes, optionally generating pandas and numpy scripts when the user wants runnable code.

Visualization covers retention heatmaps of cohorts against time periods, line charts of cohort progression, feature-adoption comparison charts and drop-off visualizations, delivered as interactive charts or static images. From there it looks for patterns worth flagging, such as early churn in a specific cohort, late-stage engagement shifts, adoption clusters or seasonal effects, and compares cohorts against each other as a baseline.

The last step turns quantitative findings into qualitative next steps: targeted interviews with churning users, usage surveys for engaged cohorts, session replays of key interactions, or a win-loss comparison between high and low retention cohorts, plus suggestions for a follow-up A/B test or feature experiment.

When your agent uses it

  • Understanding retention differences across user cohorts
  • Comparing feature adoption curves between groups of users
  • Turning a retention pattern into a concrete follow-up research plan

Example prompts

  • “Analyze retention by monthly cohort in cohort_engagement.csv.”
  • “Compare adoption curves for our new feature across the last six cohorts.”
  • “Why is the March cohort churning faster than earlier ones?”

Requirements

  • A cohort data file in CSV, Excel or JSON format

Workflow steps

5 steps, taken from the step headings in SKILL.md.

  1. Read and Validate Your Data
  2. Generate Quantitative Analysis
  3. Create Visualizations
  4. Identify Insights & Patterns
  5. Suggest Follow-Up Research

What it can do on your machine

Read from SKILL.md and the folder at commit 8607e3b. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • productcompass.pm

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Cohort Analysis and Retention Explorer loads about 1.3k tokens when it runs. Until then it costs about 71 tokens; SKILL.md has 482 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~71
When it runs · the whole SKILL.md, loaded when a task matches
~1.3k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from phuryn/pm-skills at commit 8607e3b, republished under its MIT licence (© phuryn). 482 words, ~1,256 tokens.

Download SKILL.mdSave it as .claude/skills/cohort-analysis/SKILL.md (or your agent's skills folder).
name
cohort-analysis
description
Perform cohort analysis on user engagement data — retention curves, feature adoption trends, and segment-level insights. Use when analyzing user retention by cohort, studying feature adoption over time, investigating churn patterns, or identifying engagement trends.

Cohort Analysis & Retention Explorer

Purpose

Analyze user engagement and retention patterns by cohort to identify trends in user behavior, feature adoption, and long-term engagement. Combine quantitative insights with qualitative research recommendations.

How It Works

Step 1: Read and Validate Your Data
  • Accept CSV, Excel, or JSON data files with user cohort information
  • Verify data structure: cohort identifier, time periods, engagement metrics
  • Check for missing values and data quality issues
  • Summarize key statistics (cohort sizes, date ranges, metrics available)
Step 2: Generate Quantitative Analysis
  • Calculate cohort retention rates and engagement trends
  • Identify retention curves, drop-off patterns, and anomalies
  • Compute feature adoption rates across cohorts
  • Calculate month-over-month or period-over-period changes
  • Generate Python analysis scripts using pandas and numpy if requested
Step 3: Create Visualizations
  • Generate retention heatmaps (cohorts vs. time periods)
  • Create line charts showing cohort progression
  • Build comparison charts for feature adoption
  • Visualize drop-off points and engagement trends
  • Output as interactive charts or static images
Step 4: Identify Insights & Patterns
  • Spot one or more significant patterns:
    • Early churn in specific cohorts
    • Late-stage engagement changes
    • Feature adoption clusters
    • Seasonal or temporal trends
  • Highlight surprising findings and deviations
  • Compare cohort performance to establish baselines
Step 5: Suggest Follow-Up Research
  • Recommend qualitative research methods:
    • Targeted user interviews with churning users
    • Feature usage surveys with engaged cohorts
    • Session replays of key interaction patterns
    • Win/loss analysis for high vs. low retention cohorts
  • Design follow-up quantitative studies
  • Suggest A/B tests or feature experiments

Usage Examples

Example 1: Upload CSV Data

Upload cohort_engagement.csv with columns: cohort_month, weeks_active,
user_id, feature_x_usage, engagement_score

Request: "Analyze retention patterns and identify why Q4 2025 cohorts
underperform compared to Q3"

Example 2: Describe Data Format

"I have monthly user cohorts from Jan-Dec 2025. Each row shows:
cohort date, user ID, purchase frequency, and support tickets.
Analyze which cohorts show best long-term retention."

Example 3: Feature Adoption Analysis

Upload feature_usage.xlsx with cohort adoption data.

Request: "Compare adoption curves for our new feature across cohorts.
Which cohorts adopted fastest? Any patterns?"

Key Capabilities

  • Data Reading: Import CSV, Excel, JSON, SQL query results
  • Retention Analysis: Calculate and visualize retention rates over time
  • Cohort Comparison: Compare metrics across cohort groups
  • Anomaly Detection: Flag unusual patterns or drop-offs
  • Python Scripts: Generate reusable analysis code for ongoing analysis
  • Visualizations: Create heatmaps, charts, and interactive dashboards
  • Research Design: Suggest targeted follow-up studies and interview approaches
  • Statistical Summary: Provide quantitative metrics and correlation analysis
Show full SKILL.md (162 more words)Show less

Tips for Best Results

  1. Include time dimension: Provide data across multiple time periods
  2. Define cohort clearly: Make cohort grouping explicit (signup month, feature launch date, etc.)
  3. Provide context: Explain product changes, launches, or events during the period
  4. Multiple metrics: Include retention, engagement, feature usage, revenue, etc.
  5. Sufficient data: At least 3-4 cohorts for meaningful pattern identification
  6. Request specific output: Ask for visualizations, Python scripts, or research recommendations

Output Format

You'll receive:

  • Data Summary: Cohort overview and data quality assessment
  • Quantitative Findings: Key metrics, retention rates, and trend analysis
  • Visualizations: Charts showing retention curves, adoption patterns
  • Pattern Identification: 2-3 significant insights from the data
  • Research Recommendations: Specific qualitative and quantitative follow-ups
  • Analysis Scripts (if requested): Python code for reproducible analysis
  • Next Steps: Prioritized actions based on findings

Further Reading

© phuryn, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in pm-data-analytics/skills/cohort-analysis of phuryn/pm-skills.

Open the folder on GitHubat commit 8607e3b

Compare with similar skills

Cohort Analysis and Retention Explorer next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Cohort Analysis and Retention Explorer compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Cohort Analysis and Retention Explorer this skillphuryn/pm-skills27k—~1.3kAutomated safety check: PassMIT
Python Executorcortega26/chile-hub1132 repos~1.5kAutomated safety check: PassMIT
Vaex Out-of-Core DataFramesdavila7/claude-code-templates32k12 repos~1.6kAutomated safety check: PassMIT
Release Evidence WorkflowAli-Marandi/ClimateDataAnalyzer107—~1.6kAutomated safety check: PassMIT
SeabornzLanqing/codex-claude-academic-skills4.7k15 repos~4.9kAutomated safety check: PassBSD-3-Clause
Retentioneering Product Analyticsretentioneering/retentioneering-tools925—~1.6kAutomated safety check: PassApache-2.0

Similar skills

  • Python Executor

    cortega26/chile-hub

    Execute Python code in a safe sandboxed environment via [inference.sh](https://inference.sh).

    113 GitHub starsUsed in 2 repos~1.5k tokens
    Data & AnalyticsAuto-check passed
  • Vaex Out-of-Core DataFrames

    davila7/claude-code-templates

    Processes tabular datasets too large for RAM with Vaex: lazy DataFrames, fast aggregations, big-data plots and ML pipelines over CSV, HDF5, Arrow and Parquet.

    32k GitHub starsUsed in 12 repos~1.6k tokens
    Data & AnalyticsAuto-check passed
  • Release Evidence Workflow

    Ali-Marandi/ClimateDataAnalyzer

    Build an auditable release-evidence workflow for a desktop or packaged application.

    107 GitHub stars~1.6k tokensUpdated 1 mo ago
    Data & AnalyticsAuto-check passed
  • Seaborn

    zLanqing/codex-claude-academic-skills

    Statistical visualization with pandas integration. An agent skill from zLanqing/codex-claude-academic-skills.

    4.7k GitHub starsUsed in 15 repos~4.9k tokens
    Data & AnalyticsAuto-check passed
  • Retentioneering Product Analytics

    retentioneering/retentioneering-tools

    Analyze event logs, clickstreams, user paths, product funnels, retention, behavioral segments, transition graphs, step matrices, sequence patterns, and customer journeys using Retentioneering.

    925 GitHub stars~1.6k tokensUpdated yesterday
    Data & AnalyticsAuto-check passed
  • Senior Data Scientist

    Raidriar7170/hermes-skilleval

    World-class data science skill for statistical modeling, experimentation, causal inference, and advanced analytics.

    125 GitHub starsUsed in 5 repos~1.4k tokens
    Data & AnalyticsAuto-check passed

More from phuryn/pm-skills

All 67 skills in this repo
  • Reviews a diff by anchoring on agreements between two sides of a boundary, forcing a concrete violating execution, and refuting each finding before reporting it.

    27k GitHub stars~3.6k tokensUpdated 24 days ago
    Auto-check passed
  • A/B Test Analysis

    phuryn/pm-skills

    Validates an experiment's setup, works out lift, p-value and confidence interval from A/B test data, and recommends whether to ship, extend or stop.

    27k GitHub stars~893 tokensUpdated 24 days ago
    Auto-check passed
  • Team OKR Brainstorm

    phuryn/pm-skills

    Drafts three alternative sets of team OKRs, each with an inspiring objective and measurable key results, tied to the company strategy you provide.

    27k GitHub stars~1.1k tokensUpdated 24 days ago
    Auto-check passed
  • Dummy Dataset Generator

    phuryn/pm-skills

    Generates realistic test datasets with custom columns, row counts and business constraints, output as CSV, JSON, SQL inserts or a runnable Python script.

    27k GitHub stars~983 tokensUpdated 24 days ago
    Auto-check passed
  • Grammar and Flow Checker

    phuryn/pm-skills

    Reviews a draft for grammar, logic and flow problems and returns located, prioritized fix suggestions without rewriting the whole text.

    27k GitHub stars~2.4k tokensUpdated 24 days ago
    Auto-check passed
  • Builds a structured customer interview script with opening, warm-up, jobs-to-be-done exploration and wrap-up sections, following Mom Test rules against leading questions.

    27k GitHub stars~1.2k tokensUpdated 24 days ago
    Auto-check passed

Works with

Questions about Cohort Analysis and Retention Explorer

What does Cohort Analysis and Retention Explorer do?

Analyzes uploaded cohort data to compute retention curves and feature adoption trends, builds heatmaps and charts, and suggests qualitative follow-up research. Starting from a CSV, Excel or JSON file, the skill first checks the data structure for a cohort identifier, time periods and engagement metrics, flags missing values, and summarizes cohort sizes and date ranges before any analysis runs. It then calculates retention rates, drop-off patterns, feature adoption rates across cohorts, and period-over-period changes, optionally generating pandas and numpy scripts when the user wants runnable code.

When should I use Cohort Analysis and Retention Explorer?

Cohort Analysis and Retention Explorer fits situations like: understanding retention differences across user cohorts; comparing feature adoption curves between groups of users; turning a retention pattern into a concrete follow-up research plan.

How do I install Cohort Analysis and Retention Explorer in Claude Code?

Run `npx skills add phuryn/pm-skills --skill cohort-analysis -a claude-code`. Or copy the skill folder (pm-data-analytics/skills/cohort-analysis in phuryn/pm-skills) into .claude/skills/cohort-analysis in your project. Claude Code loads it when a task matches its description.

How do I install Cohort Analysis and Retention Explorer in Codex?

Run `npx skills add phuryn/pm-skills --skill cohort-analysis -a codex`. Or copy the skill folder (pm-data-analytics/skills/cohort-analysis in phuryn/pm-skills) into .agents/skills/cohort-analysis in your project. Codex loads it when a task matches its description.

Can I use Cohort Analysis and Retention Explorer in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add phuryn/pm-skills --skill cohort-analysis -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/cohort-analysis, .gemini/skills/cohort-analysis, .github/skills/cohort-analysis and .opencode/skills/cohort-analysis in your project.

What does Cohort Analysis and Retention Explorer need to run?

SKILL.md names no scripts, command-line tools or credentials: Cohort Analysis and Retention Explorer is instructions for the agent only. Our summary lists: A cohort data file in CSV, Excel or JSON format.

Does Cohort Analysis and Retention Explorer access the network?

SKILL.md names 1 domain. As links in the text: productcompass.pm. This is read from the text; nothing was executed.

Is Cohort Analysis and Retention Explorer safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Cohort Analysis and Retention Explorer use?

Cohort Analysis and Retention Explorer is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Cohort Analysis and Retention Explorer use?

About 1.3k tokens (SKILL.md is roughly 5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Cohort Analysis and Retention Explorer?

Skills that share tags, products or a category with Cohort Analysis and Retention Explorer: Python Executor (cortega26/chile-hub, 113 stars), Vaex Out-of-Core DataFrames (davila7/claude-code-templates, 32k stars), Release Evidence Workflow (Ali-Marandi/ClimateDataAnalyzer, 107 stars) and Seaborn (zLanqing/codex-claude-academic-skills, 4.7k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Cohort Analysis and Retention Explorer?

phuryn (a GitHub user) maintains it in phuryn/pm-skills, which has 26,845 GitHub stars. The repository holds 67 skills in this directory. The repository was last updated on September 14, 2026.

Source: phuryn/pm-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.