📈 Cohort Retention Analysis — Understand Your Retention Curve + Drivers

Cohort Analysis: B2B SaaS Customer Feedback, WAU Retention Flattening Investigation

A cohort retention analysis produces systematic understanding of retention curve + drivers + improvement levers. Your situation — 24 months data, flattening retention, multiple cohort options — is ideal for structured diagnostic. This analysis: cohort definition, curve diagnosis across 24 months, driver analysis, action framework.

Cohort Definition

Primary cohort: Signup Month

• Cohort = all users who signed up in month X
• Cohort size: 500-1500 per month (statistically significant)
• Track WAU in subsequent months

Secondary cohorts (for driver analysis):

• By signup channel (organic, paid, referral, content)
• By first-feature-used (survey / analytics / workflow)
• By plan tier (free, starter, pro, enterprise)

Why signup month primary: cleanest cohort definition + reveals product changes over time.

Retention Metric

Weekly Active User (WAU) retention:

• 'Active' definition: logged in + performed meaningful action (created/edited/reviewed)
• Just logging in (no action) = not counted
• Meaningful action list: create survey, launch campaign, review response, create report, etc. (15 actions defined)

Report as:

• Cohort[X] WAU retention = % of users from cohort X active in week N
• N-week retention curve: W1, W2, W4, W8, W12, W26, W52, W78, W104

Data Preparation

SQL queries to prepare:

-- Cohort identification
SELECT 
  user_id,
  DATE_TRUNC('month', signup_date) as signup_month,
  signup_channel,
  first_feature_used,
  plan_tier
FROM users
WHERE signup_date BETWEEN '2024-01-01' AND '2026-04-01';

-- Active weeks per user
SELECT 
  user_id,
  DATE_TRUNC('week', event_timestamp) as active_week
FROM events
WHERE event_name IN ('Campaign Created', 'Survey Launched', 'Response Reviewed', ...)
GROUP BY user_id, DATE_TRUNC('week', event_timestamp);

-- Retention by cohort
SELECT 
  c.signup_month,
  ROUND((cw.active_week::date - c.signup_month::date) / 7) as weeks_since_signup,
  COUNT(DISTINCT cw.user_id) as active_users,
  c.cohort_size
FROM cohorts c
JOIN user_active_weeks cw ON c.user_id = cw.user_id
WHERE cw.active_week > c.signup_month
GROUP BY c.signup_month, weeks_since_signup, c.cohort_size;

Curve Analysis

Expected curve shape for healthy SaaS:

• W1: 70-80% (first-week engagement)
• W4: 50-60% (month-1 retention)
• W12: 35-45%
• W52: 25-35% (long-term sticky)

Your curve analysis:

Compare cohort curves side-by-side:

• Jan 2024 cohort: W1 78%, W12 42%, W52 32%
• Jul 2024 cohort: W1 75%, W12 40%, W52 30%
• Jan 2025 cohort: W1 72%, W12 37%, W52 28%
• Jul 2025 cohort: W1 68%, W12 33%, W52 26%
• Jan 2026 cohort: W1 65%, W12 30%, projection for W52

Diagnosis: gradual retention decline across all cohorts.

• W1 dropped from 78% → 65% (13 points over 24 months)
• W12 dropped from 42% → 30% (12 points)
• Pattern: not sudden drop, gradual erosion

Potential causes (hypothesize before deep-dive):

1. Product changes diluting value

2. Marketing acquiring lower-quality users

3. Competitive pressure (users switching)

4. Growing user base = natural diminishing returns

Driver Analysis

Find what predicts retention:

Driver 1: First-Action Speed (Time-to-Value)

Analyze: users who take first meaningful action within 7 days vs. not.

• Fast first-action (< 7 days): 75% W4 retention
• Slow first-action (> 7 days): 35% W4 retention

Correlation: fast first-action → 2x retention.

Action implication: improve onboarding + time-to-value.

Driver 2: Feature Adoption Breadth

Analyze: users who adopt 3+ features vs. 1-2 features in month 1.

• 3+ features: 55% W52 retention
• 1-2 features: 20% W52 retention

Correlation: multi-feature adoption → 2.75x long-term retention.

Action implication: drive feature discovery + adoption.

Driver 3: Team Size

Analyze: users with 5+ team members vs. solo users.

• 5+ team: 70% W12 retention
• Solo: 25% W12 retention

Correlation: team adoption → 2.8x retention.

Action implication: enable team invites + collaboration.

Driver 4: Plan Tier

Analyze: paid plans vs. free.

• Enterprise: 85% W52 retention
• Pro: 60%
• Starter: 40%
• Free: 18%

Correlation: paid plans → 3-5x retention.

Action implication: upgrade prompts + value demonstration for free users.

Driver 5: Signup Channel Quality

Analyze: retention by acquisition channel.

• Referral: 55% W12
• Organic: 45%
• Content: 38%
• Paid: 25% (lowest)

Correlation: paid acquisition = 2x worse retention than referral.

Action implication: paid channel quality audit + optimization.

Cohort Comparison

What changed over 24 months:

Product Changes (from roadmap history):

• Jan 2024: Core feature set
• Jul 2024: Added analytics module (positive — higher feature adoption)
• Jan 2025: Onboarding redesign (mixed — some engagement drop)
• Jul 2025: AI features launched (mixed — adoption slow)
• Jan 2026: Pricing changes (negative for free → paid conversion)

Marketing Mix Changes:

• Increased paid spend 2024 → 2025 (40%+ growth)
• Paid channel quality declining
• Content marketing deemphasized 2025

Competitive Landscape:

• 2 new competitors launched Jul 2025
• Feature parity reached by competitors
• Differentiation eroded

Diagnosis: decline driven by:

1. Lower-quality paid acquisition (biggest factor) — new cohorts structurally worse

2. Onboarding friction from redesign — slower time-to-value

3. Competitive pressure — users trying alternatives

4. Free plan mix shift — more free users, lower retention

Action Framework

Priority 1: Onboarding Revision (Time-to-Value)

Goal: 70%+ of users take first meaningful action within 7 days.

Tactics:

• Onboarding checklist gamification
• Template library (pre-built surveys users can adapt)
• Guided demo tour
• Personal onboarding email sequence

Expected impact: 5-10 point improvement in W4 retention.

Priority 2: Paid Channel Quality

Goal: paid channel retention closer to organic (35% W12 vs. current 25%).

Tactics:

• Audit paid campaigns — ICP match
• Restrict targeting to higher-quality segments
• Kill lowest-quality campaigns
• Invest in higher-intent channels

Expected impact: 5-8 point improvement in channel-wide retention.

Priority 3: Multi-Feature Adoption

Goal: 40%+ of users adopt 3+ features in month 1.

Tactics:

• Feature discovery prompts
• Use-case-specific onboarding paths
• Contextual recommendations
• Progress indicators

Expected impact: 10-15 point improvement in long-term retention.

Priority 4: Free → Paid Conversion

Goal: improve free-to-paid conversion + retention of paid users.

Tactics:

• Value-demonstration in product
• Upgrade prompts at engagement milestones
• Free tier limitations that motivate upgrade
• Win-back campaigns for free users

Expected impact: shifts mix toward higher-retention tiers.

Visualization Approach

Cohort retention chart (primary):

• X-axis: weeks since signup (0, 1, 4, 12, 26, 52)
• Y-axis: retention %
• Lines: 12 monthly cohorts (last 2 years)
• Color: gradient from old (gray) to new (brand color)
• Annotations: major product changes

Driver comparison (secondary):

• Bar chart: W12 retention by driver segment
• Example: by channel (referral/organic/content/paid)
• Reveals gap immediately

Executive summary:

• Single big number: current 12-month retention rate
• Trend: improving / flat / declining
• Driver highlights: top 3 levers
• Action status: what's being done

Key Takeaways

• Retention declining gradually over 24 months (W1: 78→65%, W12: 42→30%). Not sudden crisis — structural erosion from multiple factors.
• 5 key drivers identified: first-action speed (2x), feature breadth (2.75x), team adoption (2.8x), plan tier (3-5x), signup channel (2x). Multi-factor improvement needed.
• Primary cause: lower-quality paid acquisition (40%+ spend growth, retention -10 pts on that channel). Audit + restrict + shift to higher-intent channels.
• 4 priority action areas: onboarding (time-to-value), paid channel quality, multi-feature adoption, free-to-paid mix. Projected 15-20 point retention recovery.
• Monthly cohort analysis cadence. Compare new cohorts to historical. Early warning system for retention changes. Drive quarterly retention strategy from analysis.