24 hour bidding schedule - Is it possible to manage bid adjustments based on day of month and not day of week?

[Thomas Jensen]

Hi, 

I have been using Brainlabs "24 hour bidding schedule" script for a while and overall, i'm quite pleased with the script. 

Our company owns several brands in the same market and our sales are primarily driven by very price-focused campaigns. Therefore, I use the script to make bid adjustments in relation to campaign periods, where we want to increase bids for one brand and reduce bids for other brands. 

Since bid adjustments are made based on day of week and not the actual date, then it's only possible to make bid adjustments 7 days ahead (see examples attached). This makes setting up bid adjustments unnecessarily demanding. 

Therefore, I would like to hear whether it is possible to change the function of the script so that bid adjustments are made from actual dates (day of month) and not day of week. 

Attached, you can see an example of how adjustments are managed at the moment (example 1) and how I would like to manage adjustments in the future (example 2). 

I hope it all makes sense to you guys. 

Best regards, 

Thomas 

[Google Ads Scripts Forum Advisor]

Hi Thomas,

The addAdSchedule method used by this script requires a day of the week as a parameter. Though it is not possible to do this using actual dates rather than days of the week, one way you could extend your scheduling would be to create multiple 'Ad scheduling' tabs (the first tab in the template they provide), and then change the script so that it references a different tab depending on what the current date it is. The script retrieves the Ad scheduling tab with the lines,

  var sheets = spreadsheet.getSheets(); // line 62

  var sheet = sheets[0]; //line 72

You could instead get the sheet by name, based on a certain date, or what week of the year you are in:

  //Combine these two lines to:
  var sheet = spreadsheet.getSheetByName("Your_Sheet_Name");

You can read more about working with dates and times, and use the spreadsheet service reference.

Regards,
Matt
Google Ads Scripts Team

ref:_00D1U1174p._5001USwPGj:ref

[Thomas Jensen]

Hi Matt, 

Thank you very much for your help! 

It's a great simple solution. 

Regards, 

Thomas