Search Term Waste Finder
Finds high-cost, non-converting search terms, prioritizes them by wasted spend, and can send an optimization digest by email.
Script Code
Use this as weekly or daily search-term hygiene to cut waste fast and build a focused negative-keyword review queue.
Preview is public. Unlock full code with name and email.
/**
* ==========================================================
* Search Term Waste Finder
* ==========================================================
* Description: Finds expensive search terms with no
* conversions so you can review negative keyword candidates.
*
* Copyright (c) 2026 TwoSquares. All Rights Reserved.
* Developed by Kiril Ivanov
*/
function main() {
var LOOKBACK_DAYS = 30;
var MIN_IMPRESSIONS = 100;
var MIN_CLICKS = 20;
var MIN_COST = 25;
var MAX_CONVERSIONS = 0;
var MAX_ROWS_IN_EMAIL = 75;
var SEND_EMAIL_ALERTS = false;
var ALERT_EMAIL = "[email protected]";
// ... preview shortened
}About This Script
Search Term Waste Finder is a production-ready Google Ads Script for identifying search terms that spend meaningful budget without generating conversions. It is built for accounts where query drift and broad traffic can quietly reduce efficiency.
The script applies operational thresholds for impressions, clicks, and spend, then ranks findings by wasted cost so teams can act in priority order. This turns noisy query exports into a focused optimization list.
For recurring workflows, the script can send an email digest containing top waste terms after each run. Combined with weekly negative-keyword reviews, this helps keep accounts tighter, cleaner, and more cost-efficient over time.
Implementation Notes
- Configure LOOKBACK_DAYS, MIN_IMPRESSIONS, MIN_CLICKS, and MIN_COST for account scale.
- Run manually once and inspect the ranked output for relevance and intent.
- Optionally enable SEND_EMAIL_ALERTS and set ALERT_EMAIL for automated reporting.
- Convert qualified rows into ad group or campaign-level negatives after human review.
- Track trend lines over time: total wasted cost flagged, count of recurring terms, and post-fix CPA/CVR movement.
More Scripts In This Library
Previous Script
Search Term N-Gram Waste Finder
Next Script
Single Account UTM Tracking Template Updater
Negative Keyword Conflict Checker
Flags potential conflicts where converting search terms may be blocked or constrained by existing negative keywords.
Search Term N-Gram Waste Finder
Aggregates expensive non-converting n-grams from search terms to speed up negative keyword decisions.
Day-of-Week Waste Finder
Flags costly low-converting weekday segments by campaign so you can tighten ad schedules and bid strategies.
Device Waste Watchlist
Flags device segments (mobile/desktop/tablet) with meaningful spend and weak conversion return for schedule/bid optimization.
Search Term Waste Finder FAQs
Common setup, usage, and troubleshooting questions for this script.