# Cohort retention analysis (/data--cohort-analysis)

/data--cohort-analysis is a Claude Code skill in the Data section. Builds runnable cohort retention SQL on your real schema, plus a guide to reading the retention triangle and spotting misleading patterns.

- Web version: https://skills.sgomez.dev/en/s/data--cohort-analysis
- Section: [Data](https://skills.sgomez.dev/en/data.md)
- Author: Santiago Gómez de la Torre
- License: MIT
- Source: https://github.com/sgomez-dev/claude-skills/blob/main/skills/data/cohort-analysis.md
- Updated 10 Jul 2026

## How to ask for it

- `/data--cohort-analysis build a cohort retention analysis of my users`
- `/data--cohort-analysis give me SQL to see monthly retention since signup`
- `/data--cohort-analysis explain how to interpret the cohort table you generate`

## Install

macOS · Linux:

```
curl -fsSL https://raw.githubusercontent.com/sgomez-dev/claude-skills/main/install.sh | bash
```

Windows:

```
irm https://raw.githubusercontent.com/sgomez-dev/claude-skills/main/install.ps1 | iex
```

Claude Code plugin:

```
/plugin marketplace add sgomez-dev/claude-skills
/plugin install data-skills@claude-skills-collection
```

## Permissions

- Reads: `**/*.sql`, `**/models/**`, `**/migrations/**`, `**/*.yml`, `**/schema*`, `**/*.prisma`, `**/*.py`
- Writes: `cohort_*.sql`, `cohort_*.md`
- Runs: —
- Network: No
- Destructive: No

## Author's description

Build a cohort retention analysis: runnable SQL plus an interpretation guide

- [How we review this](https://skills.sgomez.dev/en/methodology.md)