Day-of-Week Waste Finder
Flags costly low-converting weekday segments by campaign so you can tighten ad schedules and bid strategies.
Script code
Simple weekly script to spot expensive weekdays with poor conversion return.
Preview is public. Unlock full code with name and email.
/**
* ==========================================================
* Day-of-Week Waste Finder
* ==========================================================
* Description: Flags expensive weekday segments with low/no
* conversions to support schedule optimization.
*
* Copyright (c) 2026 TwoSquares. All Rights Reserved.
* Developed by Kiril Ivanov
*/
function main() {
var SPREADSHEET_URL = "";
var SHEET_NAME = "Day of Week Waste";
var LOOKBACK_DAYS = 30;
// ... preview shortened
}За този script
Day-of-Week Waste Finder breaks campaign performance down by weekday and highlights segments where spend accumulates without enough conversions. It is useful for accounts running broad schedules that are rarely reviewed.
The script applies configurable spend and click thresholds and ranks rows by cost impact so you can prioritize schedule adjustments quickly.
Spreadsheet behavior follows your standard: blank URL auto-creates a spreadsheet; provided URL writes to existing file and creates the sheet tab if missing.
Implementation notes
- Set LOOKBACK_DAYS, MIN_CLICKS, MIN_COST, and MAX_CONVERSIONS.
- Run once manually and review top waste weekdays by campaign.
- Adjust ad schedules or bid modifiers based on persistent patterns.
- Schedule weekly for ongoing dayparting hygiene.
Още scripts в библиотеката
Hour-of-Day Waste Finder
Finds costly non-converting hours using segments.hour to support ad schedule optimization, with optional sheet output.
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 Zero-Conversion Cost Watchlist
Flags enabled keywords with meaningful spend and zero conversions, with optional auto-created sheet logging.
Day-of-Week Waste Finder FAQs
Чести setup, usage и troubleshooting въпроси за този script.