Поиск мусорных площадок в КМС и YouTube

/**
 * Goodlabs Google Ads script: junk placement finder
 * Schedule: Daily at 04:00
 */
var CONFIG = {
  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 group_placement_view.target_url, campaign.name, metrics.impressions, " +
    "metrics.clicks, metrics.cost_micros, metrics.conversions " +
    "FROM group_placement_view " +
    "WHERE metrics.impressions > 20 " +
    "AND segments.date DURING LAST_14_DAYS"
  );

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

  while (rows.hasNext()) {
    var row = rows.next();
    var url = String(row["group_placement_view.target_url"] || "").toLowerCase();
    var imps = Number(row["metrics.impressions"] || 0);
    var convs = Number(row["metrics.conversions"] || 0);
    var cost = Number(row["metrics.cost_micros"] || 0) / 1e6;

    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["campaign.name"], cost: cost, imps: imps });
    }
  }

  Logger.log("Found " + junkList.length + " junk placements to exclude.");
  junkList.forEach(function(p) {
    Logger.log(p.url + " | " + p.campaign + " | cost " + p.cost.toFixed(2) + " | " + p.imps + " impressions");
  });
}