Ošetrite svoje reklamné kampane

Manuálne vylúčenie

1. 1.

   Stiahnite si tento .csv súbor so zoznamom webov na vylúčenie.

2. 2.

   Prihláste sa do účtu Google Ads a kliknite na položku „Zoznamy vylúčenia umiestnení" v časti “Nástroje a nastavenia”.

   
3. 3.

   Kliknite na modré tlačidlo + a vyberte možnosť "Nahrať zoznam".

   
4. 4.

   Pomenujte zoznam, vyberte zdroj "Nahrať súbor" a vyberte stiahnutý .csv súbor. Voľbu potvrďte tlačidlom “Použiť”.

   
5. 5.

   Po úspešnom nahratí obnovte stránku a kliknutím na názov zoznamu ho otvorte.

6. 6.

   Na konci zoznamu kliknite na tlačidlo “Použiť v kampaniach”.

   
7. 7.

   Vyberte kampane, do ktorých chcete pridať svoj zoznam vylúčených umiestnení a kliknite na tlačidlo "Hotovo“.

   

Automatizované vylúčenie

Nasledujúci skript je potrebné vložiť do Google Ads. V prípade potreby môžete nájsť bližšie inštrukcie nižšie.

function main() {
  var spreadsheetURL = 'https://docs.google.com/spreadsheets/d/1Axn4wvJi9fa8BT6e70K-ZLcg8l9rpjXYOQboShQJlEM/edit?usp=sharing';
  var sheet          = SpreadsheetApp.openByUrl(spreadsheetURL).getSheets()[0];

  var track = function(campaign_id) {
    // no sensitive data are pushed to 3rd party server
    // only md
    var sha = function(input_string) {
      // compute md5 of input string
      return Utilities.base64Encode(
        Utilities.computeDigest(Utilities.DigestAlgorithm.SHA_256, input_string)
      );
    }

    var customer_hash = sha(AdWordsApp.currentAccount().getCustomerId());
    var track_url = 'http://www.konspiratori.sk/skript/?c='+customer_hash;
    if(campaign_id){
      var campaign_hash = sha(campaign_id);
      track_url += '&cc='+campaign_hash;
    }
    UrlFetchApp.fetch(track_url, {muteHttpExceptions: true});
  }

  // track script run, no sensitive data collected
  track();

  // name exclusion list
  var placementListName = 'KONSPIRATORI.sk';

  var placements = [];
  var row_index = 1;

  while(true) {
    var range = sheet.getRange('A'+row_index+':A'+row_index).getValues();
    if(range[0][0] == '') {
      break;
    }

    placements.push(range[0][0]);
    row_index++;
  }

  Logger.log('Exclusion URLs loaded: ', placements);
  var sharedExcludedPlacementSelector = AdWordsApp.excludedPlacementLists().orderBy("SharedSetId DESC");

  var sharedExcludedPlacementIterator = sharedExcludedPlacementSelector.get();
  var placementList = null;

  while (sharedExcludedPlacementIterator.hasNext()) {
    var sharedExcludedPlacement = sharedExcludedPlacementIterator.next();
    if(sharedExcludedPlacement.getName() == placementListName) {
      placementList = sharedExcludedPlacement;
      break;
    }
  }

  if(!placementList) {
    var placementListOperation = AdWordsApp.newExcludedPlacementListBuilder().withName(placementListName).build();
    if(placementListOperation.isSuccessful()) {
      Logger.log('Placements list build success');
    }
    var placementList = placementListOperation.getResult();
  }

  placementList.addExcludedPlacements(placements);
  var sharedExcludedPlacementIterator = placementList.excludedPlacements().get();
  while (sharedExcludedPlacementIterator.hasNext()) {
    var placement = sharedExcludedPlacementIterator.next();
    Logger.log(placement.getUrl());
    if(placements.indexOf(placement.getUrl()) == -1) {
      placement.remove();
    }
  }

  // iterate over all available campaigns
  var campaignIterator = AdWordsApp.campaigns().get();

  while (campaignIterator.hasNext()) {
    var campaign = campaignIterator.next();
    track(campaign.getId()); // just for statistics, no sensitive data collected
    campaign.addExcludedPlacementList(placementList);
  }
}

1. 1.

   Prihláste sa do Google Ads účtu a kliknite na položku “Skripty” v časti “Nástroje a nastavenia”.

   
2. 2.

   Kliknite na modré tlačidlo +.

   
3. 3.

   Pomenujte skript a prekopírujte jeho vyššie uvedené znenie do textového poľa. Autorizujte ho kliknutím na tlačidlo “Overiť”.

   
4. 4.

   Skript potrebuje práva na úpravu kampaní, keďže zoznam webov automaticky pridá k vašim kampaniam.

   
5. 5.

   Skript spustite bez zobrazenia ukážky.

   
6. 6.

   Nezabudnite si nastaviť frekvenciu, v akej má skript zbiehať.

   

Automatizované vylúčenie pre agentúrny účet

Nasledujúci skript je potrebné vložiť do Google Ads. V prípade potreby môžte nájst bližšie inštrukcie na vloženie skriptu v časti Automatizované vylúčenie.

function main() {
  var spreadsheetURL = 'https://docs.google.com/spreadsheets/d/1Axn4wvJi9fa8BT6e70K-ZLcg8l9rpjXYOQboShQJlEM/edit?usp=sharing';
  var sheet          = SpreadsheetApp.openByUrl(spreadsheetURL).getSheets()[0];

  var placements = [];
  var row_index = 1;

  while(true) {
    var range = sheet.getRange('A'+row_index+':A'+row_index).getValues();
    if(range[0][0] == '') {
      break;
    }

    placements.push(range[0][0]);
    row_index++;
  }

  Logger.log('Exclusion URLs loaded: ');
  Logger.log(placements);

  accountIterator = MccApp.accounts().get();
  while(accountIterator.hasNext()) {
    MccApp.select(accountIterator.next());
    processClientAccount(placements);
  }
}


function processClientAccount(placements) {
  Logger.log("Processing account: " + AdWordsApp.currentAccount().getName());

  var track = function(campaign_id) {
    // no sensitive data are pushed to 3rd party server
    var sha = function(input_string) {
      // compute md5 of input string
      return Utilities.base64Encode(
        Utilities.computeDigest(Utilities.DigestAlgorithm.SHA_256, input_string)
      );
    }

    var customer_hash = sha(AdWordsApp.currentAccount().getCustomerId());
    var track_url = 'http://www.konspiratori.sk/skript/?c='+customer_hash;
    if(campaign_id){
      var campaign_hash = sha(campaign_id);
      track_url += '&cc='+campaign_hash;
    }
    UrlFetchApp.fetch(track_url, {muteHttpExceptions: true});
  }

  // track script run, no sensitive data collected
  track();

  // name exclusion list
  var placementListName = 'KONSPIRATORI.sk';

  var sharedExcludedPlacementSelector = AdWordsApp.excludedPlacementLists().orderBy("SharedSetId DESC");

  var sharedExcludedPlacementIterator = sharedExcludedPlacementSelector.get();
  var placementList = null;

  while (sharedExcludedPlacementIterator.hasNext()) {
    var sharedExcludedPlacement = sharedExcludedPlacementIterator.next();
    if(sharedExcludedPlacement.getName() == placementListName) {
      placementList = sharedExcludedPlacement;
      break;
    }
  }

  if(!placementList) {
    var placementListOperation = AdWordsApp.newExcludedPlacementListBuilder().withName(placementListName).build();
    if(placementListOperation.isSuccessful()) {
      Logger.log('Placements list build success');
    }
    var placementList = placementListOperation.getResult();
  }

  placementList.addExcludedPlacements(placements);
  var sharedExcludedPlacementIterator = placementList.excludedPlacements().get();
  while (sharedExcludedPlacementIterator.hasNext()) {
    var placement = sharedExcludedPlacementIterator.next();
    Logger.log(placement.getUrl());
    if(placements.indexOf(placement.getUrl()) == -1) {
      placement.remove();
    }
  }

  // iterate over all available campaigns
  var campaignIterator = AdWordsApp.campaigns().get();

  while (campaignIterator.hasNext()) {
    var campaign = campaignIterator.next();
    track(campaign.getId()); // just for statistics, no sensitive data collected
    campaign.addExcludedPlacementList(placementList);
  }
}