Week-over-Week Query Growth Waste Alert
Detects search terms whose spend is growing week-over-week while conversions remain weak or zero.
Script Code
Great early-warning script for catching emerging waste before it compounds.
Preview is public. Unlock full code with name and email.
/**
* ==========================================================
* Week-over-Week Query Growth Waste Alert
* ==========================================================
* Description: Finds search terms with rising spend and weak
* conversion performance versus prior week.
*
* Copyright (c) 2026 TwoSquares. All Rights Reserved.
* Developed by Kiril Ivanov
*/
function main() {
var SPREADSHEET_URL = "";
var SHEET_NAME = "WoW Query Waste";
var MIN_RECENT_COST = 20;
// ... preview shortened
}About This Script
Week-over-Week Query Growth Waste Alert compares recent query spend against the prior week and flags terms growing in cost without sufficient conversion return. It is designed as an early warning layer for accounts with dynamic query patterns.
The script computes growth rates and absolute spend deltas so you can prioritize terms that are both worsening and financially meaningful.
Sheet output uses your standard resilient behavior: auto-create when URL is blank, write/create tab when URL is provided.
Implementation Notes
- Set MIN_RECENT_COST and MIN_GROWTH_PERCENT to control signal quality.
- Run manually and validate top terms before negative changes.
- Use findings for negatives, match-type tightening, or ad-group refinements.
- Schedule weekly for continuous trend monitoring.
More Scripts In This Library
Previous Script
Single Account UTM Tracking Template Updater
Next Script
YouTube Channel Exclusion Audit And Blocker
Duplicate Query Conflict Finder
Finds search terms appearing across multiple campaigns/ad groups so you can reduce overlap and cannibalization.
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.
Search Term Waste Finder
Finds high-cost, non-converting search terms, prioritizes them by wasted spend, and can send an optimization digest by email.
Week-over-Week Query Growth Waste Alert FAQs
Common setup, usage, and troubleshooting questions for this script.