prompt

Cohort Definition Template

Define reusable, unambiguous cohort definitions for retention, LTV, engagement, and churn analysis.

Updated June 2026
The prompt
Cohort analysis goal: {{analysis_goal}}. Population: {{population}}. Start event: {{entry_event}} ({{entry_criteria}}). Observation window: {{observation_period}}. Comparison: {{comparison_type}}.

Define cohort:
1. Inclusion criteria (all must be true): {{criteria_list}}
2. Exclusion criteria: {{exclusion_list}}
3. Start date assignment: is cohort bucketed by {{bucketing_dimension}} (week, month, quarter)?
4. Day 0: exact definition of {{entry_event}} — which specific user action?
5. Day N: definition of {{measured_outcome}} for {{observation_period}}
6. SQL pseudocode: how to query this cohort
7. Validation: expected cohort size {{expected_size}}, actual {{actual_size}} — do they match?
Did it work? Rate this prompt

Variables

What you're analyzing (retention, engagement, churn)
User population (all users, new users, paid, etc.)
Event that defines cohort entry
Conditions for entry
How long to track (e.g., 12 weeks)
What you're comparing across
List of inclusion criteria
List of exclusion criteria
Time unit for cohort bucketing
Metric being tracked
Expected cohort size
Actual cohort size from query

Details

Author

AI Khazna

License

—

Security

—

Type

prompt

Related assets

More curated picks in Data & Analytics.

prompt
Turns a set of findings into a clear narrative with a headline, supporting points, and a call to action.
Data Storytelling Builder
Turns a set of findings into a clear narrative with a headline, supporting points, and a call to action.0+
prompt
Get a structured, step-by-step plan to clean a messy dataset before analysis.
Data Cleaning Plan Generator
Get a structured, step-by-step plan to clean a messy dataset before analysis.0+
prompt
Plans a pivot table to answer a specific question from your data.
Pivot Table Planner
Plans a pivot table to answer a specific question from your data.0+
prompt
Produces a structured checklist to audit a dataset across completeness, accuracy, consistency, and timeliness.
Data Quality Audit Checklist
Produces a structured checklist to audit a dataset across completeness, accuracy, consistency, and timeliness.0+
prompt
Describe what you want in words and get the exact Excel formula, plus a short explanation of how it works.
Excel Formula Builder
Describe what you want in words and get the exact Excel formula, plus a short explanation of how it works.0+
prompt
Define the right KPIs, chart types, and layout for a dashboard that serves a specific goal and audience.
KPI Dashboard Planner
Define the right KPIs, chart types, and layout for a dashboard that serves a specific goal and audience.0+

Audit before you install

Run any source through our checks - AI visibility, security, performance, and stack detection.

Automated Web Security Scan

security

PageSpeed Analyzer

performance

AI Content Quality Test

arabic content

AI Agent / MCP Server Tester

ai testing

Site Stack Detector

migration

AI SEO / AEO / GEO Audit

ai visibility

llms.txt Generator

ai visibility

Readability Score

arabic content

Schema / JSON-LD Builder

ai visibility

AI Cost Calculator

ai testing

Headline Analyzer

arabic content

More in Data & Analytics