Skip to content
cccskills
FreePublished on GitHub

cohort-analysis

Analyze user retention by cohort. Use when: measuring customer retention; understanding lifecycle patterns; comparing acquisition cohorts; tracking engagement over time; identifying churn risks

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150 stars(GitHub 150 + cccskills 0)

Run score Not tested

See how to install

Files included (3)

  • SKILL.md3.4 KB
  • scripts/main.py10.2 KB
  • scripts/requirements.txt73 B

SKILL.md (original)

Review the instructions the agent will receive before you install.

Cohort Analysis

Analyze retention and behavior patterns by grouping users into cohorts - understand how different customer groups behave over time.

When to Use This Skill

  • Retention tracking - Measure how users stick around over time
  • Acquisition analysis - Compare cohorts from different channels
  • Product changes - Measure impact on user behavior
  • Churn prediction - Identify at-risk cohorts
  • LTV estimation - Project customer lifetime value

What Claude Does vs What You Decide

Claude DoesYou Decide
Structures analysis frameworksMetric definitions
Identifies patterns in dataBusiness interpretation
Creates visualization templatesDashboard design
Suggests optimization areasAction priorities
Calculates statistical measuresDecision thresholds

Dependencies

pip install pandas plotly click

Commands

Retention Analysis

python scripts/main.py retention data.csv --date-col signup --event-col purchase
python scripts/main.py retention data.csv --date-col signup --periods week

Visualize Cohorts

python scripts/main.py visualize cohorts.csv --output retention_chart.html

Export Report

python scripts/main.py report data.csv --date-col signup --event-col active --output report.html

Examples

Example 1: Analyze User Retention

python scripts/main.py retention users.csv --date-col signup_date --event-col last_active

# Output:
# Cohort Retention Analysis
# ──────────────────────────────────
# Cohort     Users    M1     M2     M3     M4
# Jan 2024   1,234    65%    48%    42%    38%
# Feb 2024   1,456    62%    45%    41%    --
# Mar 2024   1,321    68%    52%    --     --
# Apr 2024   1,567    64%    --     --     --
#
# Avg Retention: 65% → 48% → 42% → 38%
# Best Cohort: Mar 2024 (68% M1)

Example 2: Generate Visual Report

python scripts/main.py report transactions.csv \
  --date-col signup \
  --event-col purchase_date \
  --output retention_report.html

# Generates interactive HTML with:
# - Retention heatmap
# - Cohort size chart
# - Trend analysis

Cohort Table Format

CohortSizePeriod 0Period 1Period 2Period 3
2024-011234100%65%48%42%
2024-021456100%62%45%-
2024-031321100%68%--

Skill Boundaries

What This Skill Does Well

  • Structuring data analysis
  • Identifying patterns and trends
  • Creating visualization frameworks
  • Calculating statistical measures

What This Skill Cannot Do

  • Access your actual data
  • Replace statistical expertise
  • Make business decisions
  • Guarantee prediction accuracy

Related Skills

Skill Metadata

  • Mode: centaur
category: analytics
subcategory: retention
dependencies: [pandas, plotly]
difficulty: intermediate
time_saved: 4+ hours/week

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Measure and optimize growth using the AARRR (Pirate Metrics) framework with stage-specific KPIs and funnel analysis

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

Calculate A/B test statistical significance. Use when: determining if test results are significant; calculating required sample size; estimating test duration; analyzing conversion experiments; making data-driven decisions

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

Assess customer account health using product usage, support sentiment, payment status, and relationship signals

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

Analyze paid advertising performance across channels and recommend budget reallocation to maximize ROAS and minimize CAC. Use when: planning quarterly ad budget allocation, diagnosing underperforming ad channels, deciding whether to scale spend on a channel, calculating marginal ROI across Google Ads, Meta, LinkedIn, or TikTok, rebalancing media mix after performance shifts, or setting up a test-and-scale framework for new channels.

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

Use when testing skills, commands, or agents for quality. Use after creating new skills, before deploying agents, or when debugging inconsistent agent behavior. Triggers on "evaluate", "test quality", "is this skill working", or QA of AI workflows.

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

Use when analyzing server logs to understand how AI crawlers (GPTBot, ClaudeBot, PerplexityBot) interact with your site. Use when optimizing content placement for LLM retrieval, diagnosing why AI search isn't citing your content, or auditing crawl patterns to find optimization gaps.

The English summary is being prepared. Showing the original description.

guia-matthieu/clawfu-skills150Updated Oct 1, 2026

See all skills by guia-matthieu

Report a problem with this skill