Free tool
N-Gram Analysis Of Google Ads Search Terms
Paste the search terms report exported from Google Ads, or a plain list of searches: the tool splits each search into single words, pairs and trios of words (the n-grams), adds up the impressions, clicks, cost, conversions and conversion value of every search that contains each one, and flags those that spend with no conversions. You leave with a negative keyword list, ready to paste.
According to Google, the search terms report holds data on the search terms used by a significant number of people that triggered impressions and clicks; some search terms without enough query activity are omitted, in keeping with its data privacy standards. On the exclusion side, negative keywords don’t match close variants, synonyms, or singular and plural versions; they automatically account for casing and misspellings, and a negative keyword with accent marks and the same one without count as 2 different negative keywords.
Click a header to sort. Check or uncheck a row to build your list. A flagged n-gram is checked by default, unless it would block searches that converted or a shorter checked negative already covers it.
Before you add your list: negative keywords don’t cover synonyms, singular or plural versions, or close variants, so add them yourself if you want them excluded; Google accounts for casing and misspellings. A negative with accent marks and the same one without count as 2 negatives, so the tool lists every spelling found in your report. A search longer than 16 words can still show your ad if the negative comes after the 16th word. To compare the behaviors: Google Ads match types.
Sources read on November 6, 2026: Google Ads Help, search terms report, Google Ads Help, negative keywords, Google Ads Help, negative keyword ideas, Google Ads Help, conversion goals and Google Ads API, metrics.
Are Your Search Terms Spending With No Conversions?
In an audit of your Google Ads account, I cross-check your search terms with your keywords, your match types and your conversions, then tell you what to exclude and what to change first.
20 minutes · No commitment · 100% confidential
How The Tool Adds Up Each N-Gram
N-gram cost = sum of the cost of the searches that contain it; flagged for exclusion if conversions = 0 and cost ≥ threshold
The tool reads the Search term column, then impressions, clicks, cost, conversions and conversion value; it never takes the term from a Keyword, Match type or Campaign column, and it skips total rows. Each search is lowercased and stripped of punctuation (an apostrophe inside a word and digits stay), then split into n-grams. Grouping uses the form without accent marks, and the table keeps every spelling. Ratios follow Google’s definitions: CTR = clicks ÷ impressions, average CPC = cost ÷ clicks, cost per conversion = cost ÷ conversions, ROAS = conversion value ÷ cost; the conversion rate is computed on clicks. For a single figure: CTR calculator, CPC calculator or ROAS calculator.
Example: “used hiking boots” costs $18 and “used trekking poles” $14, with no conversions. The n-gram “used” adds up both searches: $32, 0 conversions. If your report totals $240 for 20 conversions, the average cost per conversion is $12: with $32 and no conversions, “used” passes that threshold and gets flagged for exclusion. The n-gram “hiking” also adds up searches that convert: it isn’t flagged.
Before it checks a negative, the tool looks for the searches that converted and that it would block in the chosen match type: it lists them and leaves the box unchecked, so the call is yours. An n-gram already covered by a shorter checked negative stays unchecked, to avoid duplicates. The list comes out in broad match, "phrase match" or [exact match]. The tool starts with phrase match, because it blocks the searches added up on the n-gram’s row; Google itself adds a negative created from the search terms report as exact match by default. To review the three behaviors: Google Ads match types.
What N-Gram Analysis Gives You
- Cut cost with no conversions: switch to the “To exclude” filter, and the n-grams that spent beyond your threshold with no conversions come up, sorted by cost. You know which words to exclude first.
- Understand intent: switch to 2 or 3 words to see the phrasings that convert and the ones that aren’t looking for what you sell. To turn the good ones into keywords, the keyword wrapper puts them in the format you need.
- Complete a negative keyword list: copy the checked n-grams in the match type you want, with no duplicates. To build a starting list by theme, open the negative keyword list generator. You exclude based on your own numbers.
Frequently asked questions
Which Google Ads report should I paste?
The search terms report: in Google Ads, select Campaigns in the left navigation panel, go to Search terms within the Insights and reports sub-menu, and export it with the Download button. Paste the CSV or copy the table from a spreadsheet, headers included: the tool reads column names in English, French and Spanish, skips title and total rows, and adds up the rows of a same search, for example when it appears in two ad groups.
Why are some searches missing from my report?
Google states that some search terms that don’t have enough query activity are omitted from the search terms report, in keeping with its data privacy standards. The tool analyzes the rows your report contains, and doesn’t make up the missing ones.
Which match type should I pick for my negatives?
Phrase match blocks any search that contains the n-gram, words in the same order: those are the searches added up on its row. Broad match blocks any search that contains its words in any order, and the tool then checks what else it would block. Exact match only blocks the identical search; it’s the type Google applies by default when you add a negative from the search terms report.
Is my report sent anywhere?
No. The analysis runs in your browser: nothing is uploaded or stored, and the report is gone when you close the page.


