Amazon Search Term Report: How to Read It in 30 Minutes a Week (and What to Do With Each Row)

Written by the BidVentor Editorial Team. Last updated November 2026.
Quick answer
The Amazon search term report lists the real words shoppers typed before they clicked your ad, along with the spend, orders, and sales each term produced. Most sellers open it, scroll, feel overwhelmed, and close it. The fix is a simple weekly routine. First, work out your break-even cost per order (product price × target ACoS). Then sort every search term with meaningful spend into one of four buckets: harvest (it converts, give it its own exact match keyword), negate (it has spent more than one break-even order with no sale, and it is not relevant), fix (it is relevant and gets clicks but does not convert, so the problem is the listing or the price, not the keyword), or wait (not enough data yet). Thirty minutes a week on this does more for profit than hours of bid tweaking.
Key takeaways
- The search term report is the only place Amazon shows you what shoppers actually typed. Your keyword list is what you asked for. The report is what you got.
- Use one number as your verdict line: your break-even cost per order. A term has “earned a verdict” when it has spent about that much.
- Every row with enough spend belongs in one of four buckets: harvest, negate, fix, or wait. If a row does not fit, it goes in wait.
- A relevant term that gets clicks and no sales is a listing signal, not a negative keyword. Negating it hides the problem.
- Harvest and negate together. When you move a winner into exact match, add it as a negative exact in the campaign it came from, so the two campaigns stop competing.
Why most sellers get little out of the search term report
Even a modest account can produce thousands of rows a month. Faced with that, most sellers sort by spend and negate a few zero-order terms, or sort by sales and add a few winners, then stop. Both help a little. Neither is a system, and both miss the most expensive pattern in the report: relevant terms that keep getting clicks and keep failing to convert.
Here is the shift we want you to make. The search term report is not a to-do list. It is a confession. It tells you how Amazon interpreted your keywords, which shoppers your listing persuades, and which ones it loses. Read it that way and every row has a clear job.
Step 1: Set your verdict line before you open the report
Before you look at a single row, write down one number: your break-even cost per order.
Break-even cost per order = product price × target ACoS
If your product sells for $25 and your target ACoS is 30%, you can afford to spend $7.50 in ads to win one order. That is your verdict line.
Why this number? Because it answers the question every seller asks about a search term: “Has it had enough chances?” A term that has spent $2 with no sale has not had a fair trial. A term that has spent $15, two full break-even orders, with no sale has.
Our rule of thumb:
- Under 1× break-even spend: too early to judge. Leave it alone.
- 1× to 2× break-even spend with no order: look closely at relevance.
- Over 2× break-even spend with no order: this term needs a decision this week.
Tighten or loosen the multiples if you like. Just decide them before you see the data, so you do not negotiate with every row.
If you are not sure what your target ACoS should be, start with our guide on how to calculate your max CPC. The same math sets your verdict line.
Step 2: Download and trim the report
In the Amazon Ads console, create a Sponsored Products search term report. A 30-day window is a good default; for a seasonal product, use 14 days.
Open the file and trim it before you think:
- Remove rows where the search term is an ASIN code (they start with “b0”). Those are product targeting matches, and they deserve their own review.
- Filter out rows below your minimum spend. For the $25 product above, anything under about $4 is noise for now.
- Add two columns: cost per order (spend ÷ orders) and verdict multiple (spend ÷ break-even cost per order).
What remains is usually a few dozen rows, not thousands. That is your real workload.
Step 3: Sort every remaining row into four buckets
Bucket 1: Harvest
What it looks like: two or more orders, and a cost per order at or under your break-even.
What to do: add the search term as an exact match keyword in a dedicated exact campaign or ad group. Then add the same term as a negative exact in the auto or broad campaign it came from.
That second move is the one most sellers skip. Without it, the same search keeps matching both campaigns, and you lose control of which bid wins. The discovery campaign found the term. Its job is done. Let the exact campaign own it.
Bucket 2: Negate
What it looks like: spend over your verdict line, zero orders, and the term is not relevant to what you sell.
Relevance is the key word. “Hair dryer brush” spending money on your flat iron listing is not relevant. Neither is a competitor’s brand name you never meant to target, or a search for a product type you do not make.
What to do: add it as a negative exact if only that exact phrase is the problem. Use negative phrase if a whole family of searches is wrong, for example every search containing “kids” when your product is for adults. Be careful with negative phrase on short words. A negative phrase of “free” can block “fragrance free”, which might be one of your best terms.
For a deeper walkthrough of match types and safe negation, see our guide on negative keywords on Amazon.
Bucket 3: Fix
What it looks like: spend over your verdict line, few or no orders, and the term is relevant. It describes your product well. Shoppers are clicking. They are just not buying.
This is the most expensive bucket in most accounts, and the most misunderstood. The instinct is to negate. Resist it. If a perfectly relevant search does not convert, negating it only removes the evidence. The same shoppers will reach your listing another way and leave for the same reason.
What to do: treat the term as a question your listing failed to answer. Search it yourself on Amazon and look at the page of results through a shopper’s eyes:
- Is your main image clearly weaker than the products around it?
- Is your price far above the typical result for that search?
- Does your title or first bullet use the shopper’s words, or your own?
- Do your reviews raise a concern the shopper cares about, like scent, size, or durability?
Lower the bid on the term while you work on it, so the leak slows down. Then fix the listing. We cover this pattern in more depth in Amazon PPC clicks but no sales.
Bucket 4: Wait
What it looks like: under your verdict line, or one order at a cost you cannot judge yet.
What to do: nothing yet. Acting on terms that have not had enough clicks is one of the most common ways sellers damage good campaigns.
A worked example
Here is an illustrative example, not a client result. Say you sell a $25 heat protectant spray with a 30% target ACoS. Your verdict line is $7.50. After trimming, five rows stand out:
| Search term | Spend | Orders | Verdict multiple | Bucket |
|---|---|---|---|---|
| heat protectant spray for flat iron | $18.40 | 4 | 2.5× | Harvest (cost per order $4.60) |
| hair dye | $16.10 | 0 | 2.1× | Negate (not relevant) |
| heat protectant spray for fine hair | $21.30 | 1 | 2.8× | Fix (relevant, cost per order $21.30) |
| heat protectant | $5.20 | 0 | 0.7× | Wait |
| thermal spray for curly hair | $8.90 | 1 | 1.2× | Wait (one order is not a pattern) |
The first row moves to exact match and gets a negative exact in the source campaign. The second becomes a negative exact. The third is the interesting one. “Fine hair” shoppers are clicking, so the product is showing up for the right need. Maybe the listing never says it is lightweight or will not weigh hair down. Maybe a few reviews mention a heavy feel. That is a listing fix, and a bid cut while it happens. The last two stay put.
Step 4: Read the report for listing insights, not just ad decisions
The search term report is also free market research. Once a month, sort the full report by orders and read the top 20 converting terms out loud. Ask:
- Which words do buyers use that your title does not? If “for fine hair” converts and your title says “lightweight formula”, you are speaking a different language from your buyers.
- Which needs keep appearing? Repeated modifiers like “travel size”, “sensitive skin”, or “for men” point to bullet points, images, or even product variations.
- Which competitor names convert for you? That tells you whose shoppers find your offer attractive.
This matters more now that Amazon’s search and Rufus try to match products to the need behind a search, not just the words. This is exactly where our listing optimization tool, built for Amazon’s COSMO algorithm and Rufus, helps: it turns buyer language into listing copy and image direction. And when a “fix” term keeps failing, our Review Analyzer, which reads all reviews, can show you which objections buyers raise before they buy elsewhere.
Common mistakes with the search term report
Negating relevant terms because they did not convert. It shrinks your reach and hides a listing problem you will keep paying for elsewhere.
Harvesting without negating. Leave a winner open in the auto campaign and your own campaigns bid against each other while your data splits in two.
Reviewing it once and forgetting it. Search behavior shifts with seasons and competitors. A weekly half hour beats a quarterly cleanup.
How BidVentor fits in
If you run a handful of campaigns, the routine above works well in a spreadsheet. As the account grows, the bucket sorting becomes the bottleneck. Our PPC optimization tool connects to your Amazon Ads account through the Amazon Ads API as a verified Amazon Ads partner, or works from your bulk files, and uses search term performance to surface valuable queries, negative-targeting gaps, wasted spend, and weak bids. You still make the calls on relevance. You just stop hunting for them. The PPC tool includes a 4X ROAS guarantee, terms apply.
You can try it with one free analysis after you sign up.
Frequently Asked Questions
What is the Amazon search term report?
It is a Sponsored Products report that shows the actual search terms shoppers typed before clicking your ads, with the keyword or target that matched each term and the clicks, spend, orders, and sales it produced. It is the most direct view of how Amazon matched your keywords to real searches.
How often should I review my search term report?
Weekly works well for most sellers. A 30-day window reviewed once a week gives terms enough time to collect data while still catching waste before it builds up. For fast-moving seasonal products, review a 14-day window.
When should I add a search term as a negative keyword?
Add it as a negative when it has spent at least one to two times your break-even cost per order (price × target ACoS) with no orders, and it is not relevant to your product. If the term is relevant, treat the low conversion as a listing or pricing problem first and lower the bid instead of negating.
Why do I need to negate harvested keywords in the original campaign?
When you move a converting search term into an exact match campaign, the original auto or broad campaign can still match the same search. Adding it as a negative exact there stops your campaigns from competing with each other and keeps each term’s data in one place.
Sources and further reading
Related guides
- Negative keywords on Amazon: stop wasted clicks
- Amazon PPC clicks but no sales
- Amazon CPC: how to calculate your max CPC
How we make this content
These guides are written by the BidVentor Editorial Team. Where we cite Amazon features or numbers, we link to Amazon’s own documentation. We update guides when Amazon’s tools or our guidance change, and we describe BidVentor’s features as they work today. See our methodology, or contact us with corrections.
Ready to Optimize Your Amazon PPC?
Connect your Amazon Ads account through the Amazon Ads API (BidVentor is a verified Amazon Ads partner), or upload a bulk file if you prefer. BidVentor is Amazon bid optimization software that reviews weak bids, wasted spend, and negative-keyword gaps. The PPC tool includes a 4X ROAS guarantee. Terms apply.
About BidVentor Editorial Team
The BidVentor Editorial Team is a dedicated collective of Amazon PPC and paid advertising experts. We empower brands to unlock scalable growth through data-driven strategies, precision campaign management, and a relentless focus on ROI. Our mission is to transform your ad spend into your most profitable channel.




