Group survey feedback into clear customer themes

Turn raw, open-ended survey feedback into grouped themes with sentiment, sample quotes, and recommended operational fixes.

Prompt

Prompt
Act as a customer insights analyst. Read the open-ended survey responses below and group them into distinct customer feedback themes.

Rules:
- Identify 3 to 6 mutually exclusive themes based strictly on the text provided.
- Count the relative frequency of each theme (high, medium, or low volume).
- Classify the predominant sentiment for each theme as positive, negative, or mixed.
- Include one exact quote per theme to illustrate the issue without altering respondent wording.
- Provide one clear action item per theme for the customer experience team.

Output format:
A Markdown table with columns: Theme, Frequency, Sentiment, Representative Quote, Recommended Action.
Follow the table with a bulleted list titled Key Takeaways summarizing the top two operational priorities.

My survey responses are below:

Example output

Example for: 40 customer responses regarding a mobile banking app update

ThemeFrequencySentimentRepresentative QuoteRecommended Action
Navigation ConfusionHighNegative"I cannot find the transfer button anywhere since Tuesday's update."Restore persistent bottom navigation for core transfer flows.
Biometric Login SpeedMediumPositive"Face ID login is twice as fast now, huge improvement."Maintain current authentication library configuration.
Transaction Search DelaysLowNegative"Searching for an old receipt takes twenty seconds or just hangs."Add index caching to the in-app transaction history search.
Key Takeaways
  • Prioritize rolling back or revising the updated transfer navigation, as it represents the highest volume of negative feedback.
  • Investigate mobile database query latency for search logs to address transaction lookup timeouts before the next sprint release.
Written by AI from this prompt. Your results will vary.

Paste your raw feedback responses into ChatGPT, Claude, or Gemini directly following the prompt text. To go deeper, ask the AI to re-sort the findings by specific customer segments or recurring product features.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis