Free Tool

Amazon Search Term Analyzer

Upload your Amazon Ads bulk file and get the full story on your search terms — not just which to negate. It breaks every term into n-grams, classifies irrelevant traffic, maps your orders distribution, finds your best performers, and estimates how much you're wasting across three buckets. Everything runs in your browser — your file never leaves your computer.

1. Export your bulk file from Seller Central (with the SP/SB Search Term Report)

2. Upload it & set your thresholds

3. Get your savings estimate + downloadable Excel

1. Your bulk file

An Amazon Ads bulk file (.xlsx) containing a "SP Search Term Report" and/or "SB Search Term Report" sheet. Download it from Seller Central → Advertising → Bulk Operations (choose a date range and include search term reports).

Drop your .xlsx here or click to choose

Nothing is uploaded — it's read locally in your browser.

2. Your thresholds

These calibrate the analysis to your account. Defaults are sensible starting points — set your real target ACOS for accurate savings.

Target ACOS (%) *

High-ACOS multiplier (×target)

Days the file covers (optional)

Min clicks before flagging (zero-order)

Min spend to flag ($)

Low-order threshold (orders under)

How savings are estimated (three buckets, no double-counting): ① terms classified as irrelevant (wrong audience, category, intent, etc.) — full spend wasted; ② zero-order terms past your click/spend thresholds — full spend wasted; ③ low-order terms with ACOS above your high threshold — only the spend above what your target ACOS allows is counted as waste.

3. Your results

Verify the numbers, then download the full Excel workbook (Summary, Order Analysis, 1/2/3-Gram, Top Performers).

Estimated recoverable waste

Order distribution

Top wasted n-grams (flagged irrelevant)

Top performing search terms

This shows the leaks. Want them fixed?

Finding wasted spend is step one. Restructuring the account so it actually turns profitable is what we do.

Get a free profit audit