Amazon Negative Keyword Finder
Paste or choose your Sponsored Products search term report and this tool lists the search terms that spent money without producing an order, using thresholds you set. It suggests negative exact for one-off junk queries and negative phrase for words that repeat across wasted terms, then gives you a copy-ready list and a CSV. It is for sellers and agencies who want a fast first pass before editing campaigns by hand. The file is read locally in your browser and never uploaded. The output is a review list, not a command to negate.
No data loaded yet.
Detected columns (change if wrong)
Rules
A blank or zero threshold is ignored. Leave both blank and nothing is flagged. Terms with orders are never negative candidates; with an ACoS ceiling they appear in the held-back list for a bid review instead.
Results appear here once a report is loaded.
How it works, and what it does not cover
Parsing. The tool reads comma, tab or semicolon separated text, copes with quoted fields, thousands separators, dollar signs and a leading byte-order mark, and skips a few lines of preamble above the header. Search terms are lowercased and merged across campaigns and ad groups, so a term that appears in five rows is judged on its total clicks, spend and orders. ACoS is recalculated from spend and sales rather than read from the report's ACoS column.
Flagging. A term is a candidate when it has zero orders and meets your click and spend thresholds. Whether both or either must be met is your choice. Terms whose text contains a brand word, terms at or above your impressions limit, and any term with orders are excluded from the copy list and shown in a held-back table with the reason.
Match type suggestions. A candidate that looks like a product code (B0 followed by eight characters) is listed as a negative product target. A word that appears in at least three flagged terms, and in no term that has orders and no brand word you entered, becomes a negative phrase suggestion, and the multi-word terms that contain it are covered by it. Everything else defaults to negative exact. These are heuristics, so a word that looks harmless in your sample may still matter in terms the report did not include.
Choosing thresholds. Amazon's targeting guide suggests waiting for about 20 clicks and two weeks or more before judging a term. A margin-based rule is stricter and more personal: price times target ACoS is the most one sale can cost in ads, so a term that has spent well past that with no order is a stronger candidate than one that merely reached a click count. The negative keywords guide walks through this with examples.
What it does not do
- It does not connect to Amazon, upload negatives, or edit campaigns. Add them yourself in the console or a bulk sheet after checking them.
- It does not know your margins, seasonality, stock levels or listing quality, so it cannot tell a bad query from a bad bid.
- It cannot see attribution lag. Leave the latest week of data out, and do not trust a report that mixes campaign types with different attribution windows.
- Column headers that are not in English, or reports with several header rows, may need manual column mapping.
- Match type and negative-list limits differ by campaign type and may change. Confirm in your console before building a long list.
The author runs an Amazon advertising agency and builds Amazon software, which is why this page carries no product promotion; see the disclosure.
Data last verified 2026-10-23. Prices, hours and rules change; confirm fees, limits and program terms with the official source before you rely on a number.
Sources
Related guides
Frequently asked questions
Is my search term report uploaded anywhere?
No. The file or pasted text is read and parsed by JavaScript in your own browser tab. There is no upload, no server call, no cookie and no storage, and the page works with your network disconnected once it has loaded. Closing or reloading the tab discards the data. Still, treat client reports with the same care you would any spreadsheet.
Which columns does the tool need?
At minimum a search term column and either clicks or spend. For best results it also uses impressions, orders, sales and campaign name. It recognises common Amazon Ads headers such as Customer Search Term, Clicks, Impressions, Spend, 7 Day Total Orders (#), 7 Day Total Sales and Campaign Name, plus variants like Cost, Search Term and 14 Day Total Orders. If a column is guessed wrong, change it in the column mapping and the results update.
How many clicks or how much spend should I use as the threshold?
Amazon's targeting guide suggests evaluating a negative after about 20 clicks and waiting two weeks or more. A better anchor is your own economics: the price times your target ACoS is the most a sale may cost in ad spend, so flagging terms that spent about 1.5 to 2 times that with no orders is a sensible start. The defaults here (10 clicks and 10 dollars) are only a starting point; set your own.
Why are some terms held back instead of listed as candidates?
Terms that contain a brand word you entered, terms with high impressions, and terms that already have orders are never put on the copy-ready list. They are shown separately because negating them is the mistake that most often costs sales. Review them by hand and decide.
What do exact and phrase mean in the suggestions?
Negative exact is suggested for a single specific query that looks like junk on its own. Negative phrase is suggested only when the same word shows up in three or more flagged terms and never appears in a term that has orders in your report, which suggests a pattern such as a wrong material or intent word. Amazon describes both as also covering close variations, so a phrase negative can block more than you expect. Check the match types your console offers before uploading.