This handles cohort analysis for tracking user groups over time, focusing on retention, churn, and lifetime value metrics. You'd reach for it when comparing acquisition channels, measuring how product changes affect different user segments, or spotting early churn signals. It's part of aj-geddes's useful-ai-prompts collection, which has solid traction at 245 stars and passes all security audits. The skill covers the standard cohort playbook: retention curves, LTV calculations, and cohort comparison tables. It's straightforward analysis work, nothing fancy, but that's exactly what you need when stakeholders want to know which user groups are sticking around and why.

GitHub stars
317
last updated
Aug 21, 2026

Install

$ npx -y skills add aj-geddes/useful-ai-prompts --skill 'Cohort Analysis' --agent claude-code

Installs into .claude/skills of the current project.

Files

Cohort Analysis

Overview

Cohort analysis tracks groups of users with shared characteristics over time, revealing patterns in retention, engagement, and lifetime value.

When to Use

  • Measuring user retention rates and identifying when users churn
  • Analyzing customer lifetime value (LTV) and payback periods
  • Comparing performance across different user acquisition channels or campaigns
  • Understanding how product changes affect different user groups over time
  • Tracking engagement patterns and identifying early warning signs of churn
  • Evaluating the long-term impact of onboarding improvements or feature releases

Core Concepts

  • Cohort: Group of users sharing a characteristic (signup date, region, etc.)
  • Cohort Size: Initial group size
  • Retention Rate: Percentage remaining active
  • Churn Rate: Percentage who left
  • Retention Curve: How cohort degrades over time

Cohort Types

  • Acquisition Date: Users grouped by signup period
  • Behavioral: Users grouped by actions taken
  • Revenue: Users grouped by purchase value
  • Geographic: Users grouped by location
  • Demographic: Users grouped by characteristics

Sponsors

Details

Repository
github.com/aj-geddes/useful-ai-prompts
Category
AI & Agent Building
First seen
Jun 3, 2026

More from aj-geddes/useful-ai-prompts

All 258
1aj-geddes avatarDimensionality Reductionaj-geddes/useful-ai-promptsReduce feature dimensionality using PCA, t-SNE, and feature selection for feature reduction, visualization, and computational efficiency0skills.sh installs
2aj-geddes avatarFeature Engineeringaj-geddes/useful-ai-promptsCreate and transform features using encoding, scaling, polynomial features, and domain-specific transformations for improved model performance and interpretabil0skills.sh installs
3aj-geddes avatarFunnel Analysisaj-geddes/useful-ai-promptsAnalyze user conversion funnels, identify drop-off points, and optimize conversion rates for conversion optimization and user flow analysis0skills.sh installs
4aj-geddes avatarML Model Trainingaj-geddes/useful-ai-promptsBuild and train machine learning models using scikit-learn, PyTorch, and TensorFlow for classification, regression, and clustering tasks0skills.sh installs
5aj-geddes avatarModel Hyperparameter Tuningaj-geddes/useful-ai-promptsOptimize hyperparameters using grid search, random search, Bayesian optimization, and automated ML frameworks like Optuna and Hyperopt0skills.sh installs
6aj-geddes avatarNetwork Analysisaj-geddes/useful-ai-promptsAnalyze network structures, identify communities, measure centrality, and visualize relationships for social networks and organizational structures0skills.sh installs