Geo Waste Watchlist
Flags high-cost, low-conversion locations so you can tighten geo targeting and bid strategy.
Script Code
Useful weekly monitor for spotting regions that consume budget without delivering proportional results.
Preview is public. Unlock full code with name and email.
/**
* ==========================================================
* Geo Waste Watchlist
* ==========================================================
* Description: Flags costly low-conversion geographies for
* location targeting optimization.
*
* Copyright (c) 2026 TwoSquares. All Rights Reserved.
* Developed by Kiril Ivanov
*/
function main() {
var SPREADSHEET_URL = "";
var SHEET_NAME = "Geo Waste";
var LOOKBACK_DAYS = 30;
// ... preview shortened
}About This Script
Geo Waste Watchlist segments campaign performance by location and highlights costly areas with weak conversion return.
It helps teams prioritize location bid adjustments, exclusions, and landing-page localization opportunities.
Sheet behavior follows your standard: blank URL auto-creates output sheet, while provided URL writes to existing file and creates tab when missing.
Implementation Notes
- Set LOOKBACK_DAYS, MIN_CLICKS, MIN_COST, and MAX_CONVERSIONS.
- Run once manually and validate threshold quality.
- Review top waste geos and apply location-level bid/exclusion changes.
- Schedule weekly for ongoing regional efficiency control.
More Scripts In This Library
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.
Hour-of-Day Waste Finder
Finds costly non-converting hours using segments.hour to support ad schedule optimization, with optional sheet output.
Keyword Zero-Conversion Cost Watchlist
Flags enabled keywords with meaningful spend and zero conversions, with optional auto-created sheet logging.
Geo Waste Watchlist FAQs
Common setup, usage, and troubleshooting questions for this script.