Search Query Report Analyzer
Drop in your Google Ads search-term CSV — get auto-grouped winners, wasted spend, low-intent terms, and a ready-to-paste negative keyword list.
Required columns: search term, impressions, clicks, cost, conversions. Header detection is forgiving.
Total spend
$2389
Avg CPA
$59.72
Negative candidates
3
Suggested negative keywords (3)
- free running shoes
- running shoes review
- used running shoes
Winners (convert below avg CPA)
6 terms · $1772 spend · 39 conv.Promote into exact-match keywords or tighten ad-group focus.
| Term | Imp | Clicks | Cost | Conv |
|---|---|---|---|---|
| running shoes | 5,400 | 320 | $640.50 | 12 |
| running shoes for women | 2,800 | 220 | $418.00 | 9 |
| buy running shoes | 1,200 | 90 | $180.00 | 8 |
| nike running shoes | 1,500 | 110 | $275.00 | 5 |
| adidas running shoes | 1,100 | 75 | $168.50 | 3 |
| running shoes near me | 950 | 55 | $90.20 | 2 |
Wasted spend (no conversions, ≥ 30 clicks)
3 terms · $461 spend · 0 conv.Strong negative-keyword candidates. Add immediately at account level.
| Term | Imp | Clicks | Cost | Conv |
|---|---|---|---|---|
| free running shoes | 2,100 | 150 | $210.00 | 0 |
| running shoes review | 3,200 | 180 | $210.00 | 0 |
| used running shoes | 420 | 30 | $40.50 | 0 |
Low-intent terms (negative-keyword candidates)
3 terms · $461 spend · 0 conv.Common low-intent modifiers. Block as broad negatives unless intentional.
| Term | Imp | Clicks | Cost | Conv |
|---|---|---|---|---|
| free running shoes | 2,100 | 150 | $210.00 | 0 |
| running shoes review | 3,200 | 180 | $210.00 | 0 |
| used running shoes | 420 | 30 | $40.50 | 0 |
Expensive converters (>1.5× avg CPA)
1 terms · $156 spend · 1 conv.Consider lower bid adjustments or move to broader match for cheaper auctions.
| Term | Imp | Clicks | Cost | Conv |
|---|---|---|---|---|
| cheap running shoes | 1,800 | 120 | $156.00 | 1 |
Try these next
Related tools you'll probably want
Tired of paying for useless Google clicks?
I perform exhaustive search term pruning and negative keyword architecture to ensure your budget only reaches qualified buyers.
How to use the Search Query Report (SQR) Analyzer
Google Ads search term reports contain valuable buyer queries alongside wasteful junk search terms. This tool analyzes SQR data to identify high-converting keyword opportunities to add as exact match, while isolating negative keyword candidates to stop ad spend waste.
Step by step
- Export your Search Terms report from Google Ads (CSV or tab-delimited).
- Paste or upload your query data into the analyzer.
- Review categorized term clusters sorted by cost, conversions, and CPA.
- Export high-performing terms for positive keyword creation and negative term candidates for immediate exclusion.
How to read your result
High-Intent Clusters Identified
Profitable search themes isolated; ready to break out into high-bid dedicated ad groups.
Wasteful Spend Isolated
Queries with high click spend and zero conversions identified for negative keyword exclusion.
Common mistakes
- Relying solely on Google automated recommendations instead of conducting manual SQR audits.
- Ignoring search queries with high impressions and low CTR that depress campaign Quality Scores.
- Adding negative keywords without checking if they conflict with existing high-converting search queries.
Questions
What percentage of Google search queries are new?
Google reports that approximately 15% of all searches conducted daily have never been seen before, making regular SQR analysis essential.
How often should an SQR audit be performed?
For high-spend accounts, weekly SQR reviews are recommended; for moderate spend, bi-weekly or monthly audits are standard.
Tired of paying for useless Google clicks?
I perform exhaustive search term pruning and negative keyword architecture to ensure your budget only reaches qualified buyers.