Is this enough to set ad schedules automatically?

This script is a decision support tool. Use output with business context before changing schedules.

Does it work for all campaign types?

It uses campaign performance segments.hour and is most actionable for Search campaigns with controllable scheduling.

Обратно към scripts

Hour-of-Day Waste Finder

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

daypartingcost-controloptimization

Script code

Practical script to identify expensive hours and tighten ad schedules based on real waste patterns.

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

/**
 * ==========================================================
 * Hour-of-Day Waste Finder
 * ==========================================================
 * Description: Flags expensive hours with low/no conversion
 * to support ad schedule optimization.
 *
 * Copyright (c) 2026 TwoSquares. All Rights Reserved.
 * Developed by Kiril Ivanov
 */
function main() {
  var SPREADSHEET_URL = "";
  var SHEET_NAME = "Hour Waste";
  var LOOKBACK_DAYS = 30;
  // ... preview shortened
}

За този script

Hour-of-Day Waste Finder analyzes performance by hour and flags time slots where spend accumulates without enough conversion return. It is useful for accounts that run all-day schedules without consistent dayparting review.

The script ranks rows by cost impact and adds CTR/CVR context to support informed schedule decisions.

It follows your sheet rule: blank URL auto-creates a sheet, provided URL writes to existing spreadsheet and creates tab if needed.

Implementation notes

Set LOOKBACK_DAYS, MIN_CLICKS, MIN_COST, and MAX_CONVERSIONS.
Leave SPREADSHEET_URL blank for auto-create or set existing sheet URL.
Run once manually to validate thresholds.
Use results to adjust ad schedule bids or pause low-intent hours.

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

Предишен script

Google Ads Budget Tracker

Следващ script

Keyword Low-CTR Check

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.

Keyword Quality Score Risk Watchlist

Finds enabled keywords with low Quality Score and meaningful traffic to prioritize relevance and landing page fixes.