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.

TermImpClicksCostConv
running shoes5,400320$640.5012
running shoes for women2,800220$418.009
buy running shoes1,20090$180.008
nike running shoes1,500110$275.005
adidas running shoes1,10075$168.503
running shoes near me95055$90.202

Wasted spend (no conversions, ≥ 30 clicks)

3 terms · $461 spend · 0 conv.

Strong negative-keyword candidates. Add immediately at account level.

TermImpClicksCostConv
free running shoes2,100150$210.000
running shoes review3,200180$210.000
used running shoes42030$40.500

Low-intent terms (negative-keyword candidates)

3 terms · $461 spend · 0 conv.

Common low-intent modifiers. Block as broad negatives unless intentional.

TermImpClicksCostConv
free running shoes2,100150$210.000
running shoes review3,200180$210.000
used running shoes42030$40.500

Expensive converters (>1.5× avg CPA)

1 terms · $156 spend · 1 conv.

Consider lower bid adjustments or move to broader match for cheaper auctions.

TermImpClicksCostConv
cheap running shoes1,800120$156.001

Want this on autopilot?

We build weekly search-term review pipelines into Looker / Sheets — auto-flagging waste, surfacing winners, and pushing negatives to scripts.

INTERACTIVE DEMO Want to test how this tool works?
Save these results as a PDF report A clean, branded copy to share with your team or client.
Free PDF report

Where should we put your name on the report?

Your PDF downloads straight away. Your tool data never leaves your browser.

Jobair Mahmud, Web Analytics & Tracking Architect
Tool Creator

Jobair Mahmud

Founder & Tracking Architect

100% Top Rated
★★★★★
5.0 / 5.0

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.

Eliminate ad spend waste →

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

  1. Export your Search Terms report from Google Ads (CSV or tab-delimited).
  2. Paste or upload your query data into the analyzer.
  3. Review categorized term clusters sorted by cost, conversions, and CPA.
  4. 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.