cohort-analysis

name	cohort-analysis
displayName	Cohort Analysis
tagline	Analyze user retention and behavior patterns across cohorts defined by signup date or attributes.
description	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.
department	["Product","Data & Analytics","Growth"]
use_cases	["Retention Analysis","User Behavior","Growth Analytics"]
tools_required	["Mixpanel MCP","PostgreSQL MCP"]
agents_compatible	["Claude / Claude Code","Cursor","Windsurf","ChatGPT","Any MCP-compatible agent"]
author	Webrix
verified	true
updatedAt	"2026-05-08T00:00:00.000Z"
version	1.0.0
exampleInput	Run a weekly retention cohort analysis for the last 3 months. Show retention through week 8. Break down by plan type.
exampleOutput	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

Cohort Analysis

Analyze user retention and behavior patterns across cohorts defined by signup date or attributes.

Integrations: Mixpanel, PostgreSQL

When to Use

• The user wants to understand retention trends over time
• Different user segments need retention comparison
• The user mentions "cohort analysis", "retention", or "user behavior over time"

Steps

Step 1: Define Cohorts

Group users by signup date, plan, or acquisition channel.

Step 2: Track Retention

Calculate return rates for each cohort over time periods.

Step 3: Compare Segments

Identify which cohorts perform best and why.

Step 4: Extract Insights

Find actionable patterns that drive retention.

Output

Deliver:

• Cohort retention table
• Segment comparison analysis
• Key insights and recommendations