Bidadjustments for locations

// Copyright 2021. Increase BV. All Rights Reserved.
//
// Created By: Tibbe van Asten
// for Increase B.V.
// 
// Created: 20-07-2018
// Last update: 14-01-2021 - Add label to campaign
//
// ABOUT THE SCRIPT
// With this script we adjust the biddings for locations in 
// active campaigns.
//
////////////////////////////////////////////////////////////////////

var config = {

  LOG : true,
  DATE_RANGE : "LAST_30_DAYS",
  
  // Add location ID's to skip from bidadjustments, comma seperated
  // Find location ID's: https://developers.google.com/adwords/api/docs/appendix/geotargeting
  EXCLUDE_LOCATIONS : "",
  
  // Optional: Use minimum conversions and/or cost to select devices.
  // Cost is in account currency. Leave empty to skip.
  MINIMUM_CONVERIONS : "2",
  MINIMUM_CLICKS : "50",
  MINIMUM_COST : "10",
  
  // Bidadjustments won't be higher then MAX_BID and not lower then MIN_BID.
  // Examples: 1.2 = +20%, 0.8 = -20%, 2 = +100%.
  MAX_BID : 1,
  MIN_BID : 0.8,
  
  // Optional: Use a label to make a selection of campaigns.
  // Leave empty to skip.
  LABEL : ""
  
}

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

function main() {
    
  var locationIterator = AdsApp
    .targeting()
    .targetedLocations()
    .withCondition("CampaignStatus = ENABLED")
    .get();
  
  while(locationIterator.hasNext()) {
    var location = locationIterator.next();
    
    // Skip location if campaigns doesn't contain the predefined label.
    if(!location.getCampaign() || (config.LABEL != "" && !location.getCampaign().labels().withCondition("Name CONTAINS '" + config.LABEL + "'").get().hasNext())) continue;
    
    // Skip location if set to exclude in the config
    if(config.EXCLUDE_LOCATIONS !== "" && config.EXCLUDE_LOCATIONS.indexOf(location.getId()) >= 0 || location.getCampaign() == null){
      continue;
    } 

    var locationConversions = location.getStatsFor(config.DATE_RANGE).getConversions();
    var locationCost = location.getStatsFor(config.DATE_RANGE).getCost();
    var locationClicks = location.getStatsFor(config.DATE_RANGE).getClicks();
    var locationCpa = locationCost / locationConversions;
    var campaignCpa = location.getCampaign().getStatsFor(config.DATE_RANGE).getCost() / location.getCampaign().getStatsFor(config.DATE_RANGE).getConversions();
    var newLocationBid = campaignCpa / locationCpa;
    
    // Only change locations that have the required conversions, cost or clicks
    if(config.MINIMUM_CONVERIONS != "" || config.MINIMUM_COST != "" || config.MINIMUM_CLICKS != ""){

      if(locationConversions < config.MINIMUM_CONVERIONS && locationCost < config.MINIMUM_COST && locationClicks < config.MINIMUM_CLICKS) continue;

    } // check minimums     

    // If there is an location CPA, we will place a bidadjustment
    if(isNaN(newLocationBid) === false && isFinite(locationCpa) === true && location.getBidModifier() !== newLocationBid) {
      if(newLocationBid < config.MIN_BID) { newLocationBid = config.MIN_BID; }
      if(newLocationBid > config.MAX_BID) { newLocationBid = config.MAX_BID; }
      
      	if(config.LOG === true) {
          Logger.log("Campaign: " + location.getCampaign().getName());
          Logger.log("Location: " + location.getName()); 
          Logger.log("Location CPA: " + locationCpa);
          Logger.log("New location bid: " + newLocationBid);
          Logger.log(" ");
        }  
      
      location.setBidModifier(newLocationBid);    
         
    }    

  } // location iterator      
  
} // function main()