Copy and paste into your AI tool
You are a senior Amazon consumer insights analyst. You specialize in
extracting signal from review data that most sellers ignore — not just
star ratings, but the specific language customers use to describe what
they love, what frustrated them, and what they wish the product could
do. Your job is to find the patterns that inform better positioning and
better products, not to summarize what's already obvious.

I'm going to give you a batch of Amazon reviews (one or more products).
Analyze them using the framework below.

STEP 1: SORT BY SIGNAL TYPE

Assign every review — or every meaningful review excerpt — to one of
five categories:

DESIRE — Something the customer explicitly wants the product to do or
be. Language cues: "I wish," "would be perfect if," "hoping for,"
"looking for something that."

OBJECTION — A reason to not buy or a reason they returned/regretted.
Language cues: "disappointed," "not as described," "expected better,"
"returned because," "wouldn't buy again."

DELIGHT — Specific attributes that exceeded expectations. Language
cues: "surprised by," "better than expected," "love that it," "didn't
expect it to."

UNMET NEED — A gap in the category — something no product reviewed
does well. Language cues: "can't find one that," "every product I try,"
"still looking for," "why doesn't any."

USE CASE SIGNAL — Reveals who the actual buyer is, what job they're
hiring the product for, or a use context the listing may not speak to.
Language cues: "use it for," "bought this for my," "works great when,"
"specifically needed."

STEP 2: CLUSTER AND RANK

Within each signal type, group reviews that express the same underlying
idea. Name each cluster in plain language (e.g., "Durability concerns
after 3 months," not "quality issues"). For each cluster, report:
- Number of reviews in this cluster
- Representative quote (verbatim, under 20 words)
- Whether the signal appears in YOUR product's reviews, COMPETITOR
  reviews, or both

Sort clusters within each type by frequency (highest first).

STEP 3: OPPORTUNITY MAP

After the signal inventory, produce an Opportunity Map with three
sections:

EXPLOIT (Your strengths that competitors lack): Attributes that appear
in your Delight clusters but NOT in competitor Delight clusters.

DEFEND (Shared weaknesses): Objections that appear in BOTH your reviews
and competitors' — category-level problems buyers accept as normal.

ATTACK (Competitor vulnerabilities you can exploit): Objections that
appear in competitor reviews but NOT in yours.

STEP 4: TOP 5 ACTIONABLE INSIGHTS

List five insights, each with:
- Insight: One sentence describing the pattern
- Evidence: How many reviews signal this, and which products
- Recommended action: One specific change to make — in your listing,
  product, or marketing — not generic advice

Output format: Use headers for each step. Use tables for clusters
(columns: Cluster Name | Count | Quote | Source). Use a three-column
table for the Opportunity Map.

BEFORE YOU EXECUTE:

1. If any required input is missing or unclear, stop and ask a specific
   clarifying question before proceeding. Do not guess or paraphrase
   reviews you haven't been given.

2. If I haven't labeled which reviews belong to which product, ask
   before proceeding — the Opportunity Map requires knowing which
   reviews are yours vs. competitors'.

3. If the review sample is fewer than 30 reviews total, flag that
   conclusions may not be statistically meaningful. Still complete the
   analysis but note the limitation.

4. Do not invent patterns. Only report what's actually present in the
   reviews I provide.

5. After completing the analysis, note under a "Caveats" section any
   review that was ambiguous to categorize.

=====

PASTE YOUR REVIEWS BELOW. Include: product name and ASIN for each
product, and indicate which is YOUR product vs. a COMPETITOR product.
Paste the review text — star rating, review title, and body for each.
The more reviews the better; 50+ per product is ideal.

[YOUR REVIEWS HERE]
What you'd paste after the divider
MY PRODUCT: Stainless Steel Insulated Water Bottle 32oz — ASIN B09XXXXXX

⭐⭐⭐⭐⭐ "Finally keeps coffee hot all morning"
I've tried 4 different bottles and this is the first one that actually
stays hot for 8+ hours. Bring it to the gym, car, office. Lid doesn't
leak even in my bag.

⭐⭐⭐ "Good but lid is tricky"
Keeps things cold great. The lid mechanism took me a week to figure
out. Wish the instructions were clearer.

⭐⭐ "Dented after 2 months"
Dropped it once from counter height and it dented. Expected better
from stainless steel.

COMPETITOR: HydroMax Pro 32oz — ASIN B08YYYYYY

⭐⭐ "Leaks from the seal after a few weeks"
Loved it at first but the rubber seal started leaking around the 6
week mark. Customer service didn't help.

⭐⭐⭐⭐⭐ "Perfect for hiking"
Use it every weekend on trails. The wide mouth is great for adding
ice. Bought one for my husband too.

⭐⭐ "Smells like plastic"
Weird plastic smell never went away even after washing many times.
01

Use Helium 10's Review Insights, Jungle Scout's Review Analysis, or simply export reviews from your Seller Central or a competitor ASIN page. Aim for at least 50 reviews per product and include a range of star ratings — 1-3 star reviews carry disproportionate insight.

02

Run this analysis separately for your category's top 3 competitors, then combine the results. The patterns that appear across all three competitors represent category-wide expectations — the table stakes every listing must address.

03

The "Unmet Need" cluster is your most valuable output. If multiple reviewers across multiple products express the same wish that no product in your category satisfies, that's a product development or positioning opportunity worth serious attention.

What does the Review Mining Analyzer prompt do?
Extract structured patterns from Amazon product reviews — yours and your competitors' — to surface the top objections, desires, and unmet needs in a category. Transforms raw review text into a prioritized insight map that informs positioning, listings, and product development.
What data do I need to use this prompt?
An example of the exact input format is provided on this page under "Example Input." Generally you'll prepare your data in the structure shown, paste it after the prompt body, and the AI will return the analysis described above. If you're missing any inputs, the prompt will ask you what it needs.
How long does this take to set up?
Setup time for this prompt is 30-60 mins. That includes pulling your data, formatting it to match the example, and running the prompt. Once your data pipeline is set up the first time, subsequent runs take only a few minutes.
Which AI tool should I use this with?
This prompt is designed to work with any major large language model — ChatGPT (GPT-4 or newer), Claude (Sonnet 4 or newer), or Gemini. For structured analysis, math, and tabular outputs, Claude and GPT-4 class models produce the most reliable results.
Does this prompt work for Shopify or other platforms?
This prompt is built for Amazon sellers and references Amazon-specific data points such as referral fees, FBA fulfillment fees, and ASIN-level metrics. The underlying methodology can be adapted to other platforms by substituting equivalent inputs, but the prompt as written is Amazon-first.
What skill level is required to use this prompt?
This prompt is rated intermediate. Some familiarity with your platform's data exports and basic AI prompting is helpful for getting the most out of it. Most ecommerce operators can use it productively within a single session.
Is this prompt free to use?
Yes. Every prompt in the SMB Advantage Prompt Library is free for any small business operator to use. The only cost is whatever you pay for your AI tool subscription (ChatGPT Plus, Claude Pro, etc.).
Stay in the loop

Want notes when new prompts ship?

A few times a week, field notes on what's actually working when AI meets ecommerce ops. Plus first look at new prompts and tools as they go live.