Report tool
Amazon PPC n-gram analyzer
Drop in your search term report to add up spend, clicks and orders for every word and phrase across all your searches, and spot the ones that never lead to an order.
- Free, no sign-up
- Your file stays in your browser
Drop your search term report here
XLSX or CSV, straight from the Amazon Ads console.
Your report is read by your browser and never uploaded. Close the tab and it's gone.
A search term needs both minimums before it's listed. Set one to 0 to skip it. With a target ACoS, converting terms at 2x your target or more are listed too.
Next step
Run this check without the export
A downloaded report is one date range, frozen. In Merch Jar your search term data stays connected, so you can run the same review on any date range without exporting anything.
- N-Grams and the Search Terms page
- N-Grams shows the same one, two and three word breakdown for your connected account, on any date range. When you find a term to block, add it as a negative exact or phrase keyword from the Search Terms page.
- The Search Term Waste Elimination template
- This Library template checks your search terms every day against the click and spend minimums you set, with safeguards for terms that sell. It's saved disabled. You review the matches, and it only adds negative exact keywords after you enable it. If you use the Copilot, your AI can help you pick the settings and preview the matches first.
How to run an n-gram analysis on your report
- 1In the Amazon Ads console, open Reporting and download a report from the Search term template. XLSX and CSV both load, daily or summary.
- 2Cover 30 to 60 days rather than a week. More days give each word more data.
- 3Drop it in above. Your file never leaves your browser. The analysis runs on your device, with no account or upload.
- 4It opens on the words and phrases table. For a full walkthrough of the report itself, read how to read an Amazon search term report.
FAQ
What an n-gram analysis shows
An n-gram is a run of words inside a search. "hedge" is a one-word n-gram and "hedge trimmer" is a two-word one. A search term report lists every search on its own row, so ten cheap searches that share a losing word each look too small to bother with.
Adding them up by word shows the pattern. In the sample, no single hedge search spent more than $47.15, but the four searches containing "hedge" spent $126.40 over 113 clicks without an order.
How to read the words and phrases table
Each row adds up every search term containing that word or phrase. The 1, 2 and 3 word buttons switch the phrase length, and "Show terms" opens the searches behind a row, sellers first.
A row is marked as a phrase negative candidate when no search containing it has an order, it appears in at least two searches, and it reached your minimum clicks and spend. Common words like "for" and "with" are never marked on their own.
Check the orders column before you act on anything. "shears" turns up in plenty of losing searches, like "hedge shears" and "grass shears", but it's also in "pruning shears", the best seller in the sample. A phrase negative on "shears" would block that too, which is why it isn't marked.
From an n-gram to a negative phrase keyword
A negative phrase keyword blocks any search that contains the phrase in that order, including close variants like plurals. So pick the shortest phrase that only matches losing searches. In the sample, "kitchen" works on its own because both kitchen searches lost money. "scissors" doesn't, because "garden scissors" sold.
Keep your brand and product names out of phrase negatives, even when one version of them underperforms.
When you want single searches with their campaign and ad group instead, the negative keyword finder opens the same tool on the search terms list.