Automatisches ausschließen von Keywords in Anzeigengruppen [Google Ads Script]

AdWords Accounts mit einer BROAD MATCH / EXACT MATCH Gebotsstrategie können sehr arbeitsintensiv sein. Neben den normalen Arbeiten an einer AdWords Kampagne müssen neue, EXACT Match Keywords bei der BROAD Match Kampagne ausgeschlossen werden. Eine Fleißarbeit, welche mit besseren CPC’s belohnt wird, weil sie sich keine eigene Konkurrenz macht. Um diese Arbeit gegen ein Minimum zu reduzieren, haben wir ein Script entwickelt, welches diese Arbeit übernimmt.

Das Script prüft Kampagnen mit [Campaign Label], sammelt alle Keywords der Anzeigengruppe(n) mit den [Source Label] und fügt diese als negative Keywords in der Anzeigengruppe mit  [Target Label] hinzu. Dabei werden alle vorhandenen, negativen Keywords auf Anzeigengruppenebene gelöscht. 

Setup des Auto Exclude AdWords Scripts

1. Script im MCC Level hinterlegen.
2. Google Docs Spreadsheet aufmachen.
3. Spreadsheet id in das Script kopieren.
4. Script Authorisieren.
5. prefillSpreadsheet auf „true“ setzen, speichern und Vorschau laufen lassen.
6. Label Namen für Campaign Label,  Source Label (Exact Match Anzeigengruppe(n)) und Target Label (Broad MatchAnzeigengruppe(n)) im Spreadsheet vergeben.
7. Entsprechende Label Kamapgnen und AdGroups zuweisen.
8. „Vorschau ausführen“
9. Wenn der Test zufrieden stellend ist, Script ausführen und auf tägliche Ausführung einstellen.

Anmerkungen / Einschränkungen / Hinweise

• Die aktuelle Version ist Script nur auf MCC Level getestet.
• Das Script ist stark von diesem DSA Script inspiriert. Das Original Script läuft auch auf Account Level.
• Dieaktuelle Version wurde nicht auf Fehlertoleranz getestet. Bitte kommentiert Fehler in diesem Post.
• Eine Weiterentwicklung  für weitere Anforderungen ist gerne möglich. Bitte kommentieren!

//------------------------------------------------
// This Script aims to Auto-Exclude Keywords 
// from source labeled AdGroups and place them as
// negative Keywords within another AdGroup within 
// the same Campaign
// This Script was built for Campaigns splitted in
// BROAD MATCH and EXACT MATCH Keywords AdGroups.
// More info: https://webmasterei-prange.de/adwords-script-automatisches-ausschliessen-von-keywords-in-anzeigengruppen
// Strongly inspiered by: Remko van der Zwaag & PDDS see: http://remkovanderzwaag.nl/blog/updated-adwords-script-auto-add-negative-keywords-dsa
//------------------------------------------------

var spreadsheetId = 'ENTER SPREADSHEET ID';
var prefillSpreadsheet = false;                                    // When set to true, gets all accounts from the MCC account
                                                                   // and automagically adds their name and id to the spreadsheet
                                                                   // Use once, doesn't check for existing records
                                                                   // switch back to false after use
                                                                   // PREFERABLY RUN USING PREVIEW (true), CHANGE TO false AND SAVE

// The label a camaign is watched
// * Default - overwritable from spreadsheet
var campaign_label = 'BROAD | EXACT';

// The label on the source campaign(s)
// * Default - overwritable from spreadsheet
var adgroup_source_label = 'EXACT';

// The label on the target group
// * Default - overwritable from spreadsheet
var adgroup_target_label = 'BROAD';


function mapRowToInfo(row) {
  return {
    custId: row[1].trim(),
    cust: row[0],
    campaign_label: row[2],
    adgroup_source_label: row[3],
    adgroup_target_label: row[4]
  };
}


function main() {
  try {
    if (prefillSpreadsheet) {
      MccApp.accounts()
        .withLimit(50)
        .executeInParallel("getSSAccountInfo","saveSSAccountInfo");
    } else {
      var ids = getSpreadsheetIds();
      if (ids.length > 0) {
        MccApp.accounts()
          .withIds(ids)
          .withLimit(50)
          .executeInParallel("processAccount");
      }
    }
  } catch (e) {
    processAccount();
  }
}

function getSSAccountInfo() {
  var result = {
    custId: AdWordsApp.currentAccount().getCustomerId(),
    cust: AdWordsApp.currentAccount().getName()
  };
  Logger.log(result);
  return JSON.stringify(result);
}

function saveSSAccountInfo(response) {
  var ss;
  try {
    ss = SpreadsheetApp.openById(spreadsheetId);
  } catch (e) {
  }
  ss = ss.getSheets()[0];
  ss.appendRow(["Account Name", "Account ID", "Campaign Label", "Source Label", "Target Label"]);
  for (var i in response) {
    if(!response[i].getReturnValue()) { continue; }
    var rep = JSON.parse(response[i].getReturnValue());
    Logger.log(rep);
    ss.appendRow([rep.cust, rep.custId]);
  }
}

function getSpreadsheetIds() {
  var ids = [],
      ss,
      reAWId = /^([0-9]{3})-([0-9]{3})-([0-9]{4})$/;

  try {
    ss = SpreadsheetApp.openById(spreadsheetId);
  } catch (e) {
    return ids;
  }
  ss = ss.getSheets()[0];
  var rows = parseInt(ss.getLastRow());
  var range = ss.getRange("A1:Z" + rows).getValues();
  for (var i = 0; i < rows; i++) {
    var account = mapRowToInfo(range[i]);
    if (!reAWId.test(account.custId) || account.skip) {
      continue;
    }
    ids.push(account.custId);
  }
  return ids;
}

function getAccountInfo() {
  var ss;
  var reAWId = /^([0-9]{3})-([0-9]{3})-([0-9]{4})$/;
  var protoAccount = {
    custId: AdWordsApp.currentAccount().getCustomerId(),
    cust: AdWordsApp.currentAccount().getName(),
    include_label: campaign_label,
    source_label: adgroup_source_label,
    target_label: adgroup_target_label
  };
  try {
    ss = SpreadsheetApp.openById(spreadsheetId);
  } catch (e) {
    return protoAccount;
  }
  ss = ss.getSheets()[0];
  var rows = parseInt(ss.getLastRow());
  var range = ss.getRange("A1:Z" + rows).getValues();
  var ret_account;

  for (var i = 0; i < rows; i++) {
    var account = mapRowToInfo(range[i]);
    if (account.skip) {
      continue;
    }
    if (!reAWId.test(account.custId) || account.custId !== protoAccount.custId) {
      continue;
    }

    for(var key in account) {
      if (account[key] === '' || account[key] === '_ALL_') {
        account[key] = protoAccount[key];
      }
    }
    return account;
  }
  return protoAccount;
}


function processAccount() {
  var account = getAccountInfo();
   try {
     var campaigns = getCampaignsWithLabel(account.campaign_label);
   } catch (ex) {
     return;
   }
   if (campaigns.length === 0) {
     return;
   }
   var include_list = [];
   if (account.campaign_label !== '') {
     try {
       var iterator = getCampaignsWithLabel(account.campaign_label);
       while (iterator.hasNext()) {
         include_list.push(iterator.next().getId());
       }
     } catch (ex) {
       // pass
     }
   }
 while (campaigns.hasNext()) {
   var campaign = campaigns.next();
   var campaignName = campaign.getName()
   var keywords = getSourceAdgroup(adgroup_source_label,campaignName);
   setTargetAdgroupKeywords(adgroup_target_label,keywords,campaignName);
 }
}
 
function getCampaignWithLabel(label) {
  var campaignIterator = getCampaignsWithLabel(label);

  if (campaignIterator.hasNext()) {
    return campaignIterator.next();
  }

  return null;
}

function getCampaignsWithLabel(label) {
  
  return AdWordsApp.campaigns()
    .withCondition("LabelNames CONTAINS_ANY ['" + label + "']")
    .get();
}

function getCampaignsWithLabelArray(label) {
  var iterator = getCampaignsWithLabel(label);
  var campaigns = [];
  while (iterator.hasNext()) {
    campaigns.push(iterator.next());
  }
  return campaigns;
}

function getSourceAdgroup(adgroup_source_label,campaignName){
  var adGroupSelector = AdWordsApp
     .adGroups()
     .withCondition("CampaignName = '" + campaignName + "'")
     .withCondition("LabelNames CONTAINS_ANY ['" + adgroup_source_label + "']")
     .withCondition("Status = ENABLED");
 var adGroupIterator = adGroupSelector.get();
  var keywords = [];
  while (adGroupIterator.hasNext()) {
   var adGroup = adGroupIterator.next();
    keywords = keywords.concat(getKeyWords(adGroup));
  }
  return keywords;
}

function getKeyWords(adGroup){
  var keywords = []
  var keywordSelector = AdWordsApp
     .keywords()
     .withCondition("AdGroupName = '" + adGroup.getName() + "'")
     .withCondition("Status = ENABLED");

 var keywordIterator = keywordSelector.get();
  while(keywordIterator.hasNext()){
    var keyword = keywordIterator.next();
    keyword = keyword.getText();
    keywords.push(keyword)
  }
 return keywords;
}

function setTargetAdgroupKeywords(label,keywords,campaignName){
  var adGroupSelector = AdWordsApp
     .adGroups()
     .withCondition("LabelNames CONTAINS_ANY ['" + label + "']")
     .withCondition("CampaignName = '" + campaignName + "'")
 var adGroupIterator = adGroupSelector.get();
  
 while (adGroupIterator.hasNext()) {
   var adGroup = adGroupIterator.next();
   removeNegativeKeywords(adGroup);
   setNegativeKeywords(keywords,adGroup);
 }
}

function removeNegativeKeywords(targetAdGroup){
  var negativeKeywordSelector = targetAdGroup.negativeKeywords();
  var negativeKeywordIterator = negativeKeywordSelector.get();
  while (negativeKeywordIterator.hasNext()) {
   var negativeKeyword = negativeKeywordIterator.next();
   negativeKeyword.remove();
 }
}

function setNegativeKeywords(keywords,targetAdGroup) {
      //Logger.log(targetAdGroup.getCampaign().getName()+' '+targetAdGroup.getName()+' has AdGroups: '+keywords.length+' Number of Keywords:'+keywords.length);
  for (var i=0;i< keywords.length; i++) {
    var keyword = keywords[i];
      Logger.log(keyword);
      targetAdGroup.createNegativeKeyword(keyword);
  }
}

autoExcludeAdGroupKeyWords.js hosted with ❤ by GitHub

Changelog:

V 0.01 added (testet only on MCC Level)