E-commerceReview Analysisintermediate

E-commerce Customer Review Sentiment & Unmet Need Mining

Synthesize hundreds of verified customer reviews to discover recurring defects, praise patterns, and copy gaps.

#ecommerce #customer-reviews #sentiment-analysis #voice-of-customer #product-insights

Compatibility & Specs

Compatible AI Models

ClaudeChatGPTGemini

Last UpdatedOct 3, 2026

Customizable Variables3 parameters

Main Prompt Template3 Variables

197 words • 1484 characters

Tip:Variables marked in purple brackets can be tailored below.

Customize Prompt

Fill in the variables below. Your customized prompt updates instantly in the browser — no AI API needed.

Parameters (3)* Indicates required field

Product Category & Name*[product_category]

The product being evaluated

Raw Customer Reviews*[raw_reviews]

Paste an uncurated sample of positive, neutral, and negative reviews

Key Business Objective*[business_goal]

What outcome you want from this analysis

3 parameters active

Live Customized OutputLive Preview

348 words

You are a Head of Product Intelligence and Voice-of-Customer (VoC) Market Researcher. I need you to analyze raw customer reviews and feedback to uncover actionable insights for product engineering, copywriting, and customer retention. Product Name & Category: Ergonomic Lumbar Support Office Chair ($320) Raw Customer Reviews Sample (1-star, 3-star, and 5-star comments): Review 1 (5 stars): 'Saved my lower back. I sit 10 hours a day coding and the lumbar cushion actually stays where you lock it. Took 20 minutes to put together.' Review 2 (1 star): 'I am 6 foot 3 and the headrest pushes into my upper shoulders instead of my neck. Horrible for tall people. Sending back.' Review 3 (4 stars): 'Great mesh breathability during summer. But the wheels are cheap plastic and scratch hardwood floors. Had to buy rollerblade wheels separately.' Review 4 (2 stars): 'Armrests are too hard, my elbows were sore after 2 hours. Also the tilt tension knob was stuck.' Review 5 (5 stars): 'Solid build, feels like a Herman Miller at a fraction of the cost. Best purchase for my home office this year.' Key Business Objective (Reduce returns, improve ad copy, or develop next generation): Reduce high return rate driven by sizing misfit and update the PDP copy to prevent inaccurate customer expectations. Deliver the Customer Review Intelligence Report: 1. Sentiment Breakdown & Recurring Thematic Clusters: Group feedback into discrete positive and negative sentiment clusters with frequency estimates (e.g., Sizing/Fit, Durability, Assembly Clarity, Customer Service). 2. Unmet Customer Needs & Recurring Defects: Highlight the specific, repeated failure points cited in 1-star and 2-star reviews. Identify whether the issue stems from manufacturing defects, misleading product descriptions, or user error. 3. Voice-of-Customer (VoC) Copy Goldmine: Extract the exact, authentic phrases and emotional words satisfied customers use to describe their relief or excitement. Format these into ready-to-use headlines for ad campaigns. 4. PDP FAQ & Clarity Recommendations: Identify the top 3 unaddressed questions buyers had before purchasing that led to friction or returns. 5. Prioritized Action Matrix: Categorize findings into Immediate Copy Fixes (under 24 hours), Packaging/Manual Improvements, and Long-Term Product R&D.

Launch in:

ChatGPT Claude Gemini

How to Use This Prompt

Follow this 3-step workflow to extract high-signal responses from any compatible AI model.

1. Tailor the Parameters

Use the interactive customizer above to substitute the bracketed placeholders with your exact context, requirements, and constraints.

2. Send to AI Model

Copy the prompt and paste it into Claude, ChatGPT, Gemini, or Copilot. These models follow structured multi-step constraints reliably.

3. Review and Iterate

Review the output against the verified benchmark below. Follow up in the conversation to stress-test edge cases or refine tone.

Prompt Variables & Parameters

Reference breakdown of every dynamic variable embedded in this prompt template.

Placeholder	Parameter Name	Type	Status	Description & Guidance
[product_category]	Product Category & Name	text	Required	The product being evaluatedDefault: Ergonomic Lumbar Support Office Chair ($320)
[raw_reviews]	Raw Customer Reviews	textarea	Required	Paste an uncurated sample of positive, neutral, and negative reviewsDefault: Review 1 (5 stars): 'Saved my lower back. I sit 10 hours a day coding and the lumbar cushion actually stays where you lock it. Took 20 minutes to put together.' Review 2 (1 star): 'I am 6 foot 3 and the headrest pushes into my upper shoulders instead of my neck. Horrible for tall people. Sending back.' Review 3 (4 stars): 'Great mesh breathability during summer. But the wheels are cheap plastic and scratch hardwood floors. Had to buy rollerblade wheels separately.' Review 4 (2 stars): 'Armrests are too hard, my elbows were sore after 2 hours. Also the tilt tension knob was stuck.' Review 5 (5 stars): 'Solid build, feels like a Herman Miller at a fraction of the cost. Best purchase for my home office this year.'
[business_goal]	Key Business Objective	text	Required	What outcome you want from this analysisDefault: Reduce high return rate driven by sizing misfit and update the PDP copy to prevent inaccurate customer expectations.

Example Execution & Benchmark Output

Sample input arguments and the verified AI response demonstrating expected quality and formatting.

Sample VariablesInputs

[product_category]

Ergonomic Lumbar Support Office Chair ($320)

[raw_reviews]

Review 1 (5 stars): 'Saved my lower back. I sit 10 hours a day coding and the lumbar cushion actually stays where you lock it. Took 20 minutes to put together.' Review 2 (1 star): 'I am 6 foot 3 and the headrest pushes into my upper shoulders instead of my neck. Horrible for tall people. Sending back.' Review 3 (4 stars): 'Great mesh breathability during summer. But the wheels are cheap plastic and scratch hardwood floors. Had to buy rollerblade wheels separately.' Review 4 (2 stars): 'Armrests are too hard, my elbows were sore after 2 hours. Also the tilt tension knob was stuck.' Review 5 (5 stars): 'Solid build, feels like a Herman Miller at a fraction of the cost. Best purchase for my home office this year.'

[business_goal]

Reduce high return rate driven by sizing misfit and update the PDP copy to prevent inaccurate customer expectations.

Expected AI ResponseVerified Result

### Voice-of-Customer Intelligence Report: Ergonomic Office Chair #### 1. Thematic Issue Clustering * **Cluster 1: Height Limitation (Root Cause of High Returns):** Users over 6'1" experience the headrest as an ergonomic obstruction rather than support. When buyers discover this post-delivery, return freight costs erode margin. * **Cluster 2: Hard-Floor Wheel Complaints:** Plastic casters scratch hardwood, forcing buyers to source 3rd-party polyurethane wheels. * **Cluster 3: Core Comfort Praise:** The adjustable lumbar lock mechanism earns glowing feedback from users sitting 8+ hours. #### 2. High-Converting VoC Copy Goldmine * *'Feels like a $1,200 chair at a fraction of the price.'* * *'The lumbar cushion that actually stays locked where you put it.'* * *'Engineered for 10-hour workdays: breathable mesh that stays cool all summer.'* #### 3. Immediate PDP Fixes to Slump Returns 1. **Height Recommendation Banner:** Explicitly add to specs: 'Ideal for heights between 5'4" and 6'1". (Users 6'2"+ should view our XL Tall Model)'. This single clarification pre-empts the #1 return driver. 2. **Upsell Opportunity:** Bundle upgraded 'Rollerblade-safe hardwood casters' as an instant 1-click cart add-on for $29.

Best Use Cases

Scenarios and roles where this prompt produces maximum leverage.

Product managers synthesizing monthly customer feedback without manual sorting

Growth marketers finding high-converting hook copy directly from satisfied customers

Merchandisers reducing return rates through honest, proactive sizing disclosures

Tips for Best Results

Techniques to elevate response fidelity

•Provide rich background context rather than one-sentence inputs to receive deep, non-generic responses.
•Engage in multi-turn conversation: use the initial output as a baseline, then ask the AI to sharpen specific sections.
•Prompt the model to highlight any hidden assumptions or missing trade-offs in its recommendations.

Common Mistakes to Avoid

Frequent failure modes and anti-patterns

•Giving minimal context and expecting nuanced, expert-level strategic output.
•Not validating factual references, citations, or statistical claims with verified primary sources.
•Skipping the customization step and pasting raw bracketed template variables into the AI chat.