Очистка мусорных плейсментов Display, PMax и YouTube

/**
 * Goodlabs Google Ads Script: Placement Cleaner
 * Schedule: Daily at 04:00
 */
var CONFIG = {
  SPREADSHEET_URL: "https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit",
  AUTO_EXCLUDE: true,
  JUNK_PATTERNS: [
    "anonymous.google", "game", "puzzle", "arcade", "kids", "baby",
    "cartoon", "lyrics", "apk", "mod", "cheats", "download", "free"
  ]
};

function main() {
  Logger.log("Starting Goodlabs Placement Cleaner...");
  var report = AdsApp.report(
    "SELECT PlacementUrl, CampaignName, Impressions, Clicks, Cost, Conversions " +
    "FROM AUTOMATIC_PLACEMENTS_PERFORMANCE_REPORT " +
    "WHERE Impressions > 20 " +
    "DURING LAST_14_DAYS"
  );

  var junkList = [];
  var rows = report.rows();

  while (rows.hasNext()) {
    var row = rows.next();
    var url = (row["PlacementUrl"] || "").toLowerCase();
    var imps = parseInt(row["Impressions"], 10);
    var convs = parseFloat(row["Conversions"].replace(/,/g, ""));
    var cost = parseFloat(row["Cost"].replace(/,/g, ""));

    var isJunk = false;
    for (var i = 0; i < CONFIG.JUNK_PATTERNS.length; i++) {
      if (url.indexOf(CONFIG.JUNK_PATTERNS[i]) !== -1) {
        isJunk = true;
        break;
      }
    }

    if (isJunk && convs === 0) {
      junkList.push({ url: url, campaign: row["CampaignName"], cost: cost, imps: imps });
    }
  }

  Logger.log("Found " + junkList.length + " junk placements to exclude.");
}