spyc.ai

Free tool

Search Terms N-Gram Analyzer

Break a search terms report into 1, 2 and 3-word phrases with cost, conversions and CPA to find wasted spend.

How it works

What is the Search Terms N-Gram Analyzer?

The Search Terms N-Gram Analyzer is a free tool that breaks a Google Ads search terms report into one, two and three-word phrases. It sums clicks, impressions, cost and conversions for each phrase, calculates CPA and conversion rate, and highlights phrases that spent money without converting so you can review them as negative keywords.

How to use the Search Terms N-Gram Analyzer

  1. Download the search terms report from Google Ads as a CSV, with clicks, impressions, cost and conversions.
  2. Paste the CSV, including its header row, into the box.
  3. Switch between 1-grams, 2-grams and 3-grams and click a column heading to sort.
  4. Review the highlighted rows and add the ones that are truly irrelevant as negative keywords.

What is n-gram analysis in Google Ads?

An n-gram is a sequence of n words. N-gram analysis splits every search term into its single words, word pairs and word triples, then adds up the performance of every search term that contains each one.

A search terms report has thousands of rows that each got a click or two, and no single row tells you much. Grouped by n-gram, patterns appear: a word like free or jobs may have taken real spend across hundreds of different searches.

How does this tool calculate the n-gram table?

It reads the header row to find the Search term, Clicks, Impr. or Impressions, Cost and Conversions columns, in any order, and skips total rows. Each search term is lowercased and split into words. Every distinct n-gram in a term receives that term's full clicks, impressions, cost and conversions, counted once per term.

CPA is cost divided by conversions. Conversion rate is conversions divided by clicks. Because one search term feeds several n-grams, the rows do not add up to the account total, and they are not meant to.

How do I find negative keywords with n-grams?

Sort by cost and look at the highlighted rows, which have spend and zero conversions. Ask whether the word or phrase signals the wrong intent. If it does, add it as a negative. If it is a relevant word that simply has not converted yet, leave it.

One-word n-grams find broad themes. Two and three-word n-grams are safer to act on, because they are more specific. Format the negatives with the Keyword Match Type Formatter and clean the list with the Negative Keyword Deduplicator.

How much spend with no conversions is enough to act on?

There is no universal number. A highlighted row is a candidate, not a verdict. A phrase that spent a fraction of your normal cost per conversion has not had a fair chance to convert, so zero conversions means little.

A common rule of thumb is to look harder once a phrase has spent more than your target CPA with nothing to show for it. Even then, relevance matters more than the number: do not block a phrase that describes what you sell.

Which export format does the analyzer accept?

Comma-separated text, or rows pasted straight from a spreadsheet, which arrive tab-separated. Title lines above the header row are ignored. Currency symbols and thousands separators are stripped from numbers. Numbers written with a decimal comma, such as 12,50, are not supported, so export with a decimal point.

The table shows the first 200 rows in the current sort order. To tag landing page URLs so conversions are attributed cleanly in analytics, use the UTM Builder.

Questions

What is a 2-gram?
A pair of words that appear next to each other in a search term. The search trail running shoes contains two 2-grams: trail running and running shoes.
Why do the n-gram totals exceed my account totals?
Each search term contributes its numbers to every n-gram it contains. A four-word search adds its cost to four 1-grams, so summing the table double counts by design.
Does the tool need conversion data?
It needs a Search term column. Any metric column it cannot find is counted as zero and named in a warning, so without conversions the highlighting is not meaningful.
Can I use reports from Microsoft Advertising?
Yes, if the header row uses names the tool recognises: Search term, Clicks, Impressions, Spend or Cost, and Conversions. Rename the headers if yours differ.
Is the Search Terms N-Gram Analyzer free?
Yes, with a free spyc.ai account. It runs entirely in your browser, so nothing you type or paste is sent to a server.

Paid Ads Tools

More in Paid Ads Tools

Keyword Match Type Formatter

Turn a keyword list into broad, phrase and exact match syntax for Google Ads, cleaned and deduplicated.

Format keywords

Negative Keyword Deduplicator

Remove duplicate negative keywords and ones a broader negative already covers, with a reason for each removal.

Clean list

Responsive Search Ad Preview

Draft responsive search ad headlines and descriptions with live character limits and example combinations.

Preview ad

Ready when you are

Before your next buyer asks AI about you, ask AI about yourself

One check, four engines, about twenty seconds. We show you the answers before we ask for anything.