Google Ads Scripts
אוטומציה חכמה
לקמפיינים

// Budget Alert Script — AdsAgency 2026
// שנו את הפרמטרים הבאים בלבד:

var EMAIL = 'your@email.com';
var THRESHOLD_PCT = 80;  // שלח Alert ב-80%

function main() {
  var campaigns = AdsApp.campaigns()
    .withCondition("Status = ENABLED").get();

  while (campaigns.hasNext()) {
    var c = campaigns.next();
    var budget = c.getBudget();
    var spent = c.getStatsFor("THIS_MONTH").getCost();
    var pct = (spent / budget.getAmount()) * 100;

    if (pct >= THRESHOLD_PCT) {
      MailApp.sendEmail(EMAIL,
        'Budget Alert: ' + c.getName(),
        'הגעתם ל-' + pct.toFixed(1) + '% מהתקציב');
    }
  }
}

// Broken Links Checker — AdsAgency 2026
var EMAIL = 'your@email.com';

function main() {
  var broken = [];
  var ads = AdsApp.ads()
    .withCondition("Status = ENABLED").get();

  while (ads.hasNext()) {
    var ad = ads.next();
    var url = ad.urls().getFinalUrl();
    if (!url) continue;
    var resp = UrlFetchApp.fetch(url, {
      muteHttpExceptions: true, followRedirects: true
    });
    if (resp.getResponseCode() >= 400) {
      broken.push(url + ' (' + resp.getResponseCode() + ')');
    }
  }
  if (broken.length > 0) {
    MailApp.sendEmail(EMAIL,
      ' Broken Links Found',
      broken.join('\n'));
  }
}

// Pause Low QS Keywords — AdsAgency 2026
var MIN_QS = 4;        // QS נמוך מ-4
var MIN_COST = 50;      // הוציאו יותר מ-₪50
var DATE_RANGE = "LAST_30_DAYS";

function main() {
  var kws = AdsApp.keywords()
    .withCondition("QualityScore < " + MIN_QS)
    .withCondition("Status = ENABLED")
    .forDateRange(DATE_RANGE).get();

  while (kws.hasNext()) {
    var kw = kws.next();
    var stats = kw.getStatsFor(DATE_RANGE);
    if (stats.getCost() > MIN_COST &&
        stats.getConversions() === 0) {
      kw.pause();
      Logger.log('Paused: ' + kw.getText());
    }
  }
}

// Weekly Performance Email — AdsAgency 2026
var EMAIL = 'your@email.com';
var DATE_RANGE = "LAST_7_DAYS";

function main() {
  var body = ' Weekly Google Ads Report\n\n';
  var campaigns = AdsApp.campaigns().get();

  while (campaigns.hasNext()) {
    var c = campaigns.next();
    var s = c.getStatsFor(DATE_RANGE);
    body += c.getName() + '\n'
      + '  Cost: ₪' + s.getCost().toFixed(0)
      + ' | CTR: ' + (s.getCtr()*100).toFixed(1) + '%'
      + ' | Conv: ' + s.getConversions()
      + '\n\n';
  }
  MailApp.sendEmail(EMAIL,
    ' Google Ads Weekly Report', body);
}

// CPA Alert — AdsAgency 2026
var EMAIL = 'your@email.com';
var MAX_CPA = 200;  // שלח Alert אם CPA > ₪200
var MIN_CONV = 3;   // רק אם יש 3+ המרות

function main() {
  var campaigns = AdsApp.campaigns()
    .withCondition("Status = ENABLED")
    .forDateRange("LAST_7_DAYS").get();

  while (campaigns.hasNext()) {
    var c = campaigns.next();
    var s = c.getStatsFor("LAST_7_DAYS");
    var conv = s.getConversions();
    if (conv >= MIN_CONV) {
      var cpa = s.getCost() / conv;
      if (cpa > MAX_CPA) {
        MailApp.sendEmail(EMAIL,
          ' CPA Alert: ' + c.getName(),
          'CPA: ₪' + cpa.toFixed(0) +
          ' (Max: ₪' + MAX_CPA + ')');
      }
    }
  }
}

// Pause Low Performers — AdsAgency 2026
var MIN_CLICKS = 50;    // לפחות 50 קליקים
var MAX_CTR = 0.01;    // CTR נמוך מ-1%
var MIN_COST = 100;    // הוציאו מעל ₪100

function main() {
  var ads = AdsApp.ads()
    .withCondition("Status = ENABLED")
    .withCondition("Clicks > " + MIN_CLICKS)
    .withCondition("Ctr < " + MAX_CTR)
    .forDateRange("LAST_30_DAYS").get();

  while (ads.hasNext()) {
    var ad = ads.next();
    if (ad.getStatsFor("LAST_30_DAYS")
      .getCost() > MIN_COST) {
      ad.pause();
      Logger.log('Paused Ad: ' + ad.getId());
    }
  }
}

// QS Monitor → Google Sheets
var SHEET_URL = 'YOUR_GOOGLE_SHEET_URL';

function main() {
  var sheet = SpreadsheetApp
    .openByUrl(SHEET_URL)
    .getActiveSheet();
  var today = new Date();
  var kws = AdsApp.keywords()
    .withCondition("Status = ENABLED").get();

  while (kws.hasNext()) {
    var kw = kws.next();
    sheet.appendRow([
      today,
      kw.getText(),
      kw.getQualityScore(),
      kw.getCampaign().getName()
    ]);
  }
}

// Auto Pause Over Monthly Budget
var MONTHLY_BUDGET = 5000;  // ₪5,000 תקציב חודשי
var EMAIL = 'your@email.com';

function main() {
  var campaigns = AdsApp.campaigns()
    .withCondition("Status = ENABLED").get();

  var totalSpent = 0;
  while (campaigns.hasNext()) {
    var c = campaigns.next();
    totalSpent += c.getStatsFor("THIS_MONTH").getCost();
  }

  if (totalSpent >= MONTHLY_BUDGET) {
    var all = AdsApp.campaigns()
      .withCondition("Status = ENABLED").get();
    while (all.hasNext()) {
      all.next().pause();
    }
    MailApp.sendEmail(EMAIL,
      ' Budget Exhausted — Campaigns Paused',
      'Spent: ₪' + totalSpent.toFixed(0));
  }
}

// Bid Adjustment by Hour — AdsAgency
var CAMPAIGN_NAME = 'My Campaign';
var PEAK_HOURS = [9,10,11,14,15];
var PEAK_MULT = 1.3;    // +30% בשעות שיא
var OFF_MULT = 0.7;     // -30% בשעות שפל

function main() {
  var hour = new Date().getHours();
  var mult = PEAK_HOURS.indexOf(hour) >= 0
    ? PEAK_MULT : OFF_MULT;

  var kws = AdsApp.keywords()
    .withCondition("CampaignName = '" + CAMPAIGN_NAME + "'")
    .withCondition("Status = ENABLED").get();

  while (kws.hasNext()) {
    var kw = kws.next();
    var bid = kw.bidding().getCpc();
    kw.bidding().setCpc(bid * mult);
  }
}

// Search Terms → Google Sheets
var SHEET_URL = 'YOUR_SHEET_URL';
var MIN_COST = 10;  // רק ביטויים עם עלות > ₪10

function main() {
  var sheet = SpreadsheetApp
    .openByUrl(SHEET_URL)
    .getActiveSheet();
  sheet.clearContents();
  sheet.appendRow(['Date','Search Term','Clicks','Cost','Conv']);

  var report = AdsApp.report(
    "SELECT Query, Clicks, Cost, Conversions " +
    "FROM SEARCH_QUERY_PERFORMANCE_REPORT " +
    "WHERE Cost > " + MIN_COST +
    " DURING LAST_7_DAYS");

  var rows = report.rows();
  while (rows.hasNext()) {
    var row = rows.next();
    sheet.appendRow([
      new Date(),
      row['Query'],
      row['Clicks'],
      row['Cost'],
      row['Conversions']
    ]);
  }
}

// Label Low CTR Ads — AdsAgency
var MAX_CTR = 0.02;    // CTR < 2%
var MIN_IMPR = 100;     // לפחות 100 חשיפות
var LABEL = 'LOW_CTR';

function main() {
  var label = AdsApp.labels()
    .withCondition("Name = '" + LABEL + "'").get();
  if (!label.hasNext())
    AdsApp.createLabel(LABEL);

  var ads = AdsApp.ads()
    .withCondition("Impressions > " + MIN_IMPR)
    .withCondition("Ctr < " + MAX_CTR)
    .forDateRange("LAST_30_DAYS").get();

  while (ads.hasNext()) {
    ads.next().applyLabel(LABEL);
  }
}

// Zero Impression Keywords Report
var EMAIL = 'your@email.com';

function main() {
  var zeroKws = [];
  var kws = AdsApp.keywords()
    .withCondition("Status = ENABLED")
    .withCondition("Impressions = 0")
    .forDateRange("LAST_30_DAYS").get();

  while (kws.hasNext()) {
    var kw = kws.next();
    zeroKws.push(
      kw.getText() + ' | QS: ' +
      kw.getQualityScore() +
      ' | ' + kw.getCampaign().getName());
  }

  if (zeroKws.length > 0) {
    MailApp.sendEmail(EMAIL,
      zeroKws.length + ' Zero Impression KWs',
      zeroKws.join('\n'));
  }
}