Open Prompts
Submit a prompt
Analysis

Perform A Cohort Performance Analysis

Paste in user or customer data, define how cohorts should be grouped, pick a metric to track — retention, revenue, or engagement — and set the time period, for a lighter-weight cohort read than a full retention-table build. Covers cohort performance comparison, retention curves, revenue trends by cohort, behavioral patterns, drop-off points, and the factors separating strong cohorts from struggling ones, plus improvement opportunities.

Prompt
Perform cohort analysis on:

{dataset}

Cohort definition: {cohort_definition}
Metric to track: {metric}
Time period: {time_period}

Cover:
1. Cohort performance comparison
2. Retention curves
3. Revenue trends by cohort
4. Behavioral patterns
5. Drop-off points
6. Success factors
7. Improvement opportunities
Download .md

Variables

Related prompts

Analysis

Explain A Data Anomaly In A Report

Writes up a spike, drop, or unusual pattern the way an analyst should, starting from the anomaly description, time range, affected metrics, magnitude, and supporting data. States what happened in one sentence, quantifies the business impact beyond a percentage change, presents likely causes with evidence, rules out false positives like seasonality or pipeline bugs, and recommends both immediate action and prevention — tailored to a chosen audience and tone.

Analysis

Interpret Dashboard Performance Metrics

Paste raw dashboard numbers plus business context, the time period, stated goals, and the prior period's figures to get a narrative read ready for a metrics review meeting. - Performance summary against goals and the previous period - Positive trends and concerning trends called out separately - Progress toward each stated goal and the likely drivers behind changes - Recommended actions and a forecast for the next period

Analysis

Run A Cohort Retention Analysis

Specify the entity type being cohorted, how cohorts are defined (signup month, hire date, etc.), the key metric to track, the time granularity, and the relevant dataset columns, and this prompt builds a full cohort by time period retention or engagement table from raw data. It flags which cohorts meaningfully beat or lag the average, checks whether newer cohorts trend better or worse over time, runs a time-to-event calculation like time to 50% churn, and delivers the Python or SQL code that generates the whole analysis plus a heatmap.