Campaign Spend Spike Monitor
Detects campaigns with unusual week-over-week spend spikes and low conversion support, helping catch waste quickly.
Script Code
Useful daily/weekly guardrail for sudden spend increases that are not translating into conversion growth.
Preview is public. Unlock full code with name and email.
/**
* ==========================================================
* Campaign Spend Spike Monitor
* ==========================================================
* Description: Flags campaigns with significant spend spikes
* versus prior week.
*
* Copyright (c) 2026 TwoSquares. All Rights Reserved.
* Developed by Kiril Ivanov
*/
function main() {
var SPREADSHEET_URL = "";
var SHEET_NAME = "Spend Spike Monitor";
var MIN_RECENT_COST = 50;
// ... preview shortened
}About This Script
Campaign Spend Spike Monitor compares last 7 days spend against prior 7 days and flags campaigns with sharp increases. It helps identify budget leakage, targeting drift, or auction changes before they materially impact performance.
The script includes conversion context and growth percentages to separate healthy scale-up from risky overspend.
Like your other scripts, sheet output is resilient: blank URL creates a new spreadsheet; provided URL writes to existing spreadsheet and creates the tab if needed.
Implementation Notes
- Set MIN_RECENT_COST and MIN_SPIKE_PERCENT for your account scale.
- Run manually and tune thresholds to avoid low-volume noise.
- Review flagged campaigns for query shifts, targeting expansion, and budget/bid changes.
- Schedule daily or 3x weekly for anomaly detection.
More Scripts In This Library
Conversion Drop Detector
Compares last 7 days vs prior 7 days by campaign to flag significant conversion drops, with sheet output.
Account Anomaly Detector
Compares today’s account performance against the same weekday across previous weeks and alerts when impressions, clicks, conversions, or cost move outside expected bounds.
Broken Final URL Checker
Checks enabled ad and keyword final URLs for 4xx/5xx errors, with optional sheet logging and daily alerting.
Campaign Budget Limited Monitor
Surfaces enabled Search campaigns losing impression share due to budget, with optional sheet output and alerting.
Campaign Spend Spike Monitor FAQs
Common setup, usage, and troubleshooting questions for this script.