Report tool
Amazon negative keyword finder
Drop in your Sponsored Products search term report to list the searches that spent money without an order, then check them and download them as negative keyword candidates.
- Free, no sign-up
- Your file stays in your browser
Drop your search term report here
XLSX or CSV, straight from the Amazon Ads console.
Your report is read by your browser and never uploaded. Close the tab and it's gone.
A search term needs both minimums before it's listed. Set one to 0 to skip it. With a target ACoS, converting terms at 2x your target or more are listed too.
Next step
Run this check without the export
A downloaded report is one date range, frozen. In Merch Jar your search term data stays connected, so you can run the same review on any date range without exporting anything.
- N-Grams and the Search Terms page
- N-Grams shows the same one, two and three word breakdown for your connected account, on any date range. When you find a term to block, add it as a negative exact or phrase keyword from the Search Terms page.
- The Search Term Waste Elimination template
- This Library template checks your search terms every day against the click and spend minimums you set, with safeguards for terms that sell. It's saved disabled. You review the matches, and it only adds negative exact keywords after you enable it. If you use the Copilot, your AI can help you pick the settings and preview the matches first.
How to find negative keywords in your report
- 1In the Amazon Ads console, open Reporting under Measurement & Reporting and start from the Search term template in All templates.
- 2Use at least 30 days if you can, since a week rarely gives one search enough clicks to judge. XLSX and CSV both work, daily or summary.
- 3Drop it in above. Your file never leaves your browser. The finder reads it on your device, and there's no account or upload.
- 4Check the list and download it as negative keyword candidates. If you'd rather start from the full analyzer, with the words view open too, it's the same tool as the search term report analyzer.
FAQ
How the finder picks candidates
Your search term report has one row per search, per ad group. The finder adds up clicks, spend and orders for each one and lists the searches that reached your minimum clicks and spend without a single order, most expensive first. The defaults are 20 clicks and $10. Add a target ACoS and it also lists searches that did convert, but at twice your target or more.
In the sample data, a garden tools seller spent $436.40 of $1,250.36 on searches with no orders. "electric hedge trimmer" tops the list at $47.15 over 41 clicks, and nobody searching for a hedge trimmer was going to buy a pair of pruners.
What to check before you add the negative
Most rows are easy calls. A few need a second look.
- A "Sells in another ad group" tag. In the sample, "pruning shears" has no orders in the auto campaign but sells well in the exact campaign. A negative exact in the auto campaign can still make sense, since it pushes that search to the exact keyword. Just never add it where it sells.
- Searches under your minimums. "bypass pruners japanese" has 5 clicks and no orders, which tells you very little yet, so it stays off the list until it has more data.
- Product pages. Rows that look like b0garden31 are ASINs, product detail pages where your ad showed. You block those with a negative product target, and the download labels them that way.
- The last few days of the report. Orders can still be credited to recent clicks after you download it, so a search with fresh clicks may not be finished.
Negative exact, or a phrase that covers several searches
The finder suggests a negative exact keyword for each search, which blocks that one search and nothing else. When the same word keeps turning up in losing searches, a negative phrase keyword can cover all of them at once.
In the sample, "hedge" shows up in four searches with $126.40 of spend and no orders between them. The n-gram analyzer adds up spend by word and phrase like that, and checks whether a phrase also appears in searches that sell. For match types and where each negative goes, see how to use Amazon negative keywords.