Just commented out the two lines that falsly set todays click and impression stats to 0. "Account Anomaly Detector alerts the advertiser whenever an AdWords account is suddenly behaving too differently from what's historically observed. When an issue is encountered, the script will send the user an alerting email. Only a single email for an aler…

Account Anomaly Detector.js

var SPREADSHEET_URL = "[YOUR_URL]";

var DAYS = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'];

function main() {
  var spreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  spreadsheet.getRangeByName("date").setValue(new Date());
  spreadsheet.getRangeByName("account_id").setValue(AdWordsApp.currentAccount().getCustomerId());
  var impressionsThreshold = parseField(spreadsheet.getRangeByName("impressions").getValue());
  var clicksThreshold = parseField(spreadsheet.getRangeByName("clicks").getValue());
  var costThreshold = parseField(spreadsheet.getRangeByName("cost").getValue());
  var weeksStr = spreadsheet.getRangeByName("weeks").getValue();
  var weeks = parseInt(weeksStr.substring(0, weeksStr.indexOf(" ")));
  var email = spreadsheet.getRangeByName("email").getValue();
  
  var now = new Date(Utilities.formatDate(new Date(), 
      AdWordsApp.currentAccount().getTimeZone(), "MMM dd,yyyy HH:mm:ss"));

  var currentDate = now.getDate();
  now.setTime(now.getTime() - 3 * 3600 * 1000);
  var adjustedDate = now.getDate();
  
  var hours = now.getHours();
  if (hours == 0) { 
    hours = 24;
  }
  if (hours == 1) {
    // first run of the day, kill existing alerts
    spreadsheet.getRangeByName("clicks_alert").clearContent();
    spreadsheet.getRangeByName("impressions_alert").clearContent();
    spreadsheet.getRangeByName("cost_alert").clearContent();
  }
  var dayToCheck;
  if (currentDate != adjustedDate) {
    dayToCheck = 1;
  } else {
    dayToCheck = 0;
  }
  var dateRangeToCheck = getDateInThePast(dayToCheck);
  var dateRangeToEnd = getDateInThePast(dayToCheck + 1);
  var dateRangeToStart = getDateInThePast(dayToCheck + 1 + weeks * 7);
  var fields = "HourOfDay,DayOfWeek,Clicks,Impressions,Cost";
  
  var today = AdWordsApp.report("SELECT " + fields + 
      " FROM ACCOUNT_PERFORMANCE_REPORT DURING " + dateRangeToCheck + "," + dateRangeToCheck);
  var past = AdWordsApp.report("SELECT " + fields + 
      " FROM ACCOUNT_PERFORMANCE_REPORT WHERE DayOfWeek=" + DAYS[now.getDay()].toUpperCase() + 
      " DURING " + dateRangeToStart + "," + dateRangeToEnd);
  
  var todayStats = accumulateRows(today.rows(), hours, 1);
  var pastStats = accumulateRows(past.rows(), hours, weeks);
  // The original script has the next two lines uncommented resulting to the alert to come off constantly and
  // data to be wrong
  //
  // todayStats.impressions = 0;
  // todayStats.clicks = 0;
  
  var alertText = [];
  if (impressionsThreshold && todayStats.impressions < pastStats.impressions * impressionsThreshold) {
    var range = spreadsheet.getRangeByName("impressions_alert");
    if (!range.getValue() || range.getValue().length == 0) {
      alertText.push("    Impressions are too low: " + todayStats.impressions + 
          " impressions by " + hours + ":00, expecting at least " + 
          parseInt(pastStats.impressions * impressionsThreshold));
      range.setValue("Alerting " + hours + ":00");
    }
  }
  if (clicksThreshold && todayStats.clicks < pastStats.clicks * clicksThreshold) {
    var range = spreadsheet.getRangeByName("clicks_alert");
    if (!range.getValue() || range.getValue().length == 0) {
      alertText.push("    Clicks are too low: " + todayStats.clicks + 
          " clicks by " + hours + ":00, expecting at least " + 
          (pastStats.clicks * clicksThreshold).toFixed(1));
      range.setValue("Alerting " + hours + ":00");
    }
  }
  if (costThreshold && todayStats.cost > pastStats.cost * costThreshold) {
    var range = spreadsheet.getRangeByName("clicks_alert");
    if (!range.getValue() || range.getValue().length == 0) {
      alertText.push("    Cost is too high: " + todayStats.cost + " " + 
          AdWordsApp.currentAccount().getCurrencyCode() + " by " + hours + 
          ":00, expecting at most " + (pastStats.clicks * costThreshold).toFixed(2));
      range.setValue("Alerting " + hours + ":00");
    }
  }
  if (alertText.length > 0 && email && email.length > 0) {
    MailApp.sendEmail(email, 
        "AdWords Account " + AdWordsApp.currentAccount().getCustomerId() + " misbehaves", 
        "Your account " + AdWordsApp.currentAccount().getCustomerId() + 
        " is not performing as expected today: \n\n" + alertText.join("\n") +
        "\n\nLog into AdWords and take a look.\n\nAlerts dashboard: " + SPREADSHEET_URL);
  }
  spreadsheet.getRangeByName("date").setValue(new Date());
  spreadsheet.getRangeByName("account_id").setValue(AdWordsApp.currentAccount().getCustomerId());
  spreadsheet.getRangeByName("timestamp").setValue(DAYS[now.getDay()] + ", " + hours + ":00");
  
var dataRows = [
    [todayStats.impressions, pastStats.impressions],
    [todayStats.clicks, pastStats.clicks],
    [todayStats.cost, pastStats.cost]
  ];
  spreadsheet.getRangeByName("data").setValue(dataRows);
}

function parseField(value) {
  if (value == "No alert") {
    return null;
  } else {
    return parseFloat(value);
  }
}

function accumulateRows(rows, hours, weeks) {
  var row;
  var result = null;
  
  for (var i = 0; i < hours; i ++) {
    if (rows.hasNext()) {
      row = rows.next();
    } else {
      row = null;
    }
    if (row && row ['HourOfDay'] == i) {
      result = addRow(row, result, 1 / weeks);
    } else {
      result = addRow(null, result, 1 / weeks);
    }
  }
  
  return result;
}

function addRow(row, previous, coefficient) {
  if (!coefficient) {
    coefficient = 1;
  }
  if (row == null) {
    row = {Clicks: 0, Impressions: 0, Cost: 0};
  }
  if (!previous) {
    return {
      clicks: parseInt(row['Clicks']) * coefficient,
      impressions: parseInt(row['Impressions']) * coefficient,
      cost: parseFloat(row['Cost']) * coefficient,
    };
  } else {
    return {
      clicks: parseInt(row['Clicks']) * coefficient + previous.clicks,
      impressions: parseInt(row['Impressions']) * coefficient + previous.impressions,
      cost: parseFloat(row['Cost']) * coefficient + previous.cost,
    };
  }
}

function checkInRange(today, yesterday, coefficient, field) {
  var yesterdayValue = yesterday[field] * coefficient;
  if (today[field] > yesterdayValue * 2) {
    Logger.log("" + field + " too much");
  } else if (today[field] < yesterdayValue / 2) {
    Logger.log("" + field + " too little");
  }
}

// Returns YYYYMMDD-formatted date.
function getDateInThePast(numDays) {
  var today = new Date();
  today.setDate(today.getDate() - numDays);
  return Utilities.formatDate(today, "PST", "yyyyMMdd");
}