Amazon Negative Keyword Generator
Paste a search term report or a list of terms, filter by clicks and orders, and download a Sponsored Products bulk file of negatives.
Only terms with at least this many clicks and no more orders than below.
From a bulk file you download in Campaign Manager → Bulk operations. Used when a row has no ID.
Negatives ready to upload
5
From 9 search terms: those with 10+ clicks and 0 or fewer orders.
- Negative keywords
- 4
- Negative ASINs
- 1
- Spend on these terms
- $55.25
Open Campaign Manager → Bulk operations, paste these rows into the Sponsored Products Campaigns sheet of a downloaded bulk file (or upload this CSV after checking it in Excel), then upload.
Product,Entity,Operation,Campaign Id,Ad Group Id,Portfolio Id,Ad Id,Keyword Id,Product Targeting Id,Campaign Name,Ad Group Name,Start Date,End Date,Targeting Type,State,Daily Budget,sku,asin,Ad Group Default Bid,Bid,Keyword Text,Match Type,Bidding Strategy,Placement,Percentage,Product Targeting Expression,Audience ID,Shopper Cohort Percentage,Shopper Cohort Type,Sites,Off-Amazon ad serving
Sponsored Products,Negative keyword,Create,291845501,184402217,,,,,,,,,,enabled,,,,,,water bottle for kids,negativeExact,,,,,,,,,
Sponsored Products,Negative product targeting,Create,291845501,184402217,,,,,,,,,,enabled,,,,,,,,,,,"asin=""B08XYZ1234""",,,,,
Sponsored Products,Negative keyword,Create,291845501,184402217,,,,,,,,,,enabled,,,,,,water bottle sticker pack,negativeExact,,,,,,,,,
Sponsored Products,Negative keyword,Create,291845502,184402231,,,,,,,,,,enabled,,,,,,water bottle cleaning brush,negativeExact,,,,,,,,,
Sponsored Products,Negative keyword,Create,291845502,184402231,,,,,,,,,,enabled,,,,,,collapsible water bottle for hiking,negativeExact,,,,,,,,,Plain list for pasting into Campaign Manager's negative keywords box
What the tool does
Paste in a Search term report from Campaign Manager (or a plain list of terms, one per line) and set a minimum clicks, maximum orders and minimum spend. The tool builds one row per term in Amazon's Sponsored Products bulk file format, ready to upload, skipping any term Amazon's keyword rules wouldn't accept.
Worked example (the tool's sample report, default filters: 10+ clicks, 0 orders)
- Sample report
- 9 search terms across 2 ad groups
- Filter
- 10 or more clicks, 0 or fewer orders
5 negatives ready to upload: 4 negative keywords and 1 negative product target (from an ASIN-shaped search term), covering $55.25 of spend with no sales.
Amazon's keyword rules, built in
- 80-character limit on any keyword text.
- Negative phrase allows up to 4 words; negative exact and other match types allow more, but the tool still caps every term at 10 words.
- No leading or trailing hyphens, pluses or periods, and no unpaired quotation marks. Amazon rejects keywords formatted this way, so the tool skips them and tells you why.
- ASIN-shaped terms (the pattern Amazon customer search terms use for a competitor's product, like B08XYZ1234) become negative product targets instead of keywords, since Amazon treats them differently in the bulk file.
Uploading the result
- 01
Get the report
In Campaign Manager, download a Search term report for Sponsored Products, for the date range you want to review.
- 02
Add campaign and ad group IDs if needed
Reports include them by default. If you're pasting a plain list of terms instead, enter the campaign and ad group ID once in the fields above and the tool applies them to every row.
- 03
Filter and download
Adjust minimum clicks, maximum orders and minimum spend, then download the CSV.
- 04
Upload in Campaign Manager
Go to Bulk operations, paste the rows into the Sponsored Products Campaigns sheet of a downloaded bulk file (or upload the CSV directly after checking it in a spreadsheet), then upload.
Questions people ask
What is a negative keyword on Amazon Ads?
A search term you tell Amazon not to show your ad for. It stops wasted spend on clicks that rarely or never turn into a sale, while leaving your other targeting untouched.
Where do I get a search term report?
From Campaign Manager in Amazon Ads: download a Search term report for your Sponsored Products campaigns for the date range you want to check.
What clicks and orders threshold should I use?
There's no fixed rule. Many sellers start around 8 to 15 clicks with zero orders, tightening it for higher-priced items where a single wasted click costs more, and loosening it for cheap items with many clicks.
Why did the tool skip some of my search terms?
Amazon's keyword rules reject terms over 80 characters, phrase-match terms over 4 words, terms with a hyphen or plus next to a space, or unpaired quotation marks. The tool lists each skipped term and why.
Can I add negatives at the campaign level instead of the ad group?
Yes, switch Add negatives to to the whole campaign. ASIN-shaped terms still go in at ad group level, since Amazon's bulk file only accepts negative product targets there.
Related tools
Want this builtinto your store?
I'm Emmanuel, a Shopify and WooCommerce developer. If this tool pointed at something you'd rather have fixed for you (a faster store, cleaner product data, a migration, a custom feature), send me a note.
Emmanuel Asika
Shopify & WooCommerce developer, Dublin
I build and fix online stores: new builds, migrations, speed, SEO and the custom bits apps can't do.
Last reviewed 30 September 2026.
Sources: Amazon Ads: Downloadable reports in sponsored ads · Amazon Ads: Search term report for Sponsored Products