How do I get my search-term report?

In Amazon Ads, open Reports and run a Search Term report for Sponsored Products, or download a Bulk file. Export to CSV or copy the rows, then paste them in. The tool auto-detects the customer search term, spend, sales and orders columns.

What should I do with the wasteful n-grams?

Add the worst offenders as negative keywords (negative phrase or negative exact) at the campaign or ad-group level. A single negative on a wasteful word can stop spend across many search terms at once. Re-check after a couple of weeks.

Is my report data safe?

Yes. The analysis runs entirely in your browser — nothing is uploaded to a server. Close the tab and the data is gone.

N-gram analyzer

Advanced

Amazon search-term n-gram analyzer

Your search-term report hides patterns one term at a time. Paste it here and the tool rolls every term up into 1, 2 and 3-word phrases, so the words quietly draining budget — and the ones worth more — jump out.

Drop, upload or paste your Search Term Report

Drop a .csv or .xlsx here, or paste into the box. Runs entirely in your browser — nothing is uploaded.

What an n-gram analysis actually shows you

An “n-gram” is just a word or short phrase. The tool takes every customer search term in your report, breaks it into its individual words, pairs and triples, and adds up the spend, sales and ACoS everywhere each one appears. So instead of scanning thousands of search terms one by one, you see that — for example — the word “cheap” shows up across 40 different terms and has burned $310 with zero orders.

That is the point: negating one search term fixes one term. Negating one wasteful word, once you can see it pattern across everything, fixes all of them at once. The flags help you triage, but the rule for negating is irrelevance, not just a high ACoS. “Negate?” means a word spent with no orders — check the terms, then negate the truly irrelevant ones. “High ACoS” means it converts but inefficiently, so lower the bid rather than cut it off.

Pair it with your target ACoS from the break-even calculator and you have a weekly routine for defending your margins.

Where to get the data

Export your Search Term Report from Amazon

Open Sponsored ads reports

In Amazon Ads, go to Measurement & Reporting → Sponsored ads reports.

Create a Search term report

New report → Ad product: Sponsored Products, Report type: Search term.

Set the date range

Time unit: Summary, last 60–90 days so the data is meaningful.

Download and paste

Export as CSV, open it, copy the rows and paste them above.

FAQ

Common questions

N-gram analysis breaks every customer search term into its component words (1-word, 2-word and 3-word phrases), then totals the spend, sales and ACoS for each. It surfaces patterns a term-by-term view hides — for example, that every search containing the word 'cheap' converts poorly, even across dozens of different terms.

More free tools

Keep going with the rest of the kit

Starter

Break-even ACoS calculator

Find the ACoS where an ad-driven sale stops making money — plus the target ACoS for the margin you want to keep.

Open tool→

Starter

Profit & TACoS calculator

Turn revenue, ad spend and costs into net profit, net margin and TACoS — the number that actually tracks ad efficiency.

Open tool→

Intermediate

Benchmark comparison

See how your ACoS, CPC, CTR and conversion rate stack up against the benchmark for your category.

Open tool→

Stop harvesting negatives by hand

Doing this by hand every week is the chore Autron removes. It harvests negatives and tunes bids on your search terms continuously, so wasted spend never gets a chance to pile up.

Run a free PPC audit Try Autron free