Google Ads Guide

Google Ads N-Gram Analysis: Find Wasted Spend in Search Terms

Search term reports can contain hundreds or thousands of queries. Reviewing them one-by-one makes it easy to miss recurring words and phrases that are quietly driving spend, conversions or poor performance. N-gram analysis helps surface those patterns.

Google AdsSearch TermsN-Gram Analysis~8 min read
Try our Search Term Ngram Analyzer →

What is N-gram analysis?

An N-gram is simply a sequence of words extracted from a search query.

Take this Google Ads search term:

cheap running shoes for men

A one-word analysis might identify:

  • cheap
  • running
  • shoes
  • men

A two-word analysis could identify:

  • cheap running
  • running shoes
  • shoes men

Instead of evaluating that query in isolation, N-gram analysis combines performance data from every search term containing the same word or phrase.

That lets you answer questions such as:

  • Which words repeatedly consume budget without generating conversions?
  • Which phrases appear frequently in high-value searches?
  • Are certain themes producing unusually strong CPA or ROAS?
  • Which query patterns account for a significant share of total search-term spend?

Why use N-gram analysis in Google Ads?

A normal Search Terms report is organized around complete queries. The problem is that poor or strong performance often comes from a pattern shared by many different queries.

Imagine these search terms:

cheap running shoes$120 spend · 1 conversion
cheap trainers online$90 spend · 0 conversions
cheap men's running shoes$140 spend · 1 conversion

Individually, none may look disastrous. But aggregating the word“cheap” reveals:

Total spend$350Conversions2CPA$175

That pattern is much easier to recognize when the queries are aggregated.

1-gram vs 2-gram vs 3-gram analysis

1-gram

One-word N-grams are best for discovering broad themes such as locations, product types, modifiers or intent signals.

cheap · free · wholesale · jobs · near

2-gram

Two-word combinations add context and are often more actionable.

wholesale clothing · running shoes · free trial

3-gram

Three-word phrases are more specific. They can reveal valuable long-tail themes, but naturally appear less often.

wholesale clothing suppliers · running shoes men

There is no universally best N-gram length. In most account reviews, analyzing one through three words together provides a useful balance between broad patterns and specific intent.

How to export your Google Ads Search Terms report

  1. Open the relevant Google Ads account.
  2. Navigate to Search terms.
  3. Select the date range you want to analyze.
  4. Include the performance columns relevant to your analysis.
  5. Download the report as CSV or TSV.

Useful columns normally include:

  • Search term
  • Impressions
  • Clicks
  • Cost
  • Conversions
  • Conversion value
Tip

Your date range matters. A seven-day report may be useful for detecting something urgent, while a 30–90 day report is often more suitable for identifying durable search patterns.

Which N-gram metrics actually matter?

Zero-conversion spend

Useful for identifying recurring themes consuming meaningful budget without attributed conversions.

Conversions

Shows the words and phrases associated with the largest amount of conversion volume.

CPA

Helps compare acquisition efficiency across recurring search patterns.

ROAS

Useful when conversion value is available and revenue efficiency matters more than conversion count alone.

Spend share

Shows how much of the entire Search Terms report is concentrated around a particular word or phrase.

Occurrences

Indicates how frequently a pattern appears across distinct search term rows.

Example: identifying wasted spend

Imagine an ecommerce account where the following N-grams appear:

N-GramOccurrencesSpendConversionsCPA
cheap42$6203$206.67
wholesale85$1,48031$47.74
free28$3900

The word free immediately deserves investigation because it has consumed $390 without a conversion.

But wholesale appears much more frequently while generating conversions at a substantially lower CPA.

That could influence:

  • negative keyword decisions,
  • new exact or phrase-match keywords,
  • campaign segmentation,
  • landing page messaging,
  • ad copy themes,
  • budget allocation.

Don't automatically turn poor N-grams into negative keywords

N-gram analysis is evidence — not an automatic negative keyword generator.

A phrase showing poor performance may still need context.

Before excluding a pattern, consider:

  • the amount of data available,
  • conversion lag,
  • attribution differences,
  • match-type behavior,
  • brand versus non-brand intent,
  • whether the phrase is commercially relevant,
  • and whether one unusual query is distorting the aggregate.
Watch out for small samples

Ratio metrics can be misleading at tiny volumes. An N-gram with one conversion from one click may technically show an excellent conversion rate, but that doesn't automatically make it a reliable pattern.

A practical N-gram analysis workflow

  1. Export your Search Terms report.Use enough history to represent meaningful account behavior.
  2. Analyze 1–3 word N-grams.Start broad, then investigate more specific phrases.
  3. Sort by spend.Find where budget is concentrated.
  4. Review zero-conversion patterns.These can expose wasted spend quickly.
  5. Review conversion and ROAS leaders.Look for themes worth expanding.
  6. Check sample size.Don't make decisions from a tiny number of occurrences.
  7. Return to the original search terms.Understand the context before changing targeting.
Free PaidMediaKit Tool

Analyze your Google Ads Search Terms report

Upload your CSV or TSV report and automatically analyze recurring search patterns by spend, conversions, CPA, ROAS, frequency and spend share.

Open the N-Gram Analyzer →Your report is processed directly in your browser.