Hourly Campaign Level Dayparts - User Guide
Geetanjali Tyagi avatar
Written by Geetanjali Tyagi
Updated over a week ago

On this page:

Basic Settings

The bid adjustments for this script are specified in a Google Spreadsheet. 

To get started, make a copy of our template spreadsheet to your own Google Drive (https://docs.google.com/spreadsheets/d/11IcRzJDdsdGJVzLNw0IlczhXYl_l0HTk5lXkfGLq1ig) then add the URL of your copy of this spreadsheet in the settings of the script in Optmyzr.

In your copy of the spreadsheet, update the bid adjustments by finding the cell in the sheet that corresponds to the day of week and hour of the day you want to adjust.

A bid adjustment of 0% means your current maximum CPC will be unchanged. An adjustment of 10% means your maximum CPC will be increased by 10% to 110% of normal. A bid adjustment of -20% means your maximum CPC will be reduced by 20% to 80% of your normal bid.

Bid adjustments are restricted between -90% and +900%, just like if you were setting the adjustments through the Google Ads website. 

"Paused" tab in the spreadsheet 

It is hard to delete a tab, and then bring it back later, so if you want to temporarily disable a setting, you can pause it by using the Paused Tab. 


If this script fails to run for more than 5 hours in a row, your account will have incorrect bid adjustments. When you no longer want to use this script, be sure to remove all dayparting bid adjustments manually.

Bid adjustments are stacked on top of each other. If you have geo bid adjustments and device bid adjustments, make sure you take these into consideration. For example, if your device modifier is 120%, and your geo modifier is 75% and your daypart adjustment is 110%, your final bid is 120% * 75% * 110% = 99%.

Did this answer your question?