Script for Benchmark Max CPC in Shopping Campaigns

[ent20]

Hi there  - does anyone know a script for Shopping that automatically adjusts Product Group Max CPC so it matches Benchmark Max CPC? Have searched online and can't find an example of one so wondering if maybe it's not possible?

Thanks

[Thea Vega (AdWords Scripts Team)]

Hi,

Could you confirm if what you want to use is the BenchmarkAverageMaxCpc under Product Partition Report and based on it, update the productGroup's max cpc? If so, please see below script to help you get started:

function main() {
 
  var shoppingCampaignSelector = AdWordsApp.shoppingCampaigns()
  .withCondition("CampaignName ='INSERT_CAMPAIGN_NAME_HERE'");
 
  var shoppingCampaignIterator = shoppingCampaignSelector.get();
  while (shoppingCampaignIterator.hasNext()) {
    var shoppingCampaign = shoppingCampaignIterator.next();
   
    var shoppingAdGroups = shoppingCampaign.adGroups().withCondition("Name = 'INSERT_AD_GROUP_NAME_HERE'");
   
    var shoppingAdGroupsIterator = shoppingAdGroups.get();
    while(shoppingAdGroupsIterator.hasNext()){
      var shoppingAdGroup = shoppingAdGroupsIterator.next();
      var pgs = shoppingAdGroup.productGroups().get(); //you may change this depending on your requirement
      while(pgs.hasNext()){
        var pg = pgs.next();
        var report = AdWordsApp.report(
          'SELECT BenchmarkAverageMaxCpc ' +
          'FROM   PRODUCT_PARTITION_REPORT '+
          'WHERE  Id = '+pg.getId());
       
        var row = report.rows().next();
        var benchmark = row['BenchmarkAverageMaxCpc'];
       
        pg.setMaxCpc(benchmark);
      }
    }
  }
}

I suggest you Preview the script first to see if it fits your requirement. Let me know if you face any issues after.

However, if this is not what you meant, could you please elaborate more on your requirements?

Thanks,

Thea

AdWords Scripts Team