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.
Aggregates performance at the word level, where the waste actually hides.
Any search term export works — the standalone report or the one inside your bulk file.
Standalone Search Term report, or a bulk file with its search term sheet — .csv or .xlsx
Building n-grams…
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.
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.
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.
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.
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.
Aggregation finds the candidates. The guard is what makes them safe to act on.
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.
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.
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.
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.
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.
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.
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.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.The full method, the decision framework, and the case studies this tool implements.
Read the guide → ToolThe other half of a search term report — what to promote rather than what to block.
Open the tool → GuideWhere negatives belong, and why over-negating does more damage than over-harvesting.
Read the guide → ToolFor the words that convert badly rather than irrelevantly — the bid lever, not the block.
Open the tool → GuideWhere search term work sits in a full account review.
Read the guide → AllThe full set, grouped by the stage of work they belong to.
Browse tools →Finding the pattern takes a tool. Deciding which patterns are irrelevant to your catalogue takes someone who knows your products.