Free Tool — No Signup

N-Gram Analyzer

A word can appear in two hundred search terms, spend a dollar or two in each, convert nothing, and never once show up in a report sorted by spend. Individually invisible; collectively hundreds of dollars. This breaks every search term into words, adds up what each one really costs you — and then checks it against the terms that do convert before suggesting you block it.

How one search term decomposes
stainless steel water bottle
stainlesssteelwaterbottle stainless steelsteel waterwater bottle
Unigrams, bigrams, trigramsChecks converting terms first Drill down to source termsSuggests a safer bigram Negative phrase, not exactRuns in your browser

🔬 What This Tool Does

Aggregates performance at the word level, where the waste actually hides.

📊
Word-level aggregationEvery term split into one, two and three-word sequences, with spend summed across every appearance
The false-positive guardBefore suggesting a word, it counts how many terms containing it convert — and shows the sales you would block
🔍
Drill down before you decideEvery source term behind a word, converting ones highlighted. The thirty-second check that prevents expensive mistakes
🧮
It suggests the safer bigramWhen a word is too broad to block, the two-word phrase that isolates the waste without killing the good traffic
🚫
Negative phrase, correctlyAmazon has no negative broad match. Phrase blocks every term containing your words — which is exactly the point
Upload-ready negativesPick what to block, choose the level, export a bulk file with the right entity and match type

📋 How To Use

Any search term export works — the standalone report or the one inside your bulk file.

Export a search term report60–90 days if you have it. Patterns need volume to emerge
Or just use your bulk fileIt already contains a search term sheet, and it brings campaign IDs for the export too
Start with unigramsBroadest view, biggest wins. Move to bigrams when a word feels too risky to block
Drill into anything before blocking itThe tool tells you what converts; you decide what is relevant
Select, then exportNothing leaves the tool until you have ticked it yourself
🔬

Drop Your Search Term Report Here

Standalone Search Term report, or a bulk file with its search term sheet — .csv or .xlsx

🔒 Never leaves your browser✅ No row limit📝 No signup
📊 Search terms — not loaded The raw material. Either the standalone Search Term report or the SP Search Term Report sheet inside your bulk file — both carry the term, clicks, spend, orders and sales this needs.
📁 Bulk file — not loaded Optional, and it doubles as a search term source. Supplies the campaign and ad group IDs needed to export negatives you can upload rather than paste in by hand.
Longer is better here than anywhere else. N-gram analysis works by finding a pattern across many low-spend terms, so it needs enough of them to be a pattern rather than a coincidence. Sixty to ninety days is the usual recommendation. The tool shows how many separate search terms sit behind every word it suggests, and warns you when a verdict is resting on only two or three.

Decomposing your search terms

Building n-grams…

📄
The Real Problem

Most wasted spend is invisible one row at a time.

You sort by spend, fix the obvious offenders, and feel like you have cleaned up. The real leak is in rows 51 to 3,000.

1

A dollar at a time adds up

One word appearing in 187 search terms, each spending $1 to $5 with nothing to show, is $612 of pure waste. Not one of those rows would ever catch your eye individually.

2

Negating terms is whack-a-mole

Block one search term and three new variations of the same irrelevant idea appear next month. Blocking the word blocks the idea — current and future.

3

The obvious fix is often the wrong one

A word can look like pure waste in aggregate while a handful of terms containing it convert perfectly well. Block it and you take those with it, permanently.

4

High ACOS is not irrelevance

The most expensive mistake in this whole exercise is treating an expensive word as an irrelevant one. One needs a lower bid. The other needs a negative. They are not interchangeable.

What Makes This Different

It checks what converts before it tells you to block anything

Aggregation finds the candidates. The guard is what makes them safe to act on.

The converting-terms column

Every n-gram shows how many of the search terms containing it produced an order, and the sales you would lose by blocking it. A word with even one converting term is marked drill down first rather than recommended. Most n-gram tools show you spend and orders in aggregate and leave you to discover the exception after you have already uploaded the negative.

It proposes the safer bigram

When a word converts too often to block outright, the tool mines the non-converting terms for the two-word phrase that isolates the waste — then verifies that phrase appears in none of the terms that convert. That is the difference between blocking “fish” and blocking “fish tank”, done arithmetically rather than by hand.

Unique spend, not a sum

Overlapping n-grams share the same underlying search terms — “automatic milk frother” lives inside “automatic”. Adding their spend together counts the same dollars repeatedly and inflates the win. The selection bar counts each search term once no matter how many of your chosen n-grams contain it.

It knows what it cannot know

The framework has three columns: spend, orders, and relevance. This tool fills in two of them and says so. Nothing is exported that you have not ticked yourself, because whether “steel” is irrelevant depends entirely on whether you sell anything made of steel — and no report contains that.

ASINs and filler words handled

An ASIN is not words; decomposing b0dd8bstkd pollutes every count, so those terms are excluded and reported separately. Filler words like for and and accumulate enormous spend and blocking one would take most of your traffic with it — hidden by default, with the toggle left visible so you know the choice was made.

Negative phrase, at the right level

Amazon has no negative broad match, so phrase is the instrument that matches how n-grams work — it blocks any term containing your words in order. The export scopes each negative to the campaigns where the waste actually happened, and deliberately skips any campaign where that n-gram converted.

Questions

Frequently Asked Questions

What is an n-gram, in one sentence?
A contiguous run of words from a search term. "Stainless steel water bottle" contains the unigrams stainless, steel, water, bottle; the bigrams stainless steel, steel water, water bottle; and so on. The analysis gives each of those the full metrics of the term it came from, then adds up every appearance — so a word that cost you $2 in each of 200 terms shows up as $400 in a single row.
Should I start with unigrams, bigrams or trigrams?
Unigrams. They give the broadest view and the biggest wins, because one word blocks every phrase containing it. They also carry the highest false-positive risk, which is exactly what the converting-terms column and the drill-down are for. Move to bigrams when a word looks wasteful in aggregate but you can see it belongs to your category — the two-word phrase gives you the context to block precisely. Trigrams are mostly for confirming a pattern rather than acting on one.
Why does it refuse to just tell me what to negate?
Because the deciding column is relevance, and relevance is not in your data. The tool can prove that "steel" appears in fourteen search terms, cost you $180 and never converted. It cannot know whether you sell steel products. A tool that skips that step and hands you an export is guessing on your behalf with your traffic — so this one proposes, shows its working, and waits for you to tick the box.
What is the "safer bigram" suggestion?
When a word has converting terms behind it, blocking the whole word costs you those sales. So the tool looks only at the non-converting terms containing that word, finds the two-word phrase carrying the most of that waste, and then checks that phrase against every converting term to confirm it appears in none of them. If one qualifies, you get a targeted negative that removes the waste and leaves the working traffic alone.
Why negative phrase and not negative exact?
Negative exact blocks precisely one search term — useful for surgical removals, useless for a pattern. Negative phrase blocks any search term containing your words in order, which is exactly what word-level analysis is for: one entry removes every current variation and every future one. Note that Amazon does not support negative broad match at all, despite how often people assume it does — phrase and exact are your only options.
Why are "for" and "and" hidden?
Because they appear in a large share of all search terms, so they accumulate enormous spend and look like your biggest waste candidates — and blocking one would remove most of your traffic overnight. They carry no information about relevance. The toggle is left visible rather than the filter being silent, so you can see the decision was made and reverse it if you want to inspect them.
Why are my ASIN search terms missing?
Because an ASIN is not language. Breaking b0dd8bstkd into words produces a meaningless token that would sit in your counts as though it were a real pattern. They are excluded, and the count and spend are shown separately so you know how much was set aside. If ASIN traffic is wasting money, the fix is a negative product target rather than a negative keyword — a different entity, handled in the Keyword Harvester.
How much data do I need?
Sixty to ninety days, and roughly $500 a month of search term spend as a floor. The whole method depends on a pattern being distinguishable from coincidence, and below that threshold a word appearing in two or three terms can look like a trend when it is noise. The tool shows the appearance count on every row and warns you when your overall volume is thin, so you can weight the evidence accordingly rather than trusting every row equally.
How often should I run this?
On day one with any new or inherited account — that is where the biggest single cleanup lives. Then monthly for the first three months while new campaigns generate new patterns, and quarterly once things settle. Also two to four weeks after any major launch or restructure, since new campaigns bring new kinds of irrelevant traffic with them.
Is my data uploaded anywhere?
No. Every file is read by JavaScript in your browser and discarded when you close the tab. There is no server and no account. Load the page, disconnect from the internet, and everything still works.
Go Deeper

Related Guides & Tools

Want the whole search term report worked properly?

Finding the pattern takes a tool. Deciding which patterns are irrelevant to your catalogue takes someone who knows your products.