Search Term Analysis
Analyze SP and SB Search Term Reports. View interactive ACOS band charts, identify high-ACOS bleeding terms, high converting keywords, and untested search terms.
What This Tool Does
- Goal: Identify high-ACOS bleeding terms, highly converting terms, and untested keywords.
- Analysis: Parses your SP and SB Search Term Reports.
- Visualization: Displays interactive pie charts showing spend distribution across ACOS bands.
- Export: Download findings into a neat, 4-sheet Excel report.
How To Use
- Download your Search Term Report or Bulk Operations file from Amazon.
- Upload the .xlsx file below.
- Adjust your ACOS, CVR, and Click thresholds to customize the view.
- Explore the different tabs and click Export to save your analysis.
Set Thresholds
Configure your analysis criteria.
Upload File
Select your Amazon Search Term Report .xlsx
Click or drag your Amazon PPC Bulk File (.xlsx)
Sort every search term into keep, cut, or scale
A search term report is thousands of rows of raw truth about your account — every customer search that triggered a click, what it cost, and what it sold. The problem is volume: nobody can hand-review 5,000 rows, so most sellers sample the biggest spenders and miss everything else. The waste hides in the long tail, and the winners hide there too.
This analyzer applies your thresholds to every row at once — across both Sponsored Products and Sponsored Brands sheets — and sorts each term into clear buckets: High Converting terms worth scaling, High ACOS terms that need bid cuts, No Sales terms that are negative-keyword candidates, and Potential terms worth watching. What used to take an afternoon in Excel takes under a minute.
How It Works
- 1
Set your thresholds
Define what counts as high ACOS, enough clicks to judge a term, and your order cutoffs — tuned to your margins, not a one-size-fits-all rule.
- 2
Upload your search term report
Drop in the .xlsx export from Amazon Ads. The tool reads both SP and SB search term sheets in one pass, entirely in your browser.
- 3
Review the classified buckets
Every term lands in a category — High Converting, High ACOS, No Sales, or Potential — with charts showing how your spend distributes across them.
- 4
Export and act
Download the categorized results and work each bucket: scale the winners into exact match, cut bids on the bleeders, and negate the dead weight.
When To Use This Tool
Fast account triage
Taking over a new account or returning from a break? One upload shows where the spend goes and how much of it converts.
Spot spend concentration
The category breakdown shows what share of budget sits in each performance bucket — the fastest read on overall account health.
Recurring optimization cycle
Run it on every new report cycle. Consistent thresholds make month-over-month comparisons meaningful.
Prep work for bulk changes
The exported buckets become your worklist: graduation candidates, bid-cut lists, and negative keyword candidates, already sorted.
Frequently Asked Questions
A practical starting point: flag terms with 10+ clicks and zero orders as No Sales candidates, and set your High ACOS line at your break-even ACOS (your profit margin before ad spend). If your margin is 30%, terms running above 30% ACOS lose money on the first order — whether that's acceptable depends on whether the term drives rank or repeat purchases.
This tool gives you the full picture — every term classified across all performance buckets, for strategy and triage. The Negative Keyword Generator focuses on one bucket (wasted spend) and takes it further: match-type selection and an Amazon-ready bulk sheet for upload. They work well in sequence.
Because they compete for the same customer searches from separate budgets. A term might look fine in Sponsored Products but bleed in Sponsored Brands, or vice versa. Reading both sheets in one pass catches waste that per-campaign-type review misses.
Scale it to your conversion rate: at a 10% conversion rate, 10 clicks should produce about one order, so 15-20 clicks with zero orders is a meaningful signal. Judging terms on 3-4 clicks mostly punishes bad luck — set your click threshold high enough that zero orders means something.
Yes — free, no login required, and your report is parsed entirely in your browser. Nothing is uploaded. Part of the free Amazon PPC audit suite by Ads Acceleration.
Scaling Amazon Ads for
Million-Dollar Brands
Rule-Based Automation, Profit & Organic Ranking — Supporting 8-Figure Brands with an In-House PPC Team.
