Cohort Analysis — Free M365 Copilot AI Prompt

Free advanced AI prompt for analysts: analyse user or customer behaviour by cohort. Works in M365 Copilot. Tag: analyst.

Tested by a human Advanced 👤 Analyst 👤 Product Manager
Group users from this data into cohorts by [CRITERIA — sign-up month / first purchase / plan tier]. Track [METRIC — retention / revenue / engagement] over [PERIODS]. Show: cohort table, trend chart, strongest vs weakest cohort, and 3 actionable insights.

Works on

⭐ M365 Copilot (Best)

Copy & Open in

Prompt is copied to your clipboard when you click

Tips for Best Results

  • Cohort analysis reveals patterns averages hide
  • At least 6 months of data for meaningful trends
  • Compare cohorts to identify what changed

📎 More Prompts

A/B Test Results Analyser — Free M365 Copilot AI Prompt

●●●
Analyse this A/B test: Control [A METRICS] vs Variant [B METRICS]. Determine: (1) Statistical significance (p-value), (2) Confidence interval, (3) Effect size, (4) Sample size adequacy, (5) Winner recommendation with caveats, (6) Whether to continue testing.
⭐ M365

Analyse Dataset for Top Insights — Free M365 Copilot Prompt

●
Analyse this data and give me the top [NUMBER — 3 / 5] insights. For each insight explain: what the data shows, why it matters, and what I should do about it. Include a supporting chart or visualisation for the most impactful finding. Write for [AUDIENCE — management / the team / a technical audience].
⭐ M365

Benchmark Comparison — Free M365 Copilot AI Prompt

●●
Compare our metrics against industry benchmarks. Our data: [PASTE KEY METRICS]. Industry: [INDUSTRY]. For each metric: (1) Our value, (2) Industry benchmark, (3) Percentile ranking, (4) Gap analysis, (5) Whether the gap matters and what to do about it. Flag where we significantly lag or lead.
⭐ M365