Works with the AI Agents you already use
cohort and segmentation explorer
This skill automates the generation of acquisition-period cohort tables and retention matrices from entity and event data.
$2.99
cohort and segmentation explorer
Example session with this skill installed
Analyze the customer_data.csv and events.log files as of 2023-12-31. Use a monthly grain, 12-month window, and compare segments by the 'signup_channel' attribute. Band by event count.
- Read your context and instructions
- Compiled the cohort and segmentation
- Generated the data export
The analysis of the provided dataset is complete. The acquisition cohorts and retention matrix have been calculated using the monthly grain for the 12-month window requested.
Cohort and Segmentation Explorer — TechCorp, 2024-01-05
1. Scope, sources and assumptions
- Sources: E1 (customer_data.csv), E2 (events.log)
- Dataset ID: TC-RET-2023
- Grain: month | Window: 12 | Min group size: 5
- As-of date: 2023-12-31
2. Cohort retention matrix
| Cohort | Size | +0 | +1 | +2 | +3 |
|---|---|---|---|---|---|
| 2023-01 | 1,200 | 1.0000 | 0.4500 | 0.4000 | 0.3800 |
| 2023-02 | 950 | 1.0000 | 0.4200 | 0.3900 | n/a (suppressed) |
3. Pooled retention curve
| Offset | Cohorts | Active | Denominator | Retention |
|---|---|---|---|---|
| 0 | 12 | 12,000 | 12,000 | 1.0000 |
| 1 | 11 | 4,800 | 11,000 | 0.4364 |
4. Segment comparison
| Segment | Size | Retention (+3) | 95% CI | Mean Events |
|---|---|---|---|---|
| Organic | 5,000 | 0.4200 | +/- 0.02 | 12.4 |
| Paid | 4,500 | 0.3500 | +/- 0.03 | 8.2 |
5. Behaviour bands
| Band Name | Min Events | Count | % of Total |
|---|---|---|---|
| Regular | 10 | 2,500 | 0.2500 |
| Occasional | 1 | 6,000 | 0.6000 |
| Dormant | 0 | 1,500 | 0.1500 |
6. Segment definitions and approval
- High-Retention Organic: Entities from signup_channel 'Organic' with > 10 events.
- At-Risk Paid: Entities from signup_channel 'Paid' with 0 events in +3 period.
7. Exclusions, warnings and limitations
- Excluded 45 records due to missing consent.
- Warning: 12 entities had events dated before acquisition; these were ignored.
8. Interpretation and items for human review
- Observed: Organic signups show a 7% higher retention at month 3 compared to paid.
- Analytical estimate — validation required: The dip in Feb cohort may correlate with the site outage.
- Management decision required: Approval needed for 'At-Risk' segment definition before export.
This analysis supports, and does not replace, professional judgment and management's decision.
Next steps
- Validate the 'At-Risk' segment criteria with the product team.
- Review the excluded records to ensure consent flags are being captured correctly.
customer_data.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
This skill automates the generation of acquisition-period cohort tables and retention matrices from entity and event data. It solves the problem of manual, error-prone retention tracking by using a deterministic script to calculate counts, rates, and intervals without leaking future information into historical cohorts. The tool handles small-group suppression for privacy and ensures only consented data is processed.
What it does
- Cohort Analysis builds acquisition-period tables with fixed denominators to track entity activity over time.
- Retention Curves generates pooled retention data across multiple cohorts to identify long-term trends.
- Segment Comparison compares groups based on approved attributes, providing retention rates and 95 percent intervals.
- Behavioral Banding categorizes entities into rule-based bands like dormant, occasional, or regular.
- Data Validation enforces strict exclusions for records without consent or events dated before acquisition.
How it works
- Source Verification registers entity and event sources, confirming dataset approval and consent flags.
- JSON Preparation builds a
request.jsonfile following the schema for cohort rules, grains, and attributes. - Deterministic Execution runs the included Python script to calculate the retention envelope.
- Report Generation produces a structured Markdown report with cohort tables, curves, and behavior bands.
Frameworks & tools
The skill utilizes a self-contained Python execution environment (scripts/run.py) and standard JSON schema validation. It is designed for environments that support Python 3 and local file manipulation.
Why this beats prompting it yourself
Prompting an LLM to calculate retention rates often results in "hallucinated" percentages or flawed logic regarding future-lookahead bias. This skill offloads calculations to a deterministic script, ensuring every number is mathematically grounded and audit-ready.
Use cases
- Generating a monthly retention matrix for a subscription-based user base.
- Comparing retention differences between specific marketing channels or attributes.
- Defining behavioral segments for user engagement reporting.
- Suppressing small-group data points to maintain internal reporting privacy.
Known limitations
Does not support predictive modeling, causal inference, or path-based funnel analysis. Requires pre-pseudonymized entity IDs and does not process direct identifiers like emails.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse All Claude Skills.
Requires Python 3. No support for predictive modeling or causal inference. Requires pre-pseudonymized data. Entities below the minimum group size are suppressed.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 3 days ago