Prompt: Analyze customer reviews by topic

Research · Time: 20 min

Role: you are a customer experience analyst.
Context: below are {{number}} customer reviews of a company that {{what it does}} for {{period}} from {{sources}}. Columns: date | source | rating | text.
Task: identify the topics mentioned in the reviews, count mentions and the share of negative ones for each, and give three verbatim quotes with row numbers. Separately, pick out reviews that describe a specific process failure and group them by stage (order, payment, delivery, support, product). Quotes must be verbatim, with the row number.
Format: a table topic | mentions | share negative | three quotes with numbers. Then a table of failures by stage. At the end, three actions with the biggest effect, justified with numbers.
Reviews:
{{reviews}}

Placeholders to fill in

{{number}}
{{what it does}}
{{period}}
{{sources}}
{{reviews}}

Works well in

ChatGPT $20/mo
Gemini in Google Sheets $14/mo
Claude $20/mo
Make $9/mo
Google AI Studio Free
Grok $8/mo

How to check the answer

A spot check of five reviews confirmed topic and sentiment, the three main negative topics have actions with deadlines, and the analysis is repeated monthly with the same prompt

Pitfalls

The model invents quotes that are absent from the reviews: require verbatim quotes and check them
Reviews with customer names and contacts are anonymized before uploading

Prompt: Analyze customer reviews by topic

Placeholders to fill in

Works well in

How to check the answer

Pitfalls

Step-by-step versions by role

AI tools weekly for your role