Google Ads Scripts: Automatisierung ohne Programmierkenntnisse (2026 Guide)

// Budget-Monitoring Script
// Warnt wenn Kampagnen &gt; 90% oder < 50% des Tagesbudgets ausgeben

var EMAIL = "deine@email.de";
var THRESHOLD_HIGH = 0.9;  // 90%
var THRESHOLD_LOW = 0.5;   // 50%

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

  var alerts = [];
  var now = new Date();
  var hourOfDay = now.getHours();
  var expectedSpend = hourOfDay / 24;

  while (campaigns.hasNext()) {
    var campaign = campaigns.next();
    var stats = campaign.getStatsFor("TODAY");
    var budget = campaign.getBudget().getAmount();
    var cost = stats.getCost();
    var spendRatio = cost / budget;

    if (spendRatio > THRESHOLD_HIGH) {
      alerts.push(campaign.getName() +
        ": Budget fast aufgebraucht (" +
        Math.round(spendRatio * 100) + "%)");
    }

    if (spendRatio < expectedSpend * THRESHOLD_LOW && hourOfDay &gt; 12) {
      alerts.push(campaign.getName() +
        ": Unterdurchschnittliche Ausgaben (" +
        Math.round(spendRatio * 100) + "%)");
    }
  }

  if (alerts.length &gt; 0) {
    MailApp.sendEmail(EMAIL,
      "Google Ads Budget Alert",
      alerts.join("\n"));
  }
}

// Auto-Pause bei schlechter Performance
// Pausiert Keywords mit hohen Kosten aber ohne Conversions

var MAX_COST_NO_CONV = 50;  // EUR ohne Conversion
var MIN_CLICKS = 20;        // Mindest-Klicks für Evaluation
var LOOKBACK_DAYS = 30;

function main() {
  var dateRange = getDateRange(LOOKBACK_DAYS);

  var keywords = AdsApp.keywords()
    .withCondition("Status = ENABLED")
    .withCondition("CampaignStatus = ENABLED")
    .withCondition("AdGroupStatus = ENABLED")
    .withCondition("Clicks >= " + MIN_CLICKS)
    .withCondition("Conversions = 0")
    .withCondition("Cost > " + MAX_COST_NO_CONV)
    .forDateRange(dateRange.start, dateRange.end)
    .get();

  var paused = [];

  while (keywords.hasNext()) {
    var keyword = keywords.next();
    keyword.pause();
    keyword.applyLabel("Auto-Paused-Performance");
    paused.push(keyword.getText() + " (Cost: " +
      keyword.getStatsFor(dateRange.start, dateRange.end)
        .getCost() + " EUR)");
  }

  if (paused.length > 0) {
    Logger.log("Pausierte Keywords: " + paused.length);
    Logger.log(paused.join("\n"));
  }
}

function getDateRange(days) {
  var end = new Date();
  var start = new Date();
  start.setDate(start.getDate() - days);
  return {
    start: Utilities.formatDate(start, "GMT", "yyyyMMdd"),
    end: Utilities.formatDate(end, "GMT", "yyyyMMdd")
  };
}

// Broken URL Checker
// Prüft Final URLs auf HTTP-Fehler

var EMAIL = "deine@email.de";

function main() {
  var ads = AdsApp.ads()
    .withCondition("Status = ENABLED")
    .withCondition("CampaignStatus = ENABLED")
    .withCondition("AdGroupStatus = ENABLED")
    .get();

  var brokenUrls = [];
  var checkedUrls = {};

  while (ads.hasNext()) {
    var ad = ads.next();
    var urls = ad.urls().getFinalUrl();

    if (urls && !checkedUrls[urls]) {
      checkedUrls[urls] = true;
      var status = checkUrl(urls);

      if (status !== 200) {
        brokenUrls.push({
          campaign: ad.getCampaign().getName(),
          adGroup: ad.getAdGroup().getName(),
          url: urls,
          status: status
        });
      }
    }
  }

  if (brokenUrls.length > 0) {
    var report = "Broken URLs gefunden:\n\n";
    brokenUrls.forEach(function(item) {
      report += "Kampagne: " + item.campaign + "\n";
      report += "Anzeigengruppe: " + item.adGroup + "\n";
      report += "URL: " + item.url + "\n";
      report += "Status: " + item.status + "\n\n";
    });

    MailApp.sendEmail(EMAIL,
      "Google Ads: " + brokenUrls.length + " Broken URLs",
      report);
  }
}

function checkUrl(url) {
  try {
    var response = UrlFetchApp.fetch(url, {
      muteHttpExceptions: true,
      followRedirects: true
    });
    return response.getResponseCode();
  } catch (e) {
    return "Error: " + e.message;
  }
}

// Quality Score Tracker
// Exportiert QS-Daten täglich in Google Sheets

var SPREADSHEET_URL = "https://docs.google.com/spreadsheets/d/xxx/edit";

function main() {
  var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  var sheet = ss.getSheetByName("QS-Tracking") ||
    ss.insertSheet("QS-Tracking");

  var today = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd");

  var report = AdsApp.report(
    "SELECT CampaignName, AdGroupName, Criteria, QualityScore, " +
    "SearchPredictedCtr, CreativeQualityScore, " +
    "PostClickQualityScore, Impressions " +
    "FROM KEYWORDS_PERFORMANCE_REPORT " +
    "WHERE QualityScore > 0 " +
    "AND Impressions > 100 " +
    "DURING LAST_7_DAYS"
  );

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

  while (rows.hasNext()) {
    var row = rows.next();
    data.push([
      today,
      row["CampaignName"],
      row["AdGroupName"],
      row["Criteria"],
      row["QualityScore"],
      row["SearchPredictedCtr"],
      row["CreativeQualityScore"],
      row["PostClickQualityScore"],
      row["Impressions"]
    ]);
  }

  if (data.length > 0) {
    // Header falls Sheet leer
    if (sheet.getLastRow() === 0) {
      sheet.appendRow([
        "Datum", "Kampagne", "Anzeigengruppe", "Keyword",
        "QS", "Erwartete CTR", "Anzeigenrelevanz",
        "Landing Page", "Impressions"
      ]);
    }

    sheet.getRange(sheet.getLastRow() + 1, 1,
      data.length, data[0].length).setValues(data);
  }

  Logger.log("QS-Daten exportiert: " + data.length + " Keywords");
}

// Negative Keyword Conflict Finder
// Findet Keywords die durch Negatives blockiert werden

var EMAIL = "deine@email.de";

function main() {
  var conflicts = [];

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

  while (campaigns.hasNext()) {
    var campaign = campaigns.next();
    var campaignName = campaign.getName();

    // Sammle alle negativen Keywords
    var negatives = [];
    var negKeywords = campaign.negativeKeywords().get();
    while (negKeywords.hasNext()) {
      negatives.push(negKeywords.next().getText()
        .toLowerCase().replace(/[\[\]"\+]/g, ""));
    }

    // Prüfe aktive Keywords
    var keywords = campaign.keywords()
      .withCondition("Status = ENABLED")
      .get();

    while (keywords.hasNext()) {
      var keyword = keywords.next();
      var kwText = keyword.getText()
        .toLowerCase().replace(/[\[\]"\+]/g, "");

      negatives.forEach(function(neg) {
        if (kwText.indexOf(neg) !== -1 || neg.indexOf(kwText) !== -1) {
          conflicts.push({
            campaign: campaignName,
            keyword: keyword.getText(),
            negative: neg,
            matchType: keyword.getMatchType()
          });
        }
      });
    }
  }

  if (conflicts.length > 0) {
    var report = "Negative Keyword Konflikte gefunden:\n\n";
    conflicts.forEach(function(c) {
      report += "Kampagne: " + c.campaign + "\n";
      report += "Keyword: " + c.keyword + " (" + c.matchType + ")\n";
      report += "Negatives: " + c.negative + "\n\n";
    });

    MailApp.sendEmail(EMAIL,
      conflicts.length + " Negative Keyword Konflikte", report);
  }
}

// Search Term Mining Script
// Findet neue Keywords und Negative-Kandidaten

var SPREADSHEET_URL = "https://docs.google.com/spreadsheets/d/xxx/edit";
var MIN_IMPRESSIONS = 10;
var MIN_CONVERSIONS_POSITIVE = 1;
var MIN_CLICKS_NEGATIVE = 5;
var MAX_CTR_NEGATIVE = 0.01;  // 1%

function main() {
  var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);

  var positiveSheet = ss.getSheetByName("Neue Keywords") ||
    ss.insertSheet("Neue Keywords");
  var negativeSheet = ss.getSheetByName("Negative Kandidaten") ||
    ss.insertSheet("Negative Kandidaten");

  var report = AdsApp.report(
    "SELECT Query, CampaignName, Impressions, Clicks, " +
    "Conversions, Cost, Ctr " +
    "FROM SEARCH_QUERY_PERFORMANCE_REPORT " +
    "WHERE Impressions >= " + MIN_IMPRESSIONS + " " +
    "DURING LAST_30_DAYS"
  );

  var positiveKeywords = [];
  var negativeKeywords = [];
  var rows = report.rows();

  while (rows.hasNext()) {
    var row = rows.next();
    var conversions = parseFloat(row["Conversions"]);
    var clicks = parseInt(row["Clicks"]);
    var ctr = parseFloat(row["Ctr"].replace("%", "")) / 100;

    // Gute Performance = neues Keyword
    if (conversions >= MIN_CONVERSIONS_POSITIVE) {
      positiveKeywords.push([
        row["Query"],
        row["CampaignName"],
        row["Impressions"],
        row["Clicks"],
        conversions,
        row["Cost"]
      ]);
    }

    // Schlechte Performance = Negative-Kandidat
    if (clicks >= MIN_CLICKS_NEGATIVE &&
        conversions === 0 &&
        ctr < MAX_CTR_NEGATIVE) {
      negativeKeywords.push([
        row["Query"],
        row["CampaignName"],
        row["Impressions"],
        row["Clicks"],
        ctr,
        row["Cost"]
      ]);
    }
  }

  // Export
  if (positiveKeywords.length &gt; 0) {
    positiveSheet.clear();
    positiveSheet.appendRow([
      "Suchbegriff", "Kampagne", "Impressions",
      "Klicks", "Conversions", "Kosten"
    ]);
    positiveSheet.getRange(2, 1, positiveKeywords.length,
      positiveKeywords[0].length).setValues(positiveKeywords);
  }

  if (negativeKeywords.length &gt; 0) {
    negativeSheet.clear();
    negativeSheet.appendRow([
      "Suchbegriff", "Kampagne", "Impressions",
      "Klicks", "CTR", "Kosten"
    ]);
    negativeSheet.getRange(2, 1, negativeKeywords.length,
      negativeKeywords[0].length).setValues(negativeKeywords);
  }

  Logger.log("Neue Keywords: " + positiveKeywords.length);
  Logger.log("Negative Kandidaten: " + negativeKeywords.length);
}

// Automatische Bid Adjustments
// Erhöht/senkt Gebote basierend auf CPA-Performance

var TARGET_CPA = 25;        // Ziel-CPA in EUR
var MAX_BID_CHANGE = 0.2;   // Max 20% Änderung
var MIN_CONVERSIONS = 3;    // Mindest-Conversions
var LOOKBACK_DAYS = 14;

function main() {
  var dateRange = getDateRange(LOOKBACK_DAYS);

  var keywords = AdsApp.keywords()
    .withCondition("Status = ENABLED")
    .withCondition("Conversions >= " + MIN_CONVERSIONS)
    .forDateRange(dateRange.start, dateRange.end)
    .get();

  var changes = [];

  while (keywords.hasNext()) {
    var keyword = keywords.next();
    var stats = keyword.getStatsFor(dateRange.start, dateRange.end);
    var cost = stats.getCost();
    var conversions = stats.getConversions();

    if (conversions > 0) {
      var actualCpa = cost / conversions;
      var currentBid = keyword.bidding().getCpc();
      var newBid = currentBid;

      if (actualCpa < TARGET_CPA * 0.8) {
        // CPA zu niedrig - Gebot erhöhen
        var increase = Math.min(MAX_BID_CHANGE,
          (TARGET_CPA - actualCpa) / TARGET_CPA);
        newBid = currentBid * (1 + increase);
      } else if (actualCpa > TARGET_CPA * 1.2) {
        // CPA zu hoch - Gebot senken
        var decrease = Math.min(MAX_BID_CHANGE,
          (actualCpa - TARGET_CPA) / TARGET_CPA);
        newBid = currentBid * (1 - decrease);
      }

      if (newBid !== currentBid) {
        keyword.bidding().setCpc(newBid);
        changes.push({
          keyword: keyword.getText(),
          oldBid: currentBid,
          newBid: newBid,
          cpa: actualCpa
        });
      }
    }
  }

  Logger.log("Bid Adjustments: " + changes.length);
  changes.forEach(function(c) {
    Logger.log(c.keyword + ": " + c.oldBid.toFixed(2) +
      " -> " + c.newBid.toFixed(2) + " (CPA: " +
      c.cpa.toFixed(2) + ")");
  });
}

function getDateRange(days) {
  var end = new Date();
  var start = new Date();
  start.setDate(start.getDate() - days);
  return {
    start: Utilities.formatDate(start, "GMT", "yyyyMMdd"),
    end: Utilities.formatDate(end, "GMT", "yyyyMMdd")
  };
}

// Automatisches Performance Reporting
// Exportiert Kampagnen-Performance in Google Sheets

var SPREADSHEET_URL = "https://docs.google.com/spreadsheets/d/xxx/edit";
var EMAIL = "deine@email.de";

function main() {
  var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  var today = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd");
  var sheetName = "Report " + today;

  var sheet = ss.getSheetByName(sheetName) || ss.insertSheet(sheetName);
  sheet.clear();

  // Account-Übersicht
  var accountStats = AdsApp.currentAccount().getStatsFor("LAST_7_DAYS");
  sheet.appendRow(["Account Performance - Letzte 7 Tage"]);
  sheet.appendRow(["Impressions", accountStats.getImpressions()]);
  sheet.appendRow(["Klicks", accountStats.getClicks()]);
  sheet.appendRow(["Kosten", accountStats.getCost()]);
  sheet.appendRow(["Conversions", accountStats.getConversions()]);
  sheet.appendRow(["CTR", (accountStats.getCtr() * 100).toFixed(2) + "%"]);
  sheet.appendRow([""]);

  // Kampagnen-Details
  sheet.appendRow([
    "Kampagne", "Status", "Impressions", "Klicks",
    "CTR", "Kosten", "Conversions", "CPA"
  ]);

  var campaigns = AdsApp.campaigns()
    .withCondition("Impressions > 0")
    .forDateRange("LAST_7_DAYS")
    .orderBy("Cost DESC")
    .get();

  var data = [];
  while (campaigns.hasNext()) {
    var campaign = campaigns.next();
    var stats = campaign.getStatsFor("LAST_7_DAYS");
    var conversions = stats.getConversions();
    var cost = stats.getCost();

    data.push([
      campaign.getName(),
      campaign.isEnabled() ? "Aktiv" : "Pausiert",
      stats.getImpressions(),
      stats.getClicks(),
      (stats.getCtr() * 100).toFixed(2) + "%",
      cost.toFixed(2),
      conversions,
      conversions > 0 ? (cost / conversions).toFixed(2) : "-"
    ]);
  }

  if (data.length > 0) {
    sheet.getRange(9, 1, data.length, data[0].length).setValues(data);
  }

  // E-Mail mit Link
  MailApp.sendEmail(EMAIL,
    "Google Ads Report " + today,
    "Der aktuelle Performance-Report ist verfügbar:\n\n" +
    SPREADSHEET_URL);

  Logger.log("Report erstellt: " + data.length + " Kampagnen");
}

// Automatisches Label Management
// Kategorisiert Keywords nach Performance

var LABELS = {
  TOP_PERFORMER: "Top Performer",
  GOOD: "Gute Performance",
  AVERAGE: "Durchschnitt",
  UNDERPERFORMER: "Underperformer",
  NO_DATA: "Keine Daten"
};

function main() {
  // Stelle sicher dass Labels existieren
  Object.values(LABELS).forEach(function(label) {
    try {
      AdsApp.createLabel(label);
    } catch (e) {
      // Label existiert bereits
    }
  });

  var keywords = AdsApp.keywords()
    .withCondition("Status = ENABLED")
    .withCondition("CampaignStatus = ENABLED")
    .forDateRange("LAST_30_DAYS")
    .get();

  var counts = {};
  Object.values(LABELS).forEach(function(l) { counts[l] = 0; });

  while (keywords.hasNext()) {
    var keyword = keywords.next();
    var stats = keyword.getStatsFor("LAST_30_DAYS");

    // Entferne alte Performance-Labels
    Object.values(LABELS).forEach(function(label) {
      keyword.removeLabel(label);
    });

    var impressions = stats.getImpressions();
    var conversions = stats.getConversions();
    var cost = stats.getCost();
    var newLabel;

    if (impressions < 100) {
      newLabel = LABELS.NO_DATA;
    } else if (conversions >= 5) {
      newLabel = LABELS.TOP_PERFORMER;
    } else if (conversions >= 2) {
      newLabel = LABELS.GOOD;
    } else if (conversions >= 1 || cost < 20) {
      newLabel = LABELS.AVERAGE;
    } else {
      newLabel = LABELS.UNDERPERFORMER;
    }

    keyword.applyLabel(newLabel);
    counts[newLabel]++;
  }

  Logger.log("Label-Verteilung:");
  Object.keys(counts).forEach(function(label) {
    Logger.log(label + ": " + counts[label]);
  });
}

// Wettbewerber-Monitoring Script
// Trackt Auction Insights über Zeit

var SPREADSHEET_URL = "https://docs.google.com/spreadsheets/d/xxx/edit";
var EMAIL = "deine@email.de";
var ALERT_THRESHOLD = 0.1;  // 10% Veränderung

function main() {
  var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  var sheet = ss.getSheetByName("Wettbewerber") ||
    ss.insertSheet("Wettbewerber");

  var today = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd");

  var report = AdsApp.report(
    "SELECT Domain, SearchImpressionShare, " +
    "SearchOverlapRate, SearchPositionAboveRate, " +
    "SearchTopImpressionShare, SearchAbsoluteTopImpressionShare " +
    "FROM AUCTION_INSIGHTS_REPORT " +
    "DURING LAST_7_DAYS"
  );

  var rows = report.rows();
  var currentData = [];
  var alerts = [];

  // Hole vorherige Daten für Vergleich
  var previousData = getPreviousData(sheet);

  while (rows.hasNext()) {
    var row = rows.next();
    var domain = row["Domain"];
    var impressionShare = parseFloat(row["SearchImpressionShare"]) / 100;
    var overlapRate = parseFloat(row["SearchOverlapRate"]) / 100;
    var positionAbove = parseFloat(row["SearchPositionAboveRate"]) / 100;

    currentData.push([
      today,
      domain,
      impressionShare,
      overlapRate,
      positionAbove,
      row["SearchTopImpressionShare"],
      row["SearchAbsoluteTopImpressionShare"]
    ]);

    // Prüfe auf signifikante Änderungen
    if (previousData[domain]) {
      var prevIS = previousData[domain].impressionShare;
      var change = impressionShare - prevIS;

      if (Math.abs(change) > ALERT_THRESHOLD) {
        alerts.push(domain + ": Impression Share " +
          (change > 0 ? "+" : "") +
          (change * 100).toFixed(1) + "%");
      }
    }
  }

  // Speichere Daten
  if (sheet.getLastRow() === 0) {
    sheet.appendRow([
      "Datum", "Domain", "Impression Share",
      "Overlap Rate", "Position Above Rate",
      "Top IS", "Absolute Top IS"
    ]);
  }

  if (currentData.length > 0) {
    sheet.getRange(sheet.getLastRow() + 1, 1,
      currentData.length, currentData[0].length)
      .setValues(currentData);
  }

  // Sende Alerts
  if (alerts.length > 0) {
    MailApp.sendEmail(EMAIL,
      "Wettbewerber-Alert: Signifikante Änderungen",
      alerts.join("\n"));
  }

  Logger.log("Wettbewerber getrackt: " + currentData.length);
}

function getPreviousData(sheet) {
  var data = {};
  var lastRow = sheet.getLastRow();

  if (lastRow > 1) {
    var values = sheet.getRange(2, 1, lastRow - 1, 7).getValues();
    values.forEach(function(row) {
      data[row[1]] = {
        impressionShare: row[2],
        overlapRate: row[3],
        positionAbove: row[4]
      };
    });
  }

  return data;
}

// Best Practice: Try-Catch für Fehlerbehandlung
function main() {
  try {
    // Dein Code hier
    processKeywords();
  } catch (error) {
    Logger.log("FEHLER: " + error.message);
    Logger.log("Stack: " + error.stack);

    // Optional: E-Mail bei kritischen Fehlern
    MailApp.sendEmail(
      "deine@email.de",
      "Script-Fehler: " + error.message,
      "Details:\n" + error.stack
    );
  }
}

// Best Practice: Ausführliches Logging
function processKeywords() {
  Logger.log("=== Script gestartet ===");
  Logger.log("Zeitstempel: " + new Date());

  var keywords = AdsApp.keywords()
    .withCondition("Status = ENABLED")
    .get();

  Logger.log("Keywords gefunden: " + keywords.totalNumEntities());

  var processed = 0;
  var errors = 0;

  while (keywords.hasNext()) {
    try {
      var keyword = keywords.next();
      // Verarbeitung...
      processed++;
    } catch (e) {
      Logger.log("Fehler bei Keyword: " + e.message);
      errors++;
    }
  }

  Logger.log("=== Script beendet ===");
  Logger.log("Verarbeitet: " + processed + ", Fehler: " + errors);
}

// Best Practice: Sicherheitslimits
var CONFIG = {
  MAX_CHANGES_PER_RUN: 50,    // Maximal 50 Änderungen
  DRY_RUN: true,              // Test-Modus: keine echten Änderungen
  NOTIFY_EMAIL: "deine@email.de"
};

function main() {
  var changesCount = 0;
  var changes = [];

  var keywords = AdsApp.keywords()
    .withCondition("Status = ENABLED")
    .get();

  while (keywords.hasNext() && changesCount < CONFIG.MAX_CHANGES_PER_RUN) {
    var keyword = keywords.next();

    // Prüfe ob Änderung nötig
    if (shouldPause(keyword)) {
      if (CONFIG.DRY_RUN) {
        Logger.log("[DRY RUN] Würde pausieren: " + keyword.getText());
      } else {
        keyword.pause();
        Logger.log("Pausiert: " + keyword.getText());
      }

      changes.push(keyword.getText());
      changesCount++;
    }
  }

  // Benachrichtigung bei Änderungen
  if (changes.length &gt; 0 && !CONFIG.DRY_RUN) {
    MailApp.sendEmail(
      CONFIG.NOTIFY_EMAIL,
      "Script-Änderungen: " + changes.length + " Keywords",
      "Folgende Keywords wurden pausiert:\n" + changes.join("\n")
    );
  }

  Logger.log("Änderungen: " + changesCount +
    (CONFIG.DRY_RUN ? " (Dry Run)" : ""));
}

function shouldPause(keyword) {
  // Deine Pausier-Logik hier
  return false;
}