Excluded Placement Lists

  • The code provides functions to manage excluded placements in Google Ads scripts.

  • One function retrieves all placements from a specified excluded placement list by name.

  • Another function adds a new placement URL to an existing excluded placement list.

  • Both functions first find the excluded placement list by name and throw an error if it doesn't exist.

Get all the placements in an excluded placement list

function getPlacementsFromExcludedPlacementList(name) {
  const excludedPlacementListIterator =
      AdsApp.excludedPlacementLists()
          .withCondition(`shared_set.name = '${name}'`)
          .get();

  if (!excludedPlacementListIterator.hasNext()) {
    throw new Error(`No excluded placement list with name '${name}' found.`);
  }

  const excludedPlacementList = excludedPlacementListIterator.next();
  return excludedPlacementList.excludedPlacements().get();
}

Add a placement to an excluded placement list

function addPlacementToList(url, name) {
  const excludedPlacementListIterator =
      AdsApp.excludedPlacementLists()
          .withCondition(`shared_set.name = '${name}'`)
          .get();

  if (!excludedPlacementListIterator.hasNext()) {
    throw new Error(`No excluded placement list with name '${name}' found.`);
  }
  const excludedPlacementList = excludedPlacementListIterator.next();
  excludedPlacementList.addExcludedPlacement(url);
}