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.
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:
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:
Individually, none may look disastrous. But aggregating the word“cheap” reveals:
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.
2-gram
Two-word combinations add context and are often more actionable.
3-gram
Three-word phrases are more specific. They can reveal valuable long-tail themes, but naturally appear less often.
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
- Open the relevant Google Ads account.
- Navigate to Search terms.
- Select the date range you want to analyze.
- Include the performance columns relevant to your analysis.
- Download the report as CSV or TSV.
Useful columns normally include:
- Search term
- Impressions
- Clicks
- Cost
- Conversions
- Conversion value
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-Gram | Occurrences | Spend | Conversions | CPA |
|---|---|---|---|---|
| cheap | 42 | $620 | 3 | $206.67 |
| wholesale | 85 | $1,480 | 31 | $47.74 |
| free | 28 | $390 | 0 | — |
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.
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
- Export your Search Terms report.Use enough history to represent meaningful account behavior.
- Analyze 1–3 word N-grams.Start broad, then investigate more specific phrases.
- Sort by spend.Find where budget is concentrated.
- Review zero-conversion patterns.These can expose wasted spend quickly.
- Review conversion and ROAS leaders.Look for themes worth expanding.
- Check sample size.Don't make decisions from a tiny number of occurrences.
- Return to the original search terms.Understand the context before changing targeting.
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.