How to modify this script?

[Peter Vretenička]

This script manages an ad or keywords at the campaign level label. Please how to modify the script to manage it by ad level labels? 

/************************************

* Item Out Of Stock Checker

* Version 1.2

* ChangeLog v1.2

*  - ONLY_ACTIVE is used to filter campaigns and adgroups only. All Keywords and Ads in the AdGroups will

*    be checked which solves the "once disabled, always disabled" issue.

*  - Updated call to get the Final Urls. Now calls getFinalUrl and getMobileFinalUrl instead of getDestinationUrl

*  - OUT_OF_STOCK_TEXTS can now contain multiple things to check for.

*  - If the CAMPAIGN_LABEL does not exist, it is ignored with a warning.

* ChangeLog v1.1 - Filtered out deleted Campaigns and AdGroups

* Created By: Russ Savage

* FreeAdWordsScripts.com

***********************************/

var URL_LEVEL = 'Ad'; // or Keyword

var ONLY_ACTIVE = true; // set to false to check keywords or ads in all campaigns (paused and active)

var CAMPAIGN_LABEL = ''; // set this if you want to only check campaigns with this label

var STRIP_QUERY_STRING = true; // set this to false if the stuff that comes after the question mark is important

var WRAPPED_URLS = true; // set this to true if you use a 3rd party like Marin or Kenshoo for managing you account

// This is the specific text (or texts) to search for 

// on the page that indicates the item 

// is out of stock. If ANY of these match the html

// on the page, the item is considered "out of stock"

var OUT_OF_STOCK_TEXTS = [

  'The Text That Identifies An Out Of Stock Item Goes Here',

  'Another string might go here but does not need to'

];

 

function main() {

  var alreadyCheckedUrls = {};

  var iter = buildSelector().get();

  while(iter.hasNext()) {

    var entity = iter.next();

    var urls = [];

    if(entity.urls().getFinalUrl()) {

      urls.push(entity.urls().getFinalUrl());

    }

    if(entity.urls().getMobileFinalUrl()) {

      urls.push(entity.urls().getMobileFinalUrl());

    }

    for(var i in urls) {

      var url = cleanUrl(urls[i]);

      if(alreadyCheckedUrls[url]) {

        if(alreadyCheckedUrls[url] === 'out of stock') {

          entity.pause();

        } else {

          entity.enable();

        }

      } else {

        var htmlCode;

        try {

          htmlCode = UrlFetchApp.fetch(url).getContentText();

        } catch(e) {

          Logger.log('There was an issue checking:'+url+', Skipping.');

          continue;

        }

        var did_pause = false;

        for(var x in OUT_OF_STOCK_TEXTS) {

          if(htmlCode.indexOf(OUT_OF_STOCK_TEXTS[x]) >= 0) {

            alreadyCheckedUrls[url] = 'out of stock';

            entity.pause();

            did_pause = true;

            break;

          }

        }

        if(!did_pause) {

          alreadyCheckedUrls[url] = 'in stock';

          entity.enable();

        }

      }

      Logger.log('Url: '+url+' is '+alreadyCheckedUrls[url]);

    }

  }

}

 

function cleanUrl(url) {

  if(WRAPPED_URLS) {

    url = url.substr(url.lastIndexOf('http'));

    if(decodeURIComponent(url) !== url) {

      url = decodeURIComponent(url);

    }

  }

  if(STRIP_QUERY_STRING) {

    if(url.indexOf('?')>=0) {

      url = url.split('?')[0];

    }

  }

  if(url.indexOf('{') >= 0) {

    //Let's remove the value track parameters

    url = url.replace(/\{[0-9a-zA-Z]+\}/g,'');

  }

  return url;

}

 

function buildSelector() {

  var selector = (URL_LEVEL === 'Ad') ? AdWordsApp.ads() : AdWordsApp.keywords();

  selector = selector.withCondition('CampaignStatus != DELETED').withCondition('AdGroupStatus != DELETED');

  if(ONLY_ACTIVE) {

    selector = selector.withCondition('CampaignStatus = ENABLED');

    if(URL_LEVEL !== 'Ad') {

      selector = selector.withCondition('AdGroupStatus = ENABLED');

    }

  }

  if(CAMPAIGN_LABEL) {

    if(AdWordsApp.labels().withCondition("Name = '"+CAMPAIGN_LABEL+"'").get().hasNext()) {

      var label = AdWordsApp.labels().withCondition("Name = '"+CAMPAIGN_LABEL+"'").get().next();

      var campIter = label.campaigns().get();

      var campaignNames = [];

      while(campIter.hasNext()) {

        campaignNames.push(campIter.next().getName());

      }

      selector = selector.withCondition("CampaignName IN ['"+campaignNames.join("','")+"']");

    } else {

      Logger.log('WARNING: Campaign label does not exist: '+CAMPAIGN_LABEL);

    }

  }

  return selector;

}

[Anthony Madrigal]

Hi Peter,

After changing the variable name from CAMPAIGN_LABEL to LABEL, you can modify the function buildSelector to the following:

function buildSelector() {
  var selector = (URL_LEVEL === 'Ad') ? AdWordsApp.ads() : AdWordsApp.keywords();
  selector = selector.withCondition('CampaignStatus != DELETED').withCondition('AdGroupStatus != DELETED');
  if(ONLY_ACTIVE) {
    selector = selector.withCondition('CampaignStatus = ENABLED');
    if(URL_LEVEL !== 'Ad') {
      selector = selector.withCondition('AdGroupStatus = ENABLED');
    }
  }

  if(URL_LEVEL == "Ad" && LABEL) {
    if(AdWordsApp.labels().withCondition("Name = '"+ LABEL +"'").get().hasNext()) {
      var label = AdWordsApp.labels().withCondition("Name = '"+ LABEL +"'").get().next();
      var adIter = label.ads().get();
      var adIds = [];
      while(adIter.hasNext()) {
        var ad = adIter.next();
        adIds.push([ad.getAdGroup().getId(), ad.getId()]);
      }
      selector = selector.withIds(adIds);
    } else {
      Logger.log('WARNING: Ad label does not exist: '+ LABEL);
    }
  }
 
  if(URL_LEVEL == "Keyword" && LABEL) {
    if(AdWordsApp.labels().withCondition("Name = '"+ LABEL +"'").get().hasNext()) {
      var label = AdWordsApp.labels().withCondition("Name = '"+ LABEL +"'").get().next();
      var keywordIter = label.keywords().get();
      var keywordIds = [];
      while(keywordIter.hasNext()) {
        var keyword = keywordIter.next();
        keywordIds.push([keyword.getAdGroup().getId(), keyword.getId()]);
      }
      selector = selector.withIds(keywordIds);
    } else {
      Logger.log('WARNING: Keyword label does not exist: '+ LABEL);
    }
  }
  return selector;
}

Let me know if you face any issues.

Regards,

Anthony

AdWords Scripts Team

[Peter Vretenička]

Great, thank you!