Amazon Search Term Harvester
Upload your Amazon Search Term Report to find wasted spend, discover high-converting terms to promote, and detect duplicate keywords across campaigns. All processing happens in your browser. Your data never leaves your computer.
Drop your Search Term Report here or click to upload
CSV or TSV from Amazon Advertising console
How to download your Search Term Report
- Go to Amazon Advertising Console → Measurement & Reporting → Sponsored ads reports
- Click Create report, select Search term as the report type
- Choose your date range (last 30 or 60 days works well)
- Download the CSV and upload it here
How to Use the Search Term Harvester
The search term report is the single most valuable data source in Amazon PPC. It shows you exactly what shoppers typed before clicking your ad and whether that click led to a sale. This tool automates the analysis that most sellers do manually in spreadsheets.
Upload your report and the tool instantly categorises every search term into three buckets: terms to negate (wasting money), terms to promote (converting well but not in exact match campaigns), and duplicate terms (appearing across multiple campaigns where you are bidding against yourself).
Finding and Eliminating Wasted Spend
The negatives tab shows search terms where you are spending money without getting sales. The tool flags terms with high clicks and zero orders, as well as terms with an ACoS more than double your target. These are your biggest savings opportunities.
A typical Amazon account wastes 15-30% of ad spend on irrelevant search terms. By systematically adding negatives, you redirect that budget toward terms that actually convert. Export the list directly from the tool and upload it to your campaigns.
Promoting High-Converting Search Terms
The promotions tab surfaces search terms that are converting below your ACoS target with multiple orders. These are proven winners that deserve their own exact match campaigns with dedicated bids. Moving them from broad or auto campaigns to exact match gives you more control over bids and placement.
De-Duplicating Keywords Across Campaigns
When the same keyword exists in multiple campaigns, Amazon runs them both in the same auction. You end up competing with yourself, which inflates your cost per click. The duplicates tab identifies overlapping keywords and shows you exactly which campaigns contain them.
The de-duplicator normalises terms by removing punctuation, handling plural forms, and sorting word order so that “blue dog collar” and “dog collar blue” are correctly identified as the same keyword.
Tools That Automate This Further
This free tool gives you immediate insight, but if you manage dozens of campaigns, Helium 10's Adtomic automates search term harvesting on an ongoing basis with rule-based bid management. Jungle Scout includes keyword tracking and PPC analytics that complement manual search term analysis. See our full roundup of the best AI tools for Amazon FBA for more options.
Frequently Asked Questions
- How do I download my Amazon Search Term Report?
- In Amazon Advertising Console, go to Measurement and Reporting, then Sponsored ads reports. Create a new report and select Search term as the report type. Choose your date range (30 or 60 days is recommended), generate the report, and download the CSV file. Upload that CSV to this tool.
- What are negative keywords and why do they matter?
- Negative keywords are search terms you explicitly exclude from triggering your ads. If a search term generates clicks but no sales, you are paying for irrelevant traffic. Adding these terms as negatives stops your ads from showing for those queries, saving your budget for terms that actually convert.
- What is a good ACoS target for Amazon PPC?
- It depends on your profit margins. If your product margin is 30%, your break-even ACoS is 30%. Most sellers target an ACoS below their margin to ensure profitability. New product launches often accept higher ACoS (40-60%) to build sales velocity, while established products typically aim for 15-25%.
- What does the keyword de-duplicator do?
- The de-duplicator identifies the same search term (or close variants like different word order or plural forms) appearing across multiple campaigns or ad groups. When the same keyword exists in multiple places, you are bidding against yourself in the auction, which drives up your cost per click. Consolidating duplicates into a single campaign reduces wasted spend.
- Is my data safe with this tool?
- Yes. All processing happens entirely in your browser. Your Search Term Report data is never uploaded to any server. The file is read locally by your browser, analysed using JavaScript, and the results are displayed on screen. Nothing leaves your computer.
- How often should I harvest search terms?
- Most Amazon PPC managers review search terms weekly or fortnightly. A 30-day lookback gives you enough data to identify patterns without being overwhelmed. After major changes like new product launches or seasonal shifts, review more frequently.