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 |
