Cohort Analysis

Updated May 27, 2026

What this skill does

Performs cohort analysis to understand user retention, engagement, and revenue patterns over time. Groups users by signup date, acquisition channel, or plan type and tracks how their behavior changes week over week. Identifies which cohorts retain best and what drives long-term engagement.

Example

PROMPT

Run a weekly retention cohort analysis for the last 3 months. Show retention through week 8. Break down by plan type.

OUTPUT

Cohort Retention — Last 3 Months WEEKLY RETENTION (% returning) W1 W2 W3 W4 W5 W6 W7 W8 Feb: 72% 58% 48% 42% 38% 35% 33% 31% Mar: 75% 61% 52% 45% 41% 38% — — Apr: 78% 64% 55% — — — — — TREND: Improving (+3% W1 retention month over month) BY PLAN TYPE Pro Plan: W4 retention: 62% (best performing) Team Plan: W4 retention: 48% Free Plan: W4 retention: 28% KEY INSIGHTS - Pro plan users retain 2.2x better than free users - Users who complete onboarding in Day 1 have 45% higher W4 retention - Referral cohorts retain 18% better than paid acquisition

Required Tools

Mixpanel

PostgreSQL

Compatible Agents

Claude

Cursor

Windsurf

ChatGPT

Any MCP-compatible agent

Add to your agent

Download Skill

Or install via CLI:
$ npx skills add webrix-ai/agent-skills --skill cohort-analysis

Deploy Org-wide

Provision to teams via RBAC

Identity-aware execution

Signed & verified skills

Full audit trail

Auto-bundled with required MCP servers

Use with

Free for up to 5 users

Related Skills

A/B Testing

Helps design statistically rigorous A/B tests for marketing campaigns, landing pages, and product features. Calculates required sample sizes, defines success metrics, sets up test variants, and analyzes results with confidence intervals. Prevents common testing mistakes like peeking and underpowered tests.

AI Adoption Dashboard Builder

Creates a multi-tab analytics dashboard for tracking AI tool adoption across your engineering organization. Includes executive KPIs, team-level adoption curves, per-tool usage breakdowns, productivity impact comparisons, and cost tracking. Optionally generates a Grafana dashboard JSON for real-time monitoring.

AI Adoption Readiness Assessment

A structured assessment framework that scores your organization across five critical dimensions of AI readiness. Produces an actionable scorecard with prioritized recommendations, a detailed gap analysis spreadsheet, and optional Jira tickets to track remediation efforts.

AI Champion Onboarding Kit

Creates a complete onboarding package for department-level AI champions who will drive adoption within their teams. Includes a modular training curriculum (AI fundamentals, tool-specific training, change management, security), a week-by-week rollout playbook, success metrics with targets, and ready-to-use templates for workshops, surveys, and team communications.

Your agents are already in the wild.

Give them a Basecamp. Go from AI chaos to AI work, in minutes.

Get Started

See a Demo