Summarize customer segment shifts for executive updates

Convert raw cohort and customer segmentation tables into clear movement summaries. Use this to highlight changing customer mixes before monthly leadership reviews.

You getHeadline Takeaway, segment Movement Summary and revenue Implications

Prompt

Prompt
Act as a principal product analyst. Review the customer segmentation data pasted below and produce a clear update for executive leadership.

- Highlight the largest absolute and percentage shifts across customer tiers or cohorts.
- Identify whether movement reflects healthy customer expansion or concerning churn down-market.
- Connect the data shifts to likely revenue and retention consequences without speculating beyond the numbers.

Output format:
- Headline Takeaway (one sentence)
- Segment Movement Summary (3-4 bullet points comparing prior to current period)
- Revenue Implications (2 short bullets)
- Recommended Action Items

The customer segmentation data is below:

Example output

Example for: quarter-over-quarter active user tier comparison table

Headline Takeaway
Mid-tier accounts expanded rapidly this quarter, but lower-tier self-serve users contracted by 14%, driving up average revenue per user while softening top-of-funnel volume.

Segment Movement Summary

  • Enterprise Tier: Grew from 420 to 468 accounts (+11.4%), maintaining zero downgrades and accounting for 62% of total active ARR.
  • Mid-Market Tier: Expanded by 18.2% (1,150 to 1,359 accounts), representing the fastest growing segment by volume.
  • Self-Serve Tier: Dropped from 8,400 to 7,224 accounts (-14.0%), driven by trial expiration cleanups and lower free-to-paid conversion.
  • Inactive/Dormant: Remained flat at 3.1% of registered accounts.

Revenue Implications

  • Near-term revenue stability improves as high-contract-value customers represent a larger share of the revenue base.
  • Long-term pipeline risk increases if self-serve contraction reduces organic expansion into mid-market tiers.

Recommended Action Items

  • Audit the self-serve onboarding flow to identify where signups are dropping off before product activation.
  • Expand sales engineering capacity to support the accelerating influx of mid-market trials.
Written by AI from this prompt. Your results will vary.

Copy your segment comparison table or cohort breakdown from your BI tool and paste it into ChatGPT, Claude, or Gemini. Follow up by asking the model to write a two-sentence Slack summary for the sales leadership channel.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis