Script Download: Cross Account Negative Keywords

Instructions specific to this script:
`Important:` This script has been deprecated by Optmyzr, which means it will continue to work in old experience but will not be supported by Optmyzr once Google completely moves to the new experience. You can edit or delete the existing settings, but can not add new settings anymore.

Here's what you need to replace to make this work for you...

In the section 'var accountFlags', replace the 10 digit numbers with the account ID of each account that will pull keywords from the shared negatives list. Then for each of those accounts, in the section 'campaignsToUpdate', replace the examples like 'Brand campaign' and 'Sweatshirts campaign' with the campaign names that will use the shared negatives. Multiple campaigns within one account should be comma separated, e.g.

'campaignsToUpdate': 'campaign name 1, campaign name 2',

Update the URL following 'var NEGATIVE_MASTER_LIST' with the URL to your Google spreadsheet that contains the negative keyword list. Be sure this spreadsheet has shared access to your Google account used for logging in to AdWords.

New to scripts ?
See step by step instructions for running AdWords Scripts in general.
Need Assistance? We are here to help! Contact Us

Script Code

Copy script code into your Clipboard.

function main() {
  var accountFlags = {
    '1425022273': {
       'campaignsToUpdate': 'Brand campaign, Another campaign',
     },
    '2676612512': {
       'campaignsToUpdate': 'Sweatshirts campaign',
     }
  };
  
  var accountSelector = MccApp.accounts()
  .withLimit(50);
  
  // Process the account in parallel. The callback method is optional.
  accountSelector.executeInParallel("processAccount", null, JSON.stringify(accountFlags));
}

function processAccount(sharedParameter) {
  var NEGATIVE_MASTER_LIST = "https://docs.google.com/spreadsheets/d/1sfdez-_yuyOpG4LORuQ6jcvIAK6LCcPr3bS9Quh-mqs/edit#gid=0"
  
  var negativeKeywordSpreadsheet = SpreadsheetApp.openByUrl(NEGATIVE_MASTER_LIST);
  var negativeSheet = negativeKeywordSpreadsheet.getActiveSheet();
  var negativeRows = negativeSheet.getDataRange();
  var negativeNumRows = negativeRows.getNumRows();
  var negativeNumColumns = negativeRows.getLastColumn();
  var negativeValues = negativeRows.getValues();
  //var campaignsToUpdate = "Brand";
  
  var customerId = AdWordsApp.currentAccount().getCustomerId().replace(/-/g, "");
  Logger.log("customerId: " + customerId);
  var accountFlags = JSON.parse(sharedParameter);
  Logger.log("accountFlags: " + accountFlags);
  var campaignsToUpdate = accountFlags[customerId].campaignsToUpdate;
  Logger.log("campaignsToUpdate: " + campaignsToUpdate);
  
  if(campaignsToUpdate) {  
    var campaignsToProcess = campaignsToUpdate.split(",");
    Logger.log("campaignsToProcess.length: " + campaignsToProcess.length);
    for(var i = 0; i < campaignsToProcess.length; i++) { 
      //var campaignKeywords = new Array();
      var campaignName = campaignsToProcess[i];
      campaignName = campaignName.replace(/^\s\s*/, '').replace(/\s\s*$/, '');
      Logger.log(campaignName);
      
      var campaigns = AdWordsApp.campaigns()
      .withCondition('Name = "' + campaignName.replace(/[\"]/g, "") + '"')
      .get();
      
      while(campaigns.hasNext()) {
        var campaign = campaigns.next();
      }
      
      
      for(var negativeLineCounter = 0 ; negativeLineCounter < negativeNumRows; negativeLineCounter++) {
        
        var negativeKeyword = "" + negativeValues[negativeLineCounter];
        var negativeKeywordText = negativeKeyword.replace(/[\"\[\]]/gi, '');
        Logger.log(negativeKeywordText);
        campaign.createNegativeKeyword(negativeKeyword);
        
      }
      
    } // END for(var i = 0; i < campaignsToProcess.length; i++)
    
  } // END if(campaignNegativeList)
}

Questions? Feel Free to Contact Us .