Does this script automatically exclude locations?

No. It is reporting-only and intended to support safe manual decision-making.

Is this country-level only?

It reports geo target constants returned in campaign geo view. Granularity depends on your account targeting and data volume.

Обратно към scripts

Geo Waste Watchlist

Flags high-cost, low-conversion locations so you can tighten geo targeting and bid strategy.

geotargetingcost-control

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
}

За този 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.

Още scripts в библиотеката

Предишен script

Final URL UTM Consistency Audit

Следващ script

Google Ads Budget Tracker

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.