rosenberger.marketing

function main() {
  const EMAIL_ADDRESS = 'your-email@example.com'; // Change this
  const CPA_THRESHOLD = 200;
  const DATE_RANGE = 'LAST_7_DAYS';
  
  // Array to hold ad groups that exceed the threshold
  let alerts = [];
  // Query ad groups with costs > 0 to avoid empty data
  let adGroupSelector = AdsApp.adGroups()
    .withCondition("Status = ENABLED")
    .withCondition("CampaignStatus = ENABLED")
    .withCondition("Cost > 0")
    .forDateRange(DATE_RANGE);
  let iterator = adGroupSelector.get();
  while (iterator.hasNext()) {
    let adGroup = iterator.next();
    let stats = adGroup.getStatsFor(DATE_RANGE);
    
    let cost = stats.getCost();
    let conversions = stats.getConversions();
    
    // Calculate CPA (Cost / Conversions)
    // We check if conversions > 0 to avoid dividing by zero
    let cpa = conversions > 0 ? (cost / conversions) : cost; 
    if (cpa > CPA_THRESHOLD) {
      alerts.push({
        name: adGroup.getName(),
        campaign: adGroup.getCampaign().getName(),
        conversions: conversions.toFixed(2),
        cost: cost.toFixed(2),
        cpa: cpa.toFixed(2)
      });
    }
  }
  // Send the email if alerts were found
  if (alerts.length > 0) {
    sendAlertEmail(alerts, EMAIL_ADDRESS);
  } else {
    Logger.log("No ad groups exceeded the " + CPA_THRESHOLD + "€ CPA threshold.");
  }
}
function sendAlertEmail(alerts, email) {
  let subject = 'Google Ads Alert: Ad Group CPA over 200€';
  let body = 'The following ad groups have exceeded the CPA threshold in the last 7 days:\n\n';
  alerts.forEach(function(item) {
    body += "Campaign: " + item.campaign + "\n";
    body += "Ad Group: " + item.name + "\n";
    body += "Conversions: " + item.conversions + "\n";
    body += "Cost: " + item.cost + "€\n";
    body += "Current CPA: " + item.cpa + "€\n";
    body += "--------------------------------------\n";
  });
  MailApp.sendEmail(email, subject, body);
  Logger.log("Alert email sent to " + email);
}