gist:b719840542406322bb27

## gistfile1.js
/***************************************************************************************
* AdWords Countdown Ad Updater  -- Find stale countdown ads and replace them with
* Ads that are updated with new dates.
* Version 1.0
* Created By: Derek Martin
* DerekMartinLA.com or MixedMarketingArtist.com
****************************************************************************************/

var DESCRIPTION2_TEXT = "Sale Ends In"

function main() {
  // Set your campaign criteria here

  var campIter = AdWordsApp.campaigns().withCondition("Status=ENABLED").withCondition("Name does_not_contain Remarketing").get();

  while (campIter.hasNext()) {
    var camp = campIter.next();


    var agIter = camp.adGroups().withCondition("Status = ENABLED").get();

    while (agIter.hasNext()) {
      var ag  = agIter.next();

      var adsIter = ag.ads().withCondition("Status = ENABLED").get();

      while (adsIter.hasNext()) {
         ad = adsIter.next();

         var headline,d1,d2,displayUrl, destUrl;
           headline = ad.getHeadline();
           d1 = ad.getDescription1();
           d2 = ad.getDescription2();
           displayUrl = ad.getDisplayUrl();
           destUrl = ad.getDestinationUrl();

         var regex = /\{=COUNTDOWN\(\"(\d{4})\/(\d{1,2})\/(\d{1,2})/

         if (d2.match(regex)) {
           match = d2.match(regex);
           info(match);
           var the_date = new Date(match[1], match[2]-1,match[3])
           var today = new Date;
           info(today);
           if (daysBetween(today, the_date) < 0) {
              ad.pause();
              var newDate = new Date();

              newDate.setDate(newDate.getDate() + 5); // add 5 days
             var formattedDate = Utilities.formatDate(newDate, "PST", "yyyy/MM/dd");
             var newDest2 = DESCRIPTION2_TEXT + " {\=COUNTDOWN(\"" + formattedDate +" 23:59:00\")}."

             status = ag.newTextAdBuilder().withHeadline(headline).withDescription1(d1).withDescription2(newDest2).withDisplayUrl(displayUrl).withDestinationUrl(destUrl).build();
           }
         }
      }

    }
  }
}

function daysBetween( date1, date2 ) {
  //Get 1 day in milliseconds
  var one_day=1000*60*60*24;

  // Convert both dates to milliseconds
  var date1_ms = date1.getTime();
  var date2_ms = date2.getTime();

  // Calculate the difference in milliseconds
  var difference_ms = date2_ms - date1_ms;

  // Convert back to days and return
  return Math.round(difference_ms/one_day);
}

/* HELPER FUNCTIONS */

function warn(msg) {
  Logger.log('WARNING: '+msg);
}

function info(msg) {
  Logger.log(msg);
}