# Cohort Analysis

> Standard method for slicing bookings, pipeline, and retention cohorts for diagnostics.

- Skill: `majiayu000/cohort-analysis-2` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/cohort-analysis-2`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/cohort-analysis-2/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: DevOps & Infra
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/cohort-analysis-2

---


# Cohort Analysis Framework Skill

## When to Use
- Comparing performance across acquisition channels, segments, or product lines.
- Diagnosing conversion drop-offs within specific booking/vintage cohorts.
- Stress-testing forecast assumptions with historical baseline behavior.

## Framework
1. **Cohort Definition** – choose cohort key (signup month, lead source, product tier, segment).
2. **Metric Stack** – select KPIs (coverage, win rate, ACV, NRR, payback) per cohort.
3. **Normalization** – adjust for seasonality, deal size mix, or currency.
4. **Visualization** – waterfall tables, heatmaps, or overlapping curves to highlight divergence.
5. **Narrative Layer** – annotate drivers, anomalies, and recommended actions.

## Templates
- Cohort definition worksheet (keys, filters, inclusion/exclusion rules).
- Standardized chart pack for leadership readouts.
- Diagnostic checklist for follow-up analyses.

## Tips
- Keep cohorts mutually exclusive to avoid double-counting.
- Pair with `inspect-pipeline-levers` to link cohort insights to pipeline stages.
- Rebaseline quarterly so assumptions stay current.

---