Campagnenamen in bulk aanpassen

// Bulk rename Campaign names (MCC)
//
// ABOUT THE SCRIPT
// Rename campaigns in Bulk on MCC level
//
// Created By: Martijn Kraan
// Brightstep.nl
// 
// Created: 28-12-2019
// Last update: 28-12-2019
//
////////////////////////////////////////////////////////////////////

var config = {

    // This is the part where you configure the script

    SPREADSHEET_URL: 'https://docs.google.com/YOUR-SPREADSHEET-URL-HERE',
    // The URL of the Google Sheet that contains your old and new campaign names
    // Grab a copy of the template here: https://docs.google.com/spreadsheets/d/1uwjQBkyhdsGtLhMseShsOa7_lx1UoPq4V1sWGV5V53c/copy

    ACCOUNT_IDS: [],
    LABEL_NAME: '',
    // Pick you preferred method of selecting accounts. Leave empty to process all the accounts in the MCC
    // Fill in the account ID's or apply a label to the account(s) you want to check
    // E.g. ACCOUNT_IDS: ['123-456-7891', '987-654-3211'] or leave empty by using []
    // E.g. LABEL_NAME: 'script: Bulk Rename Campaigns' or leave empty by using ''  

}

////////////////////////////////////////////////////////////////////

function main() {

    var accountSelector;

    if (config.ACCOUNT_IDS.length != 0) {
        accountSelector = AdsManagerApp.accounts()
          .withIds(config.ACCOUNT_IDS)
          .orderBy('Name ASC')
          .withLimit(50);
      
    } else if (config.LABEL_NAME) {
        accountSelector = AdsManagerApp.accounts()
          .withCondition('LabelNames CONTAINS "' + config.LABEL_NAME + '"')
          .orderBy('Name ASC')
          .withLimit(50);
      
    } else {
        accountSelector = AdsManagerApp.accounts()
          .orderBy('Name ASC')
          .withLimit(50)
    }

    accountSelector.executeInParallel('renameCampaigns');

}

function renameCampaigns() {

    var accountName = AdWordsApp.currentAccount().getName();
    var sheet = SpreadsheetApp.openByUrl(config.SPREADSHEET_URL).getSheetByName(accountName)

    if (sheet == null || sheet.isSheetHidden() == true) {
        Logger.log('No sheet found for "' + accountName + '"')
    } else {
        var lastRow = sheet.getLastRow() - 1;
        var values = sheet.getSheetValues(2, 1, lastRow, 2);
      
        for (i = 0; i < values.length; i++) {
            renameSearchCampaign(values[i][0], values[i][1])
            renameShoppingCampaign(values[i][0], values[i][1])
            renameVideoCampaign(values[i][0], values[i][1])
        }
      
        Logger.log('Renamed campaigns for "' + accountName + '"')
    }
}

function renameSearchCampaign(oldName, newName) {
    var campaignSelector = AdWordsApp
        .campaigns()
        .withCondition("Name = '" + oldName + "'")
        .get();
    while (campaignSelector.hasNext()) {
        var campaign = campaignSelector.next();
        campaign.setName(newName);
    }
}

function renameShoppingCampaign(oldName, newName) {
    var campaignSelector = AdWordsApp
        .shoppingCampaigns()
        .withCondition("Name = '" + oldName + "'")
        .get();
    while (campaignSelector.hasNext()) {
        var campaign = campaignSelector.next();
        campaign.setName(newName);
    }
}

function renameVideoCampaign(oldName, newName) {
    var campaignSelector = AdWordsApp
        .videoCampaigns()
        .withCondition("Name = '" + oldName + "'")
        .get();
    while (campaignSelector.hasNext()) {
        var campaign = campaignSelector.next();
        campaign.setName(newName);
    }
}