PostHog CLI Queries
debugtheworldbot/keyStats
Runs HogQL queries against this project's PostHog data from the terminal using posthog-cli, with bundled scripts for dashboard metadata the CLI itself has no command for.
Time-based cohort analysis with retention and behaviour tracking.
Install Cohort Analysis
$ npx skills add nimrodfisher/data-analytics-skills --skill cohort-analysis -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install nimrodfisher/data-analytics-skills cohort-analysis --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/03-data-analysis-investigation/cohort-analysis .claude/skills/cohort-analysis && rm -rf skills-srcUse ~/.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/
Install the "cohort-analysis" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/03-data-analysis-investigation/cohort-analysis into .claude/skills/cohort-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cohort-analysis", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/nimrodfisher/data-analytics-skills/tree/main/03-data-analysis-investigation/cohort-analysisType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add nimrodfisher/data-analytics-skills --skill cohort-analysis -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install nimrodfisher/data-analytics-skills cohort-analysis --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/03-data-analysis-investigation/cohort-analysis .agents/skills/cohort-analysis && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "cohort-analysis" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/03-data-analysis-investigation/cohort-analysis into .agents/skills/cohort-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cohort-analysis", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add nimrodfisher/data-analytics-skills --skill cohort-analysis -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install nimrodfisher/data-analytics-skills cohort-analysis --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/03-data-analysis-investigation/cohort-analysis .cursor/skills/cohort-analysis && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "cohort-analysis" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/03-data-analysis-investigation/cohort-analysis into .cursor/skills/cohort-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cohort-analysis", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/nimrodfisher/data-analytics-skills.git --path 03-data-analysis-investigation/cohort-analysis--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add nimrodfisher/data-analytics-skills --skill cohort-analysis -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install nimrodfisher/data-analytics-skills cohort-analysis --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/03-data-analysis-investigation/cohort-analysis .gemini/skills/cohort-analysis && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "cohort-analysis" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/03-data-analysis-investigation/cohort-analysis into .gemini/skills/cohort-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cohort-analysis", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install nimrodfisher/data-analytics-skills cohort-analysisInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add nimrodfisher/data-analytics-skills --skill cohort-analysis -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/03-data-analysis-investigation/cohort-analysis .github/skills/cohort-analysis && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "cohort-analysis" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/03-data-analysis-investigation/cohort-analysis into .github/skills/cohort-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cohort-analysis", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add nimrodfisher/data-analytics-skills --skill cohort-analysis -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install nimrodfisher/data-analytics-skills cohort-analysis --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/03-data-analysis-investigation/cohort-analysis .opencode/skills/cohort-analysis && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "cohort-analysis" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/03-data-analysis-investigation/cohort-analysis into .opencode/skills/cohort-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cohort-analysis", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
cohort-analysis- GitHub stars
- 470
- Token cost
- ~660 tokens
- SKILL.md length
- 295 words
- Files
- 9 (incl. scripts, references, assets)
- Skills in repo
- 31
- Repo updated
- First seen
- Licence
- MIT
At a glance
Time-based cohort analysis with retention and behaviour tracking.
- Works in 7 steps: Define the cohort and activity —… → Pull or build the data — if starting… → Build the cohort table — run… → …
- Tasks that involve Product analytics
- Runs Python scripts from its folder
What it does
Cohort Analysis is an agent skill from nimrodfisher/data-analytics-skills. Time-based cohort analysis with retention and behaviour tracking. Activate when you need to measure how groups of users/customers behave over time — retention rates, revenue by cohort, or feature adoption curves.
Its SKILL.md is about 660 tokens, which your agent loads only when the skill is triggered. The skill folder holds 11 other files, including scripts, reference files and assets (for example `assets/cohort_report_template.md`, `references/cohort_definition_patterns.md` and `references/retention_metrics_glossary.md`).
It sits in Data & Analytics, covering Product analytics. The repository describes itself as: A comprehensive list of Claude & Codex skills for a wide range of data analytics tasks. The licence is MIT.
When your agent uses it
- Tasks that involve Product analytics
Example prompts
- “/cohort-analysis”
Requirements
- Python 3
Workflow steps
7 steps, taken from the first numbered list in SKILL.md.
- Define the cohort and activity — clarify: cohort grouping (signup month, first purchase date, etc.) and retention event (login, purchase…
- Pull or build the data — if starting from a database, use scripts/cohort_query.sql as the starting point. Adapt the cohort_date and…
- Build the cohort table — run scripts/cohort_builder.py to produce a cohort × period membership table from event data. Output is a CSV with…
- Compute the retention matrix — run scripts/retention_matrix.py on the cohort table to generate the period-over-period retention rates…
- Visualise — run scripts/cohort_visualizer.py to render a heatmap of the retention matrix and a time-series of retention curves per cohort.
- Interpret findings — consult references/retention_metrics_glossary.md for metric definitions and references/cohort_definition_patterns.md…
- Write the report — fill assets/cohort_report_template.md. For a visual deliverable, fill in the assets/retention_matrix.html heatmap…
What it can do on your machine
Read from SKILL.md and the folder at commit 9449d36. 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
Ships 4 files in scripts/ (Python), which the agent can run.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
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 loads about 660 tokens when it runs, and up to ~2.8k if it reads all its reference files. Until then it costs about 57 tokens; SKILL.md has 295 words of instructions outside code blocks.
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); the scripts in this folder are not scanned.
SKILL.md
The full file from nimrodfisher/data-analytics-skills at commit 9449d36, republished under its MIT licence (© nimrodfisher). 295 words, ~660 tokens.
Download SKILL.mdSave it as
.claude/skills/cohort-analysis/SKILL.md (or your agent's skills folder). This skill also uses 8 other files; get the full folder from GitHub.- name
- cohort-analysis
- description
- Time-based cohort analysis with retention and behaviour tracking. Activate when you need to measure how groups of users/customers behave over time — retention rates, revenue by cohort, or feature adoption curves.
When to use
- A stakeholder asks "are we retaining users better than last quarter?"
- You need to measure N-day, weekly, or monthly retention for a product or feature
- You want to compare how different acquisition cohorts (by channel, plan, or signup date) perform over their lifetime
- You're investigating churn and need to identify at which period users typically leave
Process
- Define the cohort and activity — clarify: cohort grouping (signup month, first purchase date, etc.) and retention event (login, purchase, feature use). Document in the report header.
- Pull or build the data — if starting from a database, use
scripts/cohort_query.sqlas the starting point. Adapt thecohort_dateandactivity_datecolumns to your schema. - Build the cohort table — run
scripts/cohort_builder.pyto produce a cohort × period membership table from event data. Output is a CSV withuser_id,cohort_period,activity_period. - Compute the retention matrix — run
scripts/retention_matrix.pyon the cohort table to generate the period-over-period retention rates. Output is an N×M matrix (cohort × period). - Visualise — run
scripts/cohort_visualizer.pyto render a heatmap of the retention matrix and a time-series of retention curves per cohort. - Interpret findings — consult
references/retention_metrics_glossary.mdfor metric definitions andreferences/cohort_definition_patterns.mdfor pattern recognition. - Write the report — fill
assets/cohort_report_template.md. For a visual deliverable, fill in theassets/retention_matrix.htmlheatmap template.
Inputs the skill needs
- Required: event data with
user_id,cohort_date(e.g.signup_date),activity_date - Required: cohort grouping granularity (daily / weekly / monthly)
- Required: retention event definition — what counts as "active" or "retained"?
- Optional: minimum cohort size (recommend ≥ 100 users; smaller cohorts have noisy rates)
- Optional: number of periods to track (e.g. 12 months)
- Optional: cohort attributes to segment by (acquisition channel, plan tier, geography)
Output
assets/cohort_report_template.md(filled) — narrative interpretation and retention figuresassets/retention_matrix.html(filled) — colour-coded retention heatmapscripts/retention_matrix.pyoutput CSV — raw retention rates for downstream use
© nimrodfisher, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 8 other files (scripts, references, assets) in 03-data-analysis-investigation/cohort-analysis of nimrodfisher/data-analytics-skills.
- SKILL.md
- assets/cohort_report_template.md
- assets/retention_matrix.html
- references/cohort_definition_patterns.md
- references/retention_metrics_glossary.md
- scripts/cohort_builder.py
- scripts/cohort_query.sql
- scripts/cohort_visualizer.py
- scripts/retention_matrix.py
Open the folder on GitHubat commit 9449d36
Compare with similar skills
Cohort Analysis 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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Cohort Analysis this skillnimrodfisher/data-analytics-skills | 470 | — | ~660 | Automated safety check: Pass | MIT | |
| PostHog CLI Queriesdebugtheworldbot/keyStats | 1.5k | — | ~1.2k | Automated safety check: Pass | MIT | |
| Retentioneering Contributingretentioneering/retentioneering-tools | 927 | — | ~1.8k | Automated safety check: Pass | Apache-2.0 | |
| Retentioneering Product Analyticsretentioneering/retentioneering-tools | 927 | — | ~1.6k | Automated safety check: Pass | Apache-2.0 | |
| Feature Analytics Instrumentation Plannermistralai/mistral-vibe | 5.1k | — | ~2.2k | Automated safety check: Pass | Apache-2.0 | |
| Funnel Analysisliangdabiao/claude-data-analysis-ultra-main | 290 | 1 repos | ~781 | Automated safety check: Notes | None |
Similar skills
Retentioneering Contributing
retentioneering/retentioneering-tools
Help the user turn their Retentioneering ideas, friction reports, bug findings, or feature needs into high-quality upstream contributions: from capturing and validating the idea, through minimal…
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.
- Official
Feature Analytics Instrumentation Planner
mistralai/mistral-vibe
Plans which analytics events and properties a new feature needs, checks them against the existing event registry, and verifies them per environment.
Funnel Analysis
liangdabiao/claude-data-analysis-ultra-main
Analyze user conversion funnels, calculate step-by-step conversion rates, create interactive visualizations, and identify optimization opportunities.
Event Tracking
linuxfoundation/insights
Add event tracking calls to Vue/Nuxt components in the Insights app using the useTrackEvent composable.
More from nimrodfisher/data-analytics-skills
All 31 skills in this repoAb Test Analysis
nimrodfisher/data-analytics-skills
Rigorous A/B test statistical analysis. An agent skill from nimrodfisher/data-analytics-skills.
Analysis Assumptions Log
nimrodfisher/data-analytics-skills
Track and document analytical assumptions and decisions. An agent skill from nimrodfisher/data-analytics-skills.
Analysis QA Checklist
nimrodfisher/data-analytics-skills
Pre-delivery quality assurance for analysis work. An agent skill from nimrodfisher/data-analytics-skills.
Business Metrics Calculator
nimrodfisher/data-analytics-skills
Standard business metric calculation with industry benchmarks.
Context Packager
nimrodfisher/data-analytics-skills
Efficiently package context for AI-assisted analysis. An agent skill from nimrodfisher/data-analytics-skills.
Data Catalog Entry
nimrodfisher/data-analytics-skills
Create standardized metadata for data assets. An agent skill from nimrodfisher/data-analytics-skills.
Related
Categories
Questions about Cohort Analysis
What does Cohort Analysis do?
Time-based cohort analysis with retention and behaviour tracking. Cohort Analysis is an agent skill from nimrodfisher/data-analytics-skills. Time-based cohort analysis with retention and behaviour tracking.
When should I use Cohort Analysis?
Cohort Analysis fits situations like: tasks that involve Product analytics.
How do I install Cohort Analysis in Claude Code?
Run `npx skills add nimrodfisher/data-analytics-skills --skill cohort-analysis -a claude-code`. Or copy the skill folder (03-data-analysis-investigation/cohort-analysis in nimrodfisher/data-analytics-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 in Codex?
Run `npx skills add nimrodfisher/data-analytics-skills --skill cohort-analysis -a codex`. Or copy the skill folder (03-data-analysis-investigation/cohort-analysis in nimrodfisher/data-analytics-skills) into .agents/skills/cohort-analysis in your project. Codex loads it when a task matches its description.
Can I use Cohort Analysis 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 nimrodfisher/data-analytics-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 need to run?
Going by SKILL.md and its folder, Cohort Analysis needs Python for the scripts in its folder. Our summary lists: Python 3.
Does Cohort Analysis access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Cohort Analysis 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. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.
What licence does Cohort Analysis use?
Cohort Analysis 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 use?
About 660 tokens (SKILL.md is roughly 2.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 2.1k tokens, read only when the agent opens those files.
What are the alternatives to Cohort Analysis?
Skills that share tags, products or a category with Cohort Analysis: PostHog CLI Queries (debugtheworldbot/keyStats, 1.5k stars), Retentioneering Contributing (retentioneering/retentioneering-tools, 927 stars), Retentioneering Product Analytics (retentioneering/retentioneering-tools, 927 stars) and Feature Analytics Instrumentation Planner (mistralai/mistral-vibe, 5.1k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Cohort Analysis?
nimrodfisher (a GitHub user) maintains it in nimrodfisher/data-analytics-skills, which has 470 GitHub stars. The repository holds 31 skills in this directory. The repository was last updated on September 25, 2026.
Source: nimrodfisher/data-analytics-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.