Марат-блог
Услуги по продвижению и разработке сайта
Отправить заявку
Заказать обратный звонок

Спасибо, Ваша заявка принята.

В ближайшее время менеджер свяжется с Вами.

Главная » Контекстная реклама » Скрипты AdWords и автоматизация работы в аккаунте
Скрипты AdWords и автоматизация работы в аккаунте
Контекстная реклама
45
05 апреля 2018

Скрипты AdWords и автоматизация работы в аккаунте

Нередко случается так, что возникает необходимость использования сторонних инструментов в рамках AdWords-аккаунта. У вас всегда есть возможность поработать с любым JavaScript-кодом, который способен решать любые задачи. Сегодня мы поговорим о некоторых полезных скриптах и о том, в чем же их предназначение.

Битые ссылки

Скрипт занимается поиском объявления с нерабочими ссылками, разные ошибки 404, 5000 и иные.

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

* Find Broken Urls In Your Account

* Version 1.1

* ChangeLog v1.1

*  - Updated to only see Text Ads

* Created By: Russ Savage

* FreeAdWordsScripts.com

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

function main() {

  // You can add more if you want: http://goo.gl/VhIX

  var BAD_CODES = [404,500];

  var TO = ['email@example.com'/*,'email_address_2@example.com'*/];

  var SUBJECT = 'Broken Url Report - ' + _getDateString();

  var HTTP_OPTIONS = {

    muteHttpExceptions:true

  };

   

  //Let's look at ads and keywords for urls

  var iters = [

    //For Ad Level Urls

    AdWordsApp.ads()

      .withCondition("Status = 'ENABLED'")

      .withCondition("AdGroupStatus = 'ENABLED'")

      .withCondition("CampaignStatus = 'ENABLED'")

      .withCondition("Type = 'TEXT_AD'")

      .get(),

    //For Keyword Level Urls

    AdWordsApp.keywords()

      .withCondition("Status = 'ENABLED'")

      .withCondition("DestinationUrl != ''")

      .withCondition("AdGroupStatus = 'ENABLED'")

      .withCondition("CampaignStatus = 'ENABLED'")

      .get()

    ];

  

  var already_checked = {};

  var bad_entities = [];

  for(var x in iters) {

    var iter = iters[x];

    while(iter.hasNext()) {

      var entity = iter.next();

      if(entity.getDestinationUrl() == null) { continue; }

      var url = entity.getDestinationUrl();

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

        //Let's remove the value track parameters

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

      }

      if(already_checked[url]) { continue; }

      var response_code;

      try {

        Logger.log("Testing url: "+url);

        response_code = UrlFetchApp.fetch(url, HTTP_OPTIONS).getResponseCode();

      } catch(e) {

        //Something is wrong here, we should know about it.

        bad_entities.push({e : entity, code : -1});

      }

      if(BAD_CODES.indexOf(response_code) >= 0) {

        //This entity has an issue.  Save it for later.

        bad_entities.push({e : entity, code : response_code});

      }

      already_checked[url] = true;

    }

  }

  var column_names = ['Type','CampaignName','AdGroupName','Id','Headline/KeywordText','ResponseCode','DestUrl'];

  var attachment = column_names.join(",")+"\n";

  for(var i in bad_entities) {

    attachment += _formatResults(bad_entities[i],",");

  }

  if(bad_entities.length > 0) {

    var options = { attachments: [Utilities.newBlob(attachment, 'text/csv', 'bad_urls_'+_getDateString()+'.csv')] };

    var email_body = "There are " + bad_entities.length + " urls that are broken. See attachment for details.";

     

    for(var i in TO) {

      MailApp.sendEmail(TO[i], SUBJECT, email_body, options);

    }

  } 

}

 

//Formats a row of results separated by SEP

function _formatResults(entity,SEP) {

  var e = entity.e;

  if(typeof(e['getHeadline']) != "undefined") {

    //this is an ad entity

    return ["Ad",

            e.getCampaign().getName(),

            e.getAdGroup().getName(),

            e.getId(),

            e.getHeadline(),

            entity.code,

            e.getDestinationUrl()

           ].join(SEP)+"\n";

  } else {

    // and this is a keyword

    return ["Keyword",

            e.getCampaign().getName(),

            e.getAdGroup().getName(),

            e.getId(),

            e.getText(),

            entity.code,

            e.getDestinationUrl()

           ].join(SEP)+"\n";

  }

}

 

//Helper function to format todays date

function _getDateString() {

  return Utilities.formatDate((new Date()), AdWordsApp.currentAccount().getTimeZone(), "yyyy-MM-dd");

}

Показатель качества аккаунта

Каждый день проверяет аккаунт и загружает в единый файл показатель качества аккаунта.

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

* Store Account Level Quality Score in Google Spreadsheet.

* Version 1.1

* ChangeLog v1.1

*  - Changed ACCOUNT_NAME to SHEET_NAME and updated the default value.

*  - Removed getSpreadsheet function

*

* Created By: Russ Savage

* Based on script originally found at: http://goo.gl/rTHbF

* FreeAdWordsScripts.com

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

function main() {

  var SPREADSHEET_URL = "Your Spreadsheet Url Goes Here";

  var SHEET_NAME = 'Sheet1';

  var today = new Date();

  var date_str = [today.getFullYear(),(today.getMonth() + 1),today.getDate()].join("-");

   

  var spreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);

  var qs_sheet = spreadsheet.getSheetByName(SHEET_NAME);

   

  var kw_iter = AdWordsApp.keywords()

    .withCondition("Status = ENABLED")

    .forDateRange("LAST_30_DAYS")

    .withCondition("Impressions > 0")

    .orderBy("Impressions DESC")

    .withLimit(50000)

    .get();

 

  var tot_imps_weighted_qs = 0;

  var tot_imps = 0;

   

  while(kw_iter.hasNext()) {

    var kw = kw_iter.next();

    var kw_stats = kw.getStatsFor("LAST_30_DAYS");

    var imps = kw_stats.getImpressions();

    var qs = kw.getQualityScore();

    tot_imps_weighted_qs += (qs * imps);

    tot_imps += imps;

  }

     

  var acct_qs = tot_imps_weighted_qs / tot_imps;

   

  qs_sheet.appendRow([date_str,acct_qs]);

}

 

Тестирование объявлений

Занимается определением самых эффективных рекламных объявлений, созданных вами.

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

* Automated Creative Testing With Statistical Significance

* Version 2.1

* Changelog v2.1

*   - Fixed INVALID_PREDICATE_ENUM_VALUE

* Changelog v2.0

*   - Fixed bug in setting the correct date

*   - Script now uses a minimum visitors threshold

*        per Ad instead of AdGroup

*   - Added the ability to add the start date as a label to AdGroups

*   - Added ability to check mobile and desktop ads separately

* Changelog v1.1.1 - Fixed bug with getDisplayUrl

* Changelog v1.1

*   - Added ability to only run on some campaigns

*   - Fixed bug in info logging

* Russ Savage

* FreeAdWordsScripts.com

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

var EXTRA_LOGS = true;

var TO = ['user@email.com'];

var CONFIDENCE_LEVEL = 95; // 90%, 95%, or 99% are most common

  

//If you only want to run on some campaigns, apply a label to them

//and put the name of the label here.  Leave blank to run on all campaigns.

var CAMPAIGN_LABEL = '';

  

//These two metrics are the components that make up the metric you

//want to compare. For example, this measures CTR = Clicks/Impressions

//Other examples might be:

// Cost Per Conv = Cost/Conversions

// Conversion Rate = Conversions/Clicks

// Cost Per Click = Cost/Clicks

var VISITORS_METRIC = 'Impressions';

var CONVERSIONS_METRIC = 'Clicks';

//This is the number of impressions the Ad needs to have in order

//to start measuring the results of a test.

var VISITORS_THRESHOLD = 100;

 

//Setting this to true to enable the script to check mobile ads

//against other mobile ads only. Enabling this will start new tests

//in all your AdGroups so only enable this after you have completed

//a testing cycle.

var ENABLE_MOBILE_AD_TESTING = false;

 

//Set this on the first run which should be the approximate last time

//you started a new creative test. After the first run, this setting

//will be ignored.

var OVERRIDE_LAST_TOUCHED_DATE = 'Jan 1, 2014';

  

var LOSER_LABEL = 'Loser '+CONFIDENCE_LEVEL+'% Confidence';

var CHAMPION_LABEL = 'Current Champion';

 

// Set this to true and the script will apply a label to

// each AdGroup to let you know the date the test started

// This helps you validate the results of the script.

var APPLY_TEST_START_DATE_LABELS = true;

  

//These come from the url when you are logged into AdWords

//Set these if you want your emails to link directly to the AdGroup

var __c = '';

var __u = '';

  

function main() {

  createLabelIfNeeded(LOSER_LABEL,"#FF00FF"); //Set the colors of the labels here

  createLabelIfNeeded(CHAMPION_LABEL,"#0000FF"); //Set the colors of the labels here

    

  //Let's find all the AdGroups that have new tests starting

  var currentAdMap = getCurrentAdsSnapshot();

  var previousAdMap = getPreviousAdsSnapshot();

  if(previousAdMap) {

    currentAdMap = updateCurrentAdMap(currentAdMap,previousAdMap);

  }

  storeAdsSnapshot(currentAdMap);

  previousAdMap = null;

    

  //Now run through the AdGroups to find tests

   var agSelector = AdWordsApp.adGroups()

    .withCondition('CampaignStatus = ENABLED')

    .withCondition('AdGroupStatus = ENABLED')

    .withCondition('Status = ENABLED');

  if(CAMPAIGN_LABEL !== '') {

    var campNames = getCampaignNames();

    agSelector = agSelector.withCondition("CampaignName IN ['"+campNames.join("','")+"']");

  }

  var agIter = agSelector.get();

  var todayDate = getDateString(new Date(),'yyyyMMdd');

  var touchedAdGroups = [];

  var finishedEarly = false;

  while(agIter.hasNext()) {

    var ag = agIter.next();

 

    var numLoops = (ENABLE_MOBILE_AD_TESTING) ? 2 : 1;

    for(var loopNum = 0; loopNum < numLoops; loopNum++) {

      var isMobile = (loopNum == 1);

      var rowKey;

      if(isMobile) {

        info('Checking Mobile Ads in AdGroup: "'+ag.getName()+'"');

        rowKey = [ag.getCampaign().getId(),ag.getId(),'Mobile'].join('-');

      } else {

        info('Checking Ads in AdGroup: "'+ag.getName()+'"');

        rowKey = [ag.getCampaign().getId(),ag.getId()].join('-');

      }

 

      if(!currentAdMap[rowKey]) {  //This shouldn't happen

        warn('Could not find AdGroup: '+ag.getName()+' in current ad map.');

        continue;

      }

       

      if(APPLY_TEST_START_DATE_LABELS) {

        var dateLabel;

        if(isMobile) {

          dateLabel = 'Mobile Tests Started: '+getDateString(currentAdMap[rowKey].lastTouched,'yyyy-MM-dd');

        } else {

          dateLabel = 'Tests Started: '+getDateString(currentAdMap[rowKey].lastTouched,'yyyy-MM-dd');

        }

 

        createLabelIfNeeded(dateLabel,"#8A2BE2");

        //remove old start date

        var labelIter = ag.labels().withCondition("Name STARTS_WITH '"+dateLabel.split(':')[0]+"'")

                                   .withCondition("Name != '"+dateLabel+"'").get();

        while(labelIter.hasNext()) {

          var label = labelIter.next();

          ag.removeLabel(label.getName());

          if(!label.adGroups().get().hasNext()) {

            //if there are no more entities with that label, delete it.

            label.remove();

          }

        }

        applyLabel(ag,dateLabel);

      }

           

      //Here is the date range for the test metrics

      var lastTouchedDate = getDateString(currentAdMap[rowKey].lastTouched,'yyyyMMdd');

      info('Last Touched Date: '+lastTouchedDate+' Todays Date: '+ todayDate);

      if(lastTouchedDate === todayDate) {

        //Special case where the AdGroup was updated today which means a new test has started.

        //Remove the old labels, but keep the champion as the control for the next test

        info('New test is starting in AdGroup: '+ag.getName());

        removeLoserLabelsFromAds(ag,isMobile);

        continue;

      }

       

      //Is there a previous winner? if so we should use it as the control.

      var controlAd = checkForPreviousWinner(ag,isMobile);

       

      //Here we order by the Visitors metric and use that as a control if we don't have one

      var adSelector = ag.ads().withCondition('Status = ENABLED').withCondition('AdType = TEXT_AD');

      if(!AdWordsApp.getExecutionInfo().isPreview()) {

        adSelector = adSelector.withCondition("LabelNames CONTAINS_NONE ['"+[LOSER_LABEL,CHAMPION_LABEL].join("','")+"']");

      }

      var adIter = adSelector.forDateRange(lastTouchedDate, todayDate)

                             .orderBy(VISITORS_METRIC+" DESC")

                             .get();

      if( (controlAd == null && adIter.totalNumEntities() < 2) ||

          (controlAd != null && adIter.totalNumEntities() < 1) )

      {

        info('AdGroup did not have enough eligible Ads. Had: '+adIter.totalNumEntities()+', Needed at least 2');

        continue;

      }

       

      if(!controlAd) {

        info('No control set for AdGroup. Setting one.');

        while(adIter.hasNext()) {

          var ad = adIter.next();

          if(shouldSkip(isMobile,ad)) { continue; }

          controlAd = ad;

          break;

        }

        if(!controlAd) {

          continue;

        }

        applyLabel(controlAd,CHAMPION_LABEL);

      }

       

      while(adIter.hasNext()) {

        var testAd = adIter.next();

        if(shouldSkip(isMobile,testAd)) { continue; }

        //The Test object does all the heavy lifting for us.

        var test = new Test(controlAd,testAd,

                            CONFIDENCE_LEVEL,

                            lastTouchedDate,todayDate,

                            VISITORS_METRIC,CONVERSIONS_METRIC);

        info('Control - Visitors: '+test.getControlVisitors()+' Conversions: '+test.getControlConversions());

        info('Test    - Visitors: '+test.getTestVisitors()+' Conversions: '+test.getTestConversions());

        info('P-Value: '+test.getPValue());

         

        if(test.getControlVisitors() < VISITORS_THRESHOLD ||

           test.getTestVisitors() < VISITORS_THRESHOLD)

        {

          info('Not enough visitors in the control or test ad.  Skipping.');

          continue;

        }

         

        //Check for significance

        if(test.isSignificant()) {

          var loser = test.getLoser();

          removeLabel(loser,CHAMPION_LABEL); //Champion has been dethroned

          applyLabel(loser,LOSER_LABEL);

           

          //The winner is the new control. Could be the same as the old one.

          controlAd = test.getWinner();

          applyLabel(controlAd,CHAMPION_LABEL);

           

          //We store some metrics for a nice email later

          if(!ag['touchCount']) {

            ag['touchCount'] = 0;

            touchedAdGroups.push(ag);

          }

          ag['touchCount']++;

        }

      }

       

      //Let's bail if we run out of time so we can send the emails.

      if((!AdWordsApp.getExecutionInfo().isPreview() && AdWordsApp.getExecutionInfo().getRemainingTime() < 60) ||

         ( AdWordsApp.getExecutionInfo().isPreview() && AdWordsApp.getExecutionInfo().getRemainingTime() < 10) )

      {

        finishedEarly = true;

        break;

      }

    }

  }

  if(touchedAdGroups.length > 0) {

    sendMailForTouchedAdGroups(touchedAdGroups,finishedEarly);

  }

  beacon();

}

  

// A helper function to return the list of campaign ids with a label for filtering

function getCampaignNames() {

  var campNames = [];

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

  if(labelIter.hasNext()) {

    var label = labelIter.next();

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

    while(campIter.hasNext()) {

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

    }

  }

  return campNames;

}

  

function applyLabel(entity,label) {

  if(!AdWordsApp.getExecutionInfo().isPreview()) {

    entity.applyLabel(label);

  } else {

    var adText = (entity.getEntityType() === 'Ad') ? [entity.getHeadline(),entity.getDescription1(),

                                                      entity.getDescription2(),entity.getDisplayUrl()].join(' ')

                                                   : entity.getName();

    Logger.log('PREVIEW: Would have applied label: '+label+' to Entity: '+ adText);

  }

}

  

function removeLabel(ad,label) {

  if(!AdWordsApp.getExecutionInfo().isPreview()) {

    ad.removeLabel(label);

  } else {

    var adText = [ad.getHeadline(),ad.getDescription1(),ad.getDescription2(),ad.getDisplayUrl()].join(' ');

    Logger.log('PREVIEW: Would have removed label: '+label+' from Ad: '+ adText);

  }

}

  

// This function checks if the AdGroup has an Ad with a Champion Label

// If so, the new test should use that as the control.

function checkForPreviousWinner(ag,isMobile) {

  var adSelector = ag.ads().withCondition('Status = ENABLED')

                           .withCondition('AdType = TEXT_AD');

  if(!AdWordsApp.getExecutionInfo().isPreview()) {

    adSelector = adSelector.withCondition("LabelNames CONTAINS_ANY ['"+CHAMPION_LABEL+"']");

  }

  var adIter = adSelector.get();

  while(adIter.hasNext()) {

    var ad = adIter.next();

    if(shouldSkip(isMobile,ad)) { continue; }

    info('Found a previous winner. Using it as the control.');

    return ad;

  }

  return null;

}

 

function shouldSkip(isMobile,ad) {

  if(isMobile) {

    if(!ad.isMobilePreferred()) {

      return true;

    }

  } else {

    if(ad.isMobilePreferred()) {

      return true;

    }

  }

  return false;

}

  

// This function sends the email to the people in the TO array.

// If the script finishes early, it adds a notice to the email.

function sendMailForTouchedAdGroups(ags,finishedEarly) {

  var htmlBody = '<html><head></head><body>';

  if(finishedEarly) {

    htmlBody += 'The script was not able to check all AdGroups. ' +

                'It will check additional AdGroups on the next run.<br / >' ;

  }

  htmlBody += 'The following AdGroups have one or more creative tests that have finished.' ;

  htmlBody += buildHtmlTable(ags);

  htmlBody += '<p><small>Generated by <a href="http://www.freeadwordsscripts.com">FreeAdWordsScripts.com</a></small></p>' ;

  htmlBody += '</body></html>';

  var options = {

    htmlBody : htmlBody,

  };

  var subject = ags.length + ' Creative Test(s) Completed - ' +

    Utilities.formatDate(new Date(), AdWordsApp.currentAccount().getTimeZone(), 'yyyy-MM-dd');

  for(var i in TO) {

    MailApp.sendEmail(TO[i], subject, ags.length+' AdGroup(s) have creative tests that have finished.', options);

  }

}

 

// This function uses my HTMLTable object to build the styled html table for the email.

function buildHtmlTable(ags) {

  var table = new HTMLTable();

  //CSS from: http://coding.smashingmagazine.com/2008/08/13/top-10-css-table-designs/

  //Inlined using: http://inlinestyler.torchboxapps.com/

  table.setTableStyle(['font-family: "Lucida Sans Unicode","Lucida Grande",Sans-Serif;',

                       'font-size: 12px;',

                       'background: #fff;',

                       'margin: 45px;',

                       'width: 480px;',

                       'border-collapse: collapse;',

                       'text-align: left'].join(''));

  table.setHeaderStyle(['font-size: 14px;',

                        'font-weight: normal;',

                        'color: #039;',

                        'padding: 10px 8px;',

                        'border-bottom: 2px solid #6678b1'].join(''));

  table.setCellStyle(['border-bottom: 1px solid #ccc;',

                      'padding: 4px 6px'].join(''));

  table.addHeaderColumn('#');

  table.addHeaderColumn('Campaign Name');

  table.addHeaderColumn('AdGroup Name');

  table.addHeaderColumn('Tests Completed');

  for(var i in ags) {

    table.newRow();

    table.addCell(table.getRowCount());

    var campName = ags[i].getCampaign().getName();

    var name = ags[i].getName();

    var touchCount = ags[i]['touchCount'];

    var campLink, agLink;

    if(__c !== '' && __u !== '') { // You should really set these.

      campLink = getUrl(ags[i].getCampaign(),'Ad groups');

      agLink = getUrl(ags[i],'Ads');

      table.addCell(a(campLink,campName));

      table.addCell(a(agLink,name));

    } else {

      table.addCell(campName);

      table.addCell(name);

    }

    table.addCell(touchCount,'text-align: right');

  }

  return table.toString();

}

 

// Just a helper to build the html for a link.

function a(link,val) {

  return '<a href="'+link+'">'+val+'</a>';

}

  

// This function finds all the previous losers and removes their label.

// It is used when the script detects a change in the AdGroup and needs to

// start a new test.

function removeLoserLabelsFromAds(ag,isMobile) {

  var adSelector = ag.ads().withCondition('Status = ENABLED');

  if(!AdWordsApp.getExecutionInfo().isPreview()) {

    adSelector = adSelector.withCondition("LabelNames CONTAINS_ANY ['"+LOSER_LABEL+"']");

  }

  var adIter = adSelector.get();

  while(adIter.hasNext()) {

    var ad = adIter.next();

    if(shouldSkip(isMobile,ad)) { continue; }

    removeLabel(ad,LOSER_LABEL);

  }

}

  

// A helper function to create a new label if it doesn't exist in the account.

function createLabelIfNeeded(name,color) {

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

    info('Creating label: "'+name+'"');

    AdWordsApp.createLabel(name,"",color);

  } else {

    info('Label: "'+name+'" already exists.');

  }

}

  

// This function compares the previous and current Ad maps and

// updates the current map with the date that the AdGroup was last touched.

// If OVERRIDE_LAST_TOUCHED_DATE is set and there is no previous data for the

// AdGroup, it uses that as the last touched date.

function updateCurrentAdMap(current,previous) {

  info('Updating the current Ads map using historical snapshot.');

  for(var rowKey in current) {

    var currentAds = current[rowKey].adIds;

    var previousAds = (previous[rowKey]) ? previous[rowKey].adIds : [];

    if(currentAds.join('-') === previousAds.join('-')) {

      current[rowKey].lastTouched = previous[rowKey].lastTouched;

    }

    if(previousAds.length === 0 && OVERRIDE_LAST_TOUCHED_DATE !== '') {

      current[rowKey].lastTouched = new Date(OVERRIDE_LAST_TOUCHED_DATE);

    }

    //if we make it here without going into the above if statements

    //then the adgroup has changed and we should keep the new date

  }

  info('Finished updating the current Ad map.');

  return current;

}

  

// This stores the Ad map snapshot to a file so it can be used for the next run.

// The data is stored as a JSON string for easy reading later.

function storeAdsSnapshot(data) {

  info('Storing the Ads snapshot to Google Drive.');

  var fileName = getSnapshotFilename();

  var file = DriveApp.getFilesByName(fileName).next();

  file.setContent(Utilities.jsonStringify(data));

  info('Finished.');

}

  

// This reads the JSON formatted previous snapshot from a file on GDrive

// If the file doesn't exist, it creates a new one and returns an empty map.

function getPreviousAdsSnapshot() {

  info('Loading the previous Ads snapshot from Google Drive.');

  var fileName = getSnapshotFilename();

  var fileIter = DriveApp.getFilesByName(fileName);

  if(fileIter.hasNext()) {

    return Utilities.jsonParse(fileIter.next().getBlob().getDataAsString());

  } else {

    DriveApp.createFile(fileName, '');

    return {};

  }

}

  

// A helper function to build the filename for the snapshot.

function getSnapshotFilename() {

  var accountId = AdWordsApp.currentAccount().getCustomerId();

  return (accountId + ' Ad Testing Script Snapshot.json');

}

  

// This function pulls the Ad Performance Report which is the fastest

// way to build a snapshot of the current ads in the account.

// This only pulls in active text ads.

function getCurrentAdsSnapshot() {

  info('Running Ad Performance Report to get current Ads snapshot.');

  var OPTIONS = { includeZeroImpressions : true };

  var cols = ['CampaignId','AdGroupId','Id','DevicePreference','Impressions'];

  var report = 'AD_PERFORMANCE_REPORT';

  var query = ['select',cols.join(','),'from',report,

               'where AdType = TEXT_AD',

               'and AdNetworkType1 = SEARCH',

               'and CampaignStatus = ENABLED',

               'and AdGroupStatus = ENABLED',

               'and Status = ENABLED',

               'during','TODAY'].join(' ');

  var results = {}; // { campId-agId : row, ... }

  var reportIter = AdWordsApp.report(query, OPTIONS).rows();

  while(reportIter.hasNext()) {

    var row = reportIter.next();

    var rowKey = [row.CampaignId,row.AdGroupId].join('-');

    if(ENABLE_MOBILE_AD_TESTING && row.DevicePreference == 30001) {

      rowKey += '-Mobile';

    }

    if(!results[rowKey]) {

      results[rowKey] = { adIds : [], lastTouched : new Date() };

    }

    results[rowKey].adIds.push(row.Id);

  }

  for(var i in results) {

    results[i].adIds.sort();

  }

  info('Finished building the current Ad map.');

  return results;

}

  

//Helper function to format the date

function getDateString(date,format) {

  return Utilities.formatDate(new Date(date),AdWordsApp.currentAccount().getTimeZone(),format);

}

  

// Function to build out the urls for deeplinking into the AdWords account.

// For this to work, you need to have __c and __u filled in.

// Taken from: http://www.freeadwordsscripts.com/2013/11/building-entity-deep-links-with-adwords.html

function getUrl(entity,tab) {

  var customerId = __c;

  var effectiveUserId = __u;

  var decodedTab = getTab(tab); 

     

  var base = 'https://adwords.google.com/cm/CampaignMgmt?';

  var url = base+'__c='+customerId+'&__u='+effectiveUserId+'#';

    

  if(typeof entity['getEntityType'] === 'undefined') {

    return url+'r.ONLINE.di&app=cm';

  }

    

  var type = entity.getEntityType()

  if(type === 'Campaign') {

    return url+'c.'+entity.getId()+'.'+decodedTab+'&app=cm';

  }

  if(type === 'AdGroup') {

    return url+'a.'+entity.getId()+'_'+entity.getCampaign().getId()+'.'+decodedTab+'&app=cm';

  }

  if(type === 'Keyword') {

    return url+'a.'+entity.getAdGroup().getId()+'_'+entity.getCampaign().getId()+'.key&app=cm';

  }

  if(type === 'Ad') {

    return url+'a.'+entity.getAdGroup().getId()+'_'+entity.getCampaign().getId()+'.create&app=cm';

  }

  return url+'r.ONLINE.di&app=cm';

     

  function getTab(tab) {

    var mapping = {

      'Ad groups':'ag','Settings:All settings':'st_sum',

      'Settings:Locations':'st_loc','Settings:Ad schedule':'st_as',

      'Settings:Devices':'st_p','Ads':'create',

      'Keywords':'key','Audiences':'au','Ad extensions':'ae',

      'Auto targets':'at','Dimensions' : 'di'

    };

    if(mapping[tab]) { return mapping[tab]; }

    return 'key'; //default to keyword tab

  }

}

  

// Helper function to print info logs

function info(msg) {

  if(EXTRA_LOGS) {

    Logger.log('INFO: '+msg);

  }

}

  

// Helper function to print more serious warnings

function warn(msg) {

  Logger.log('WARNING: '+msg);

}

  

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

* Track Script Runs in Google Analytics

* Created By: Russ Savage

* FreeAdWordsScripts.com

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

function beacon() {

  var TAG_ID = 'UA-40187672-2';

  var CAMPAIGN_SOURCE = 'adwords';

  var CAMPAIGN_MEDIUM = 'scripts';

  var CAMPAIGN_NAME = 'AdTestingScriptV2_1';

  var HOSTNAME = 'www.freeadwordsscripts.com';

  var PAGE = '/Ad_Testing_Script_v2_1';

  if(AdWordsApp.getExecutionInfo().isPreview()) {

    PAGE += '/preview';

  }

  var DOMAIN_LINK = 'http://'+HOSTNAME+PAGE;

   

  //Pulled from: http://stackoverflow.com/questions/105034/how-to-create-a-guid-uuid-in-javascript

  var uuid = 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g,

    function(c) {var r = Math.random()*16|0,v=c=='x'?r:r&0x3|0x8;return v.toString(16);});

     

  var url = 'http://www.google-analytics.com/collect?';

  var payload = {

    'v':1,'tid':TAG_ID,'cid':uuid,   

    't':'pageview','cs':CAMPAIGN_SOURCE,'cm':CAMPAIGN_MEDIUM,'cn':CAMPAIGN_NAME,

    'dl':DOMAIN_LINK

  };

  var qs = '';

  for(var key in payload) {

    qs += key + '=' + encodeURIComponent(payload[key]) + '&';

  }

  url += qs.substring(0,qs.length-1);

  UrlFetchApp.fetch(url);

}

  

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

* Test: A class for runnning A/B Tests for Ads

* Version 1.0

* Based on VisualWebsiteOptimizer logic: http://goo.gl/jiImn

* Russ Savage

* FreeAdWordsScripts.com

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

// A description of the parameters:

// control - the control Ad, test - the test Ad

// startDate, endDate - the start and end dates for the test

// visitorMetric, conversionMetric - the components of the metric to use for the test

function Test(control,test,desiredConf,startDate,endDate,visitorMetric,conversionMetric) {

  this.desiredConfidence = desiredConf/100;

  this.verMetric = visitorMetric;

  this.conMetric = conversionMetric;

  this.startDate = startDate;

  this.endDate = endDate;

  this.winner;

    

  this.controlAd = control;

  this.controlStats = (this.controlAd['stats']) ? this.controlAd['stats'] : this.controlAd.getStatsFor(this.startDate, this.endDate);

  this.controlAd['stats'] = this.controlStats;

  this.controlVisitors = this.controlStats['get'+this.verMetric]();

  this.controlConversions = this.controlStats['get'+this.conMetric]();

  this.controlCR = getConversionRate(this.controlVisitors,this.controlConversions);

    

  this.testAd = test;

  this.testStats = (this.testAd['stats']) ? this.testAd['stats'] : this.testAd.getStatsFor(this.startDate, this.endDate);

  this.testAd['stats'] = this.testStats;

  this.testVisitors = this.testStats['get'+this.verMetric]();

  this.testConversions = this.testStats['get'+this.conMetric]();

  this.testCR = getConversionRate(this.testVisitors,this.testConversions);

    

  this.pValue;

    

  this.getControlVisitors = function() { return this.controlVisitors; }

  this.getControlConversions = function() { return this.controlConversions; }

  this.getTestVisitors = function() { return this.testVisitors; }

  this.getTestConversions = function() { return this.testConversions; }

    

  // Returns the P-Value for the two Ads

  this.getPValue = function() {

    if(!this.pValue) {

      this.pValue = calculatePValue(this);

    }

    return this.pValue;

  };

    

  // Determines if the test has hit significance

  this.isSignificant = function() {

    var pValue = this.getPValue();

    if(pValue && pValue !== 'N/A' && (pValue >= this.desiredConfidence || pValue <= (1 - this.desiredConfidence))) {

      return true;

    }

    return false;

  }

    

  // Returns the winning Ad

  this.getWinner = function() {

    if(this.decideWinner() === 'control') {

      return this.controlAd;

    }

    if(this.decideWinner() === 'challenger') {

      return this.testAd;

    }

    return null;

  };

    

  // Returns the losing Ad

  this.getLoser = function() {

    if(this.decideWinner() === 'control') {

      return this.testAd;

    }

    if(this.decideWinner() === 'challenger') {

      return this.controlAd;

    }

    return null;

  };

    

  // Determines if the control or the challenger won

  this.decideWinner = function () {

    if(this.winner) {

      return this.winner;

    }

    if(this.isSignificant()) {

      if(this.controlCR >= this.testCR) {

        this.winner = 'control';

      } else {

        this.winner = 'challenger';

      }

    } else {

      this.winner = 'no winner';

    }

    return this.winner;

  }

    

  // This function returns the confidence level for the test

  function calculatePValue(instance) {

    var control = {

      visitors: instance.controlVisitors,

      conversions: instance.controlConversions,

      cr: instance.controlCR

    };

    var challenger = {

      visitors: instance.testVisitors,

      conversions: instance.testConversions,

      cr: instance.testCR

    };

    var z = getZScore(control,challenger);

    if(z == -1) { return 'N/A'; }

    var norm = normSDist(z);

    return norm;

  }

    

  // A helper function to make rounding a little easier

  function round(value) {

    var decimals = Math.pow(10,5);

    return Math.round(value*decimals)/decimals;

  }

    

  // Return the conversion rate for the test

  function getConversionRate(visitors,conversions) {

    if(visitors == 0) {

      return -1;

    }

    return conversions/visitors;

  }

    

  function getStandardError(cr,visitors) {

    if(visitors == 0) {

      throw 'Visitors cannot be 0.';

    }

    return Math.sqrt((cr*(1-cr)/visitors));

  }

    

  function getZScore(c,t) {

    try {

      if(!c['se']) { c['se'] = getStandardError(c.cr,c.visitors); }

      if(!t['se']) { t['se'] = getStandardError(t.cr,t.visitors); }

    } catch(e) {

      Logger.log(e);

      return -1;

    }

      

    if((Math.sqrt(Math.pow(c.se,2)+Math.pow(t.se,2))) == 0) {

      Logger.log('WARNING: Somehow the denominator in the Z-Score calulator was 0.');

      return -1;

    }

    return ((c.cr-t.cr)/Math.sqrt(Math.pow(c.se,2)+Math.pow(t.se,2)));

  }

    

  //From: http://www.codeproject.com/Articles/408214/Excel-Function-NORMSDIST-z

  function normSDist(z) {

    var sign = 1.0;

    if (z < 0) { sign = -1; }

    return round(0.5 * (1.0 + sign * erf(Math.abs(z)/Math.sqrt(2))));

  }

    

  // From: http://picomath.org/javascript/erf.js.html

  function erf(x) {

    // constants

    var a1 =  0.254829592;

    var a2 = -0.284496736;

    var a3 =  1.421413741;

    var a4 = -1.453152027;

    var a5 =  1.061405429;

    var p  =  0.3275911;

      

    // Save the sign of x

    var sign = 1;

    if (x < 0) {

      sign = -1;

    }

    x = Math.abs(x);

      

    // A&S formula 7.1.26

    var t = 1.0/(1.0 + p*x);

    var y = 1.0 - (((((a5*t + a4)*t) + a3)*t + a2)*t + a1)*t*Math.exp(-x*x);

      

    return sign*y;

  }

}

  

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

* HTMLTable: A class for building HTML Tables

* Version 1.0

* Russ Savage

* FreeAdWordsScripts.com

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

function HTMLTable() {

  this.headers = [];

  this.columnStyle = {};

  this.body = [];

  this.currentRow = 0;

  this.tableStyle;

  this.headerStyle;

  this.cellStyle;

   

  this.addHeaderColumn = function(text) {

    this.headers.push(text);

  };

   

  this.addCell = function(text,style) {

    if(!this.body[this.currentRow]) {

      this.body[this.currentRow] = [];

    }

    this.body[this.currentRow].push({ val:text, style:(style) ? style : '' });

  };

   

  this.newRow = function() {

    if(this.body != []) {

      this.currentRow++;

    }

  };

   

  this.getRowCount = function() {

    return this.currentRow;

  };

   

  this.setTableStyle = function(css) {

    this.tableStyle = css;

  };

   

  this.setHeaderStyle = function(css) {

    this.headerStyle = css;

  };

   

  this.setCellStyle = function(css) {

    this.cellStyle = css;

    if(css[css.length-1] !== ';') {

      this.cellStyle += ';';

    }

  };

   

  this.toString = function() {

    var retVal = '<table ';

    if(this.tableStyle) {

      retVal += 'style="'+this.tableStyle+'"';

    }

    retVal += '>'+_getTableHead(this)+_getTableBody(this)+'</table>';

    return retVal;

  };

   

  function _getTableHead(instance) {

    var headerRow = '';

    for(var i in instance.headers) {

      headerRow += _th(instance,instance.headers[i]);

    }

    return '<thead><tr>'+headerRow+'</tr></thead>';

  };

   

  function _getTableBody(instance) {

    var retVal = '<tbody>';

    for(var r in instance.body) {

      var rowHtml = '<tr>';

      for(var c in instance.body[r]) {

        rowHtml += _td(instance,instance.body[r][c]);

      }

      rowHtml += '</tr>';

      retVal += rowHtml;

    }

    retVal += '</tbody>';

    return retVal;

  };

   

  function _th(instance,val) {

    var retVal = '<th scope="col" ';

    if(instance.headerStyle) {

      retVal += 'style="'+instance.headerStyle+'"';

    }

    retVal += '>'+val+'</th>';

    return retVal;

  };

   

  function _td(instance,cell) {

    var retVal = '<td ';

    if(instance.cellStyle || cell.style) {

      retVal += 'style="';

      if(instance.cellStyle) {

        retVal += instance.cellStyle;

      }

      if(cell.style) {

        retVal += cell.style;

      }

      retVal += '"';

    }

    retVal += '>'+cell.val+'</td>';

    return retVal;

  };

}

 

Товары, которых нет в наличии

Проверяет на сайте товары, которых нет в наличии, и выключает рекламу по ним.

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

* 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;

}

Добавление скриптов в аккаунт AdWords

Рассмотрим данный процесс на примере скрипта проверки битых ссылок.

Зайдите в ваш аккаунт, откройте «Кампании» и в углу слева найдите вкладку «Операции над несколькими элементами». В данном разделе вы найдете «Скрипты» либо «Создание скриптов и управление ими»:

 

После того, как вы осуществите переход в «Скрипты», вы увидите клавишу «+Скрипт». Посредством клика по ней вы сможете добавить скрипт в свой аккаунт.

 

После этого стоит дать скрипту имя и поменять обычный фрагмент кода на готовый скрипт. 

 

После добавления скрипта нужно произвести все изменения. Кликаем «Сохранить» и «Авторизация». Необходимо предоставить скрипту доступ к обработке информации в аккаунте и кликнуть «Просмотр».

 

После того, как закончится просмотр, нужно кликнуть «Выполнить скрипт». Таким образом вы увидите, что скрипт находится в работе и сколько времени на это уходит.

Помимо этого, у вас есть возможность создать расписание для работы скрипта в автоматическом режиме, через необходимый период. Это возможно посредством нажатия на «+Создать расписание».

 

Надеемся, что скрипты помогут вам автоматизировать работу аккаунта AdWords и сделать ее более удобной и быстрой. Успехов!