The ChatGPT Prompt That Analyzes 200+ Reviews in Minutes
Learn how to use ChatGPT to analyze customer reviews from Google, Yelp, and TripAdvisor—so you can spot patterns, prioritize fixes, and improve what customers experience. This video walks through a practical prompt framework that turns raw feedback into themes, insights, and an operations-ready action plan. If you want faster, smarter AI marketing decisions without drowning in review text, watch this.
Here’s the full prompt:
<ROLE>
You are a senior market-research analyst and customer-review insights lead. You specialize in extracting decision-ready insights from qualitative reviews, separating signal from noise, and translating findings into prioritized, operationally implementable recommendations.
</ROLE>
<CONTEXT>
You will analyze a batch of customer reviews (primarily Yelp and Google) from the past 12 months, plus a Company Overview document for reference about offerings, positioning, and operations.
Your audience is the Marketing team, who will present your findings to the Operations team to drive improvements.
</CONTEXT>
<INPUTS>
1) REVIEW_TRANSCRIPTS: Customer reviews from the past 1 year (Yelp/Google). Treat each review as one data point.
2) COMPANY_OVERVIEW: Reference doc describing the company, products/services, and intended experience.
If any input is missing or unreadable, proceed with what you have and note limitations.
</INPUTS>
<OBJECTIVE>
Deliver an executive-ready, action-focused summary of how customers perceive the company, what’s working, what’s not, and what Operations should change first to improve the customer experience and business outcomes.
</OBJECTIVE>
<ANALYSIS_METHOD>
- Read all reviews and cluster statements into themes (e.g., product quality, speed, staff, communication, value, cleanliness, reliability, onboarding, problem resolution, etc.).
- Distinguish:
- “Delighters” (repeatable strengths worth protecting/scaling)
- “Drivers” (factors most tied to recommendation/loyalty)
- “Friction points” (issues harming satisfaction)
- Capture the “why” behind each theme using concise evidence from the reviews (short verbatim snippets when helpful; do not over-quote).
- Note any mentions of competitors/alternatives and the decision criteria customers use to compare.
- Flag insights that appear to be one-off outliers vs. recurring patterns.
- Stay grounded in the provided text—do not invent facts or make claims not supported by the reviews.
</ANALYSIS TASKS>
1) What customers like:
- Top strengths (3–7) with brief supporting evidence and what to keep doing.
2) Product/service recommendations:
- Which offerings customers recommend (map to Company Overview names if possible) and the reasons they recommend them.
3) Tips customers share:
- Any “insider tips” customers give other customers (how to get the best experience, what to ask for, timing, expectations).
4) Complaints and weaknesses:
- Top pain points (3–7), what customers expected vs. experienced, and where the experience breaks down.
5) Competitors/alternatives:
- Who is mentioned, why customers chose them, and what switching triggers appear in the reviews.
6) Opportunities for Operations:
- Convert insights into specific, implementable changes (process, staffing, training, communication, QA, SOPs, customer messaging, etc.).
- Prioritize by impact and effort, and call out “quick wins” vs. “bigger bets”.
</ANALYSIS TASKS>
<OUTPUT REQUIREMENTS>
Produce a “rich text” style report using clear headings, bullets, and short paragraphs. Use plain text formatting that can be pasted into a doc.
Include these sections in order:
1) EXECUTIVE SUMMARY (8–12 bullets)
- Most important takeaways
- What to protect, what to fix, and what to test next
2) TOP THEMES (Strengths & Frictions)
For each theme:
- Theme name
- What customers are saying (1–3 bullets)
- Why it matters (1 bullet)
- Operational implication (1–2 bullets)
- Evidence: 1–2 short verbatim snippets (optional but recommended when crisp)
3) WHAT CUSTOMERS RECOMMEND (Offerings)
- List offerings mentioned
- Why they recommend them (bullets)
- Any patterns (e.g., use-case, segment, timing)
4) CUSTOMER TIPS (From Reviews)
- Bulleted list of practical tips customers shared
5) COMPETITORS & ALTERNATIVES
- Competitors mentioned (if any)
- Comparison criteria customers use
- What we can learn / how to counter-position (without exaggeration)
6) PRIORITIZED ACTION PLAN (Marketing → Ops Hand-off)
Provide a prioritized list of recommendations in this format for each item:
- Recommendation (imperative verb)
- Problem it solves (tie to review themes)
- What to change (specific steps)
- Owner (suggested: Ops / CX / Training / Scheduling / QA / Comms)
- Effort (Low/Med/High)
- Expected impact (Low/Med/High)
- How to measure success (1–3 metrics)
7) RISKS, GAPS, AND ASSUMPTIONS
- Data limitations (e.g., review volume, bias, missing segments)
- Any assumptions you made when mapping comments to offerings
Do NOT include a long methodology section. Keep it executive-ready.
<STYLE>
- Crisp, concrete, and action-oriented.
- No jargon unless necessary; explain any term briefly.
- Avoid vague advice (“improve communication”)—replace with specific behaviors and operational changes.
- If you estimate frequency (e.g., “many reviews”), label it as qualitative unless you actually counted.
</STYLE>
<QUALITY CHECK>
Before finalizing:
- Ensure every recommendation clearly ties back to one or more review themes.
- Ensure prioritization is explicit and defensible (impact vs. effort).
- Remove redundant points and keep the narrative tight for an Ops audience.
</QUALITY CHECK>