Conversion Drop Detector
Compares last 7 days vs prior 7 days by campaign to flag significant conversion drops, with sheet output.
Script Code
Simple weekly health-check that catches conversion declines early so teams can investigate before bigger losses.
Preview is public. Unlock full code with name and email.
/**
* ==========================================================
* Conversion Drop Detector
* ==========================================================
* Description: Compares last 7 days vs prior 7 days and flags
* campaigns with significant conversion declines.
*
* Copyright (c) 2026 TwoSquares. All Rights Reserved.
* Developed by Kiril Ivanov
*/
function main() {
var SPREADSHEET_URL = "";
var SHEET_NAME = "Conversion Drop Detector";
var MIN_PREV_CONVERSIONS = 3;
// ... preview shortened
}About This Script
Conversion Drop Detector compares campaign conversion volume between the last 7 days and the previous 7 days. It highlights statistically meaningful drops so teams can react faster to broken tracking, creative fatigue, auction shifts, or site issues.
The script calculates drop percent and includes spend context for both windows to avoid overreacting to low-volume noise.
It writes outputs to Google Sheets with the same resilient behavior: blank URL creates a new sheet, provided URL writes into existing sheet and creates missing tab.
Implementation Notes
- Set MIN_PREV_CONVERSIONS and MIN_DROP_PERCENT to reduce false positives.
- Leave SPREADSHEET_URL blank to auto-create, or provide an existing URL.
- Run manually first to verify signal quality for your account size.
- Schedule daily or 2-3x weekly for early decline detection.
More Scripts In This Library
Campaign Spend Spike Monitor
Detects campaigns with unusual week-over-week spend spikes and low conversion support, helping catch waste quickly.
Conversion Action Mix Anomaly Monitor
Monitors conversion action distribution shifts to detect sudden tracking or intent-mix anomalies.
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.
Conversion Drop Detector FAQs
Common setup, usage, and troubleshooting questions for this script.