Device Waste Watchlist
Flags device segments (mobile/desktop/tablet) with meaningful spend and weak conversion return for schedule/bid optimization.
Script Code
Quickly shows where device-level spend is underperforming so teams can adjust bid modifiers and landing page priorities.
Preview is public. Unlock full code with name and email.
/**
* ==========================================================
* Device Waste Watchlist
* ==========================================================
* Description: Flags costly low-converting device segments
* for optimization review.
*
* Copyright (c) 2026 TwoSquares. All Rights Reserved.
* Developed by Kiril Ivanov
*/
function main() {
var SPREADSHEET_URL = "";
var SHEET_NAME = "Device Waste";
var LOOKBACK_DAYS = 30;
// ... preview shortened
}About This Script
Device Waste Watchlist breaks campaign performance by device and highlights costly segments that are not converting well. It is useful for accounts where mobile and desktop behavior differs significantly.
The script applies practical click/cost/conversion thresholds and outputs a ranked watchlist. This helps prioritize bid adjustments, device-specific UX fixes, and campaign segmentation decisions.
Spreadsheet output follows your standard: blank URL auto-creates a sheet; provided URL writes to that file and creates missing tab.
Implementation Notes
- Set LOOKBACK_DAYS, MIN_CLICKS, MIN_COST, and MAX_CONVERSIONS.
- Run once manually to tune thresholds for account scale.
- Review top rows and apply bid modifiers or campaign splits.
- Schedule weekly to maintain device-level efficiency.
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.
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.
Keyword Zero-Conversion Cost Watchlist
Flags enabled keywords with meaningful spend and zero conversions, with optional auto-created sheet logging.
Device Waste Watchlist FAQs
Common setup, usage, and troubleshooting questions for this script.