GAQL waste finder: four queries for the spend that earns nothing
A pack of read-only Google Ads queries that surface search terms, keywords, placements and whole campaigns taking budget while returning no conversions.
Filed under
Wasted Spend
Every Vault entry filed under Wasted Spend, across every shelf.
Geo Waste Finder: the locations quietly spending your budget with nothing to show
A read-only Google Ads Script that ranks every location by spend against conversions, writes the worst offenders to a Sheet and optionally emails the wasted-spend list.
Search term clusterer: themes, spend totals and a keep, negate or watch verdict
Paste a search terms export and get themed clusters with spend totals, a verdict per cluster, proposed negatives with match types, and the assumptions the model made to get there.
Search Terms N-gram Auditor: find the wasteful words hiding across your queries
A read-only Google Ads Script that breaks 30 days of search terms into one, two and three word n-grams, ranks the spend that converts nothing, and writes the full table to a Google Sheet.
Shabba's Placement Exclusions script: cleaning junk placements across PMax and Demand Gen
A free, open-source Google Ads Script that scans placements across Display, Performance Max and Demand Gen and semi-automates excluding the junk, from a maintainer still shipping in 2026.
The Tuesday Briefing
One editor-curated email. The updates that matter, the noise filtered out.
Free. Occasionally includes sponsored messages from our partners. Unsubscribe anytime.