cohort-analysis

Name: cohort-analysis
Author: indranilbanerjee

507stars91forks

How to install cohort-analysis?

indranilbanerjee/digital-marketing-pro/cohort-analysis

$npx -y skills add indranilbanerjee/digital-marketing-pro --skill cohort-analysis

Installs into the current project.

Summary

Analyze customer cohorts. Use when: acquisition cohorts, retention curves, LTV by cohort, behavioral segmentation.

Files · 1

View on GitHub

SKILL.md

1	# /digital-marketing-pro:cohort-analysis
2
3	## Purpose
4
5	Perform customer cohort analysis to understand lifecycle patterns, retention, and value over time. Segment customers into cohorts by acquisition date, channel, behavior, or value tier, then track retention curves, compare cohort performance, and identify which acquisition sources produce the highest-value customers. This analysis reveals whether the business is acquiring better or worse customers over time, which channels drive long-term value versus one-time transactions, and where lifecycle interventions (onboarding improvements, re-engagement campaigns, loyalty programs) would have the greatest impact on retention and revenue.
6
7	## Input Required
8
9	The user must provide (or will be prompted for):
10
11	- Cohort type: `time-based` (customers grouped by acquisition week, month, or quarter — the standard cohort analysis showing retention evolution over time), `channel-based` (customers grouped by acquisition source — paid search, organic, social, email, referral — revealing which channels produce the most durable customers), `behavioral` (customers grouped by first action taken — e.g., product category purchased, feature used, content consumed — identifying which entry points lead to highest retention), or `revenue-tier` (customers grouped by initial purchase value — low, medium, high, enterprise — showing how starting value correlates with lifetime retention and expansion)
12	- Time period and granularity: The analysis window and cohort size — weekly cohorts for the past 3 months (high resolution, best for fast-cycle businesses), monthly cohorts for the past 12 months (standard for most businesses), or quarterly cohorts for multi-year analysis (best for long-cycle B2B or subscription businesses). Granularity determines both how cohorts are defined and the retention interval measured
13	- Metrics to track: Which outcomes to measure across cohorts — `retention rate` (percentage of cohort still active at each interval), `revenue` (cumulative and per-period revenue per customer), `LTV` (cumulative lifetime value with projected future value), `engagement` (login frequency, feature usage, content consumption), or multiple metrics simultaneously for a comprehensive lifecycle view
14	- Data source: Where to pull customer data — `CRM` (deal data, customer records, lifecycle stages), `analytics` (website behavior, conversion events, session data), `product analytics` (feature usage, activation events, engagement metrics), or a combination of sources merged on customer identifier
15
16	## Process
17
18	1. Load brand context: Read `~/.claude-marketing/brands/_active-brand.json` for the active slug, then load `~/.claude-marketing/brands/{slug}/profile.json`. Extract business model (SaaS, eCommerce, B2B), typical customer lifecycle length, key retention metrics, and churn definition for the industry. Check for guidelines at `~/.claude-marketing/brands/{slug}/guidelines/_manifest.json`. If no brand exists, ask: "Set up a brand first (/digital-marketing-pro:brand-setup)?" — or proceed with defaults.
19	2. Define cohorts based on selected type: Segment the customer base into cohorts. For time-based: group customers by the week, month, or quarter they were first acquired (first purchase, account creation, or first meaningful interaction). For channel-based: group by the acquisition source attributed to their first conversion (UTM source, referral path, or CRM lead source field). For behavioral: group by the first significant action taken (first product category purchased, first feature activated, first content type consumed). For revenue-tier: group by initial transaction value bucketed into tiers (define thresholds based on the business's order value distribution — e.g., bottom 25%, middle 50%, top 25%).
20	3. Pull customer data from CRM and analytics MCPs: Gather the complete customer dataset — acquisition dates and source from CRM MCP, transaction history with timestamps and values, engagement events (logins, feature usage, email opens, site visits) from analytics MCPs, churn events (cancellation, last activity date, account closure), and any customer attributes needed for cohort segmentation. Merge data from multiple sources on customer identifier, resolving duplicates and filling gaps where possible.
21	4. Build retention matrix: For each cohort, calculate the retention rate at each subsequent time interval (Week 1, Week 2, Month 1, Month 2, etc. matching the selected granularity). Retention is defined as the percentage of the original cohort that performed a qualifying activity (purchase, login, engagement event — depending on the business model) during that interval. Present as a triangular matrix with cohorts as rows and time intervals as columns, with color-coded cells (green for above-average retention, re

People who liked this also viewed

6 picks

Type

azure-kustoQuery and analyze data in Azure Data Explorer (Kusto/ADX) using KQL for log analytics, telemetry, and time series analysis. WHEN: KQL queries, Kusto database queries, Azure Data Explorer, ADX clustersSkillsJul 2026470k1.3k
lark-base飞书多维表格（Base）操作：建表、字段、记录、视图、统计、公式/lookup、表单、仪表盘、workflow、角色权限；遇到 Base/多维表格/bitable 或 /base/ 链接时使用。文件导入转 lark-drive，认证/授权转 lark-shared。SkillsJul 2026382k16k
lark-calendar飞书日历：管理日历日程和会议室。查看/搜索日程、创建/更新日程、管理参会人、查询忙闲和推荐时段、预定会议室。当用户需要查看日程安排、创建/修改会议、查询/预定会议室时使用。不负责：查询过去的视频会议记录（走 lark-vc）、待办任务（走 lark-task）。SkillsJul 2026380k16k
shadcnManages shadcn components and projects — adding, searching, fixing, debugging, styling, and composing UI, including chat interfaces. Provides project context, component docs, and usage examples. AppliSkillsJul 2026246k120k
xlsxUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.SkillsJul 2026139k163k
firebase-data-connectAgent Skills for FirebaseSkillsJul 2026108k387

cohort-analysis

507stars91forks

View on GitHub

How to install cohort-analysis?

indranilbanerjee/digital-marketing-pro/cohort-analysis

$npx -y skills add indranilbanerjee/digital-marketing-pro --skill cohort-analysis

Installs into the current project.

Summary

Analyze customer cohorts. Use when: acquisition cohorts, retention curves, LTV by cohort, behavioral segmentation.

Files · 1

View on GitHub

SKILL.md

1	# /digital-marketing-pro:cohort-analysis
2
3	## Purpose
4
5	Perform customer cohort analysis to understand lifecycle patterns, retention, and value over time. Segment customers into cohorts by acquisition date, channel, behavior, or value tier, then track retention curves, compare cohort performance, and identify which acquisition sources produce the highest-value customers. This analysis reveals whether the business is acquiring better or worse customers over time, which channels drive long-term value versus one-time transactions, and where lifecycle interventions (onboarding improvements, re-engagement campaigns, loyalty programs) would have the greatest impact on retention and revenue.
6
7	## Input Required
8
9	The user must provide (or will be prompted for):
10
11	- Cohort type: `time-based` (customers grouped by acquisition week, month, or quarter — the standard cohort analysis showing retention evolution over time), `channel-based` (customers grouped by acquisition source — paid search, organic, social, email, referral — revealing which channels produce the most durable customers), `behavioral` (customers grouped by first action taken — e.g., product category purchased, feature used, content consumed — identifying which entry points lead to highest retention), or `revenue-tier` (customers grouped by initial purchase value — low, medium, high, enterprise — showing how starting value correlates with lifetime retention and expansion)
12	- Time period and granularity: The analysis window and cohort size — weekly cohorts for the past 3 months (high resolution, best for fast-cycle businesses), monthly cohorts for the past 12 months (standard for most businesses), or quarterly cohorts for multi-year analysis (best for long-cycle B2B or subscription businesses). Granularity determines both how cohorts are defined and the retention interval measured
13	- Metrics to track: Which outcomes to measure across cohorts — `retention rate` (percentage of cohort still active at each interval), `revenue` (cumulative and per-period revenue per customer), `LTV` (cumulative lifetime value with projected future value), `engagement` (login frequency, feature usage, content consumption), or multiple metrics simultaneously for a comprehensive lifecycle view
14	- Data source: Where to pull customer data — `CRM` (deal data, customer records, lifecycle stages), `analytics` (website behavior, conversion events, session data), `product analytics` (feature usage, activation events, engagement metrics), or a combination of sources merged on customer identifier
15
16	## Process
17
18	1. Load brand context: Read `~/.claude-marketing/brands/_active-brand.json` for the active slug, then load `~/.claude-marketing/brands/{slug}/profile.json`. Extract business model (SaaS, eCommerce, B2B), typical customer lifecycle length, key retention metrics, and churn definition for the industry. Check for guidelines at `~/.claude-marketing/brands/{slug}/guidelines/_manifest.json`. If no brand exists, ask: "Set up a brand first (/digital-marketing-pro:brand-setup)?" — or proceed with defaults.
19	2. Define cohorts based on selected type: Segment the customer base into cohorts. For time-based: group customers by the week, month, or quarter they were first acquired (first purchase, account creation, or first meaningful interaction). For channel-based: group by the acquisition source attributed to their first conversion (UTM source, referral path, or CRM lead source field). For behavioral: group by the first significant action taken (first product category purchased, first feature activated, first content type consumed). For revenue-tier: group by initial transaction value bucketed into tiers (define thresholds based on the business's order value distribution — e.g., bottom 25%, middle 50%, top 25%).
20	3. Pull customer data from CRM and analytics MCPs: Gather the complete customer dataset — acquisition dates and source from CRM MCP, transaction history with timestamps and values, engagement events (logins, feature usage, email opens, site visits) from analytics MCPs, churn events (cancellation, last activity date, account closure), and any customer attributes needed for cohort segmentation. Merge data from multiple sources on customer identifier, resolving duplicates and filling gaps where possible.
21	4. Build retention matrix: For each cohort, calculate the retention rate at each subsequent time interval (Week 1, Week 2, Month 1, Month 2, etc. matching the selected granularity). Retention is defined as the percentage of the original cohort that performed a qualifying activity (purchase, login, engagement event — depending on the business model) during that interval. Present as a triangular matrix with cohorts as rows and time intervals as columns, with color-coded cells (green for above-average retention, re

People who liked this also viewed

6 picks

Type