Compare survey ratings across customer segments

Break down aggregate customer satisfaction scores across plans, tiers, or regions to expose hidden pockets of churn.

You getSegment Comparison Table, critical Gaps and priority Focus

Prompt

Prompt
You are a customer success operations specialist. Analyze the survey rating dataset provided below to identify variations across customer segments.

- Calculate the average score and response volume for each segment provided.
- Identify segments where ratings deviate significantly from the overall average.
- Highlight any segments with high strategic value (such as enterprise or long-tenured accounts) that report low satisfaction.
- Point out sample size caveats where low response counts might distort a segment average.

Output format:
- Segment Comparison Table (columns: Segment, Response Count, Average Score, Difference vs Overall)
- Critical Gaps (bulleted list of underperforming segments and operational risks)
- Priority Focus (two specific groups needing immediate investigation)

Here is the survey data:

Example output

Example for: quarterly CSAT scores across enterprise, mid-market, and self-serve tiers

Segment Comparison Table

SegmentResponse CountAverage ScoreDifference vs Overall
Overall Baseline3404.1 / 5.00.0
Self-Serve1954.4 / 5.0+0.3
Mid-Market1103.9 / 5.0-0.2
Enterprise353.1 / 5.0-1.0

Critical Gaps

  • Enterprise accounts average a full point below the overall score. Enterprise accounts often carry the largest contracts, so this is a renewal risk worth checking.
  • Self-serve supplies 195 of the 340 responses, so it lifts the overall 4.1 and hides the enterprise gap.
  • The enterprise result rests on only 35 responses, so confirm it with direct conversations before drawing firm conclusions.

Priority Focus

  • Enterprise accounts scoring below 3.0: schedule outreach calls with their account owners this week.
  • Mid-market accounts: review recent support tickets and written comments for repeated complaints.
Written by AI from this prompt. Your results will vary.

Paste your tabulated survey scores grouped by tier, role, or region into ChatGPT, Gemini, or Claude. For a helpful follow-up, ask for three targeted discovery questions to send the lowest-scoring cohort.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis