Does this automatically pause keywords?

No. It produces a review-first watchlist so you can evaluate intent and business context before action.

Will it create a spreadsheet automatically?

Yes. Leave SPREADSHEET_URL blank and it creates a new spreadsheet, then logs the URL in execution logs.

Back to scripts

Keyword Zero-Conversion Cost Watchlist

Flags enabled keywords with meaningful spend and zero conversions, with optional auto-created sheet logging.

keywordscost-controlwatchlist

Script Code

Simple ongoing script to keep expensive non-converting keywords visible before they drain monthly budget.

Preview is public. Unlock full code with name and email.

/**
 * ==========================================================
 * Keyword Zero-Conversion Cost Watchlist
 * ==========================================================
 * Description: Flags costly enabled keywords with zero
 * conversions and writes a ranked watchlist.
 *
 * Copyright (c) 2026 TwoSquares. All Rights Reserved.
 * Developed by Kiril Ivanov
 */
function main() {
  var SPREADSHEET_URL = "";
  var SHEET_NAME = "Keyword Cost Watchlist";
  var LOOKBACK_DAYS = 30;
  // ... preview shortened
}

About This Script

Keyword Zero-Conversion Cost Watchlist identifies active keywords consuming spend without conversions and ranks them by cost impact. It is a practical guardrail for accounts where keyword bloat can quietly erode CPA targets.

Instead of manually scanning large keyword tables, the script filters for financially meaningful rows using customizable thresholds and outputs a focused watchlist for weekly actions.

Spreadsheet handling is resilient by design: blank URL creates a new sheet automatically; provided URL writes to that file and creates the tab if missing.

Implementation Notes

Set MIN_COST and MIN_CLICKS to match your account economics.
Set SPREADSHEET_URL blank for auto-create, or provide an existing sheet URL.
Run manually first and verify threshold quality.
Schedule daily/weekly and review top rows before pausing or restructuring.

More Scripts In This Library

Previous Script

Keyword Quality Score Risk Watchlist

Next Script

Landing Page Domain Checker

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.

Geo Waste Watchlist

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

Hour-of-Day Waste Finder

Finds costly non-converting hours using segments.hour to support ad schedule optimization, with optional sheet output.