Hour-of-Day Waste Finder
Finds costly non-converting hours using segments.hour to support ad schedule optimization, with optional sheet output.
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
}About This 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.
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.
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.
Hour-of-Day Waste Finder FAQs
Common setup, usage, and troubleshooting questions for this script.