Optimizing your keyword and ad group bids in order to maximize performance can be a tricky affair. Setting up a schedule to manage your bids is a great way to make sure that you’re not spending too much at the wrong times and more importantly that valuable traffic is getting to you at the right times.
AdWords’ built-in tool for modifying bids based on the time of day – ad scheduling — only allows you up to six bidding windows per day.
For large-scale accounts that demand a more granular approach, with bids that need to be changed every hour, the above limitations just won’t do. As an example, conversion rates for Domino’s vary dramatically during different hourly slots on different days; the company doesn’t want to bid at the same levels at 7:00 p.m., 9:00 p.m., and 11:00 p.m. on Wednesdays and Saturdays.
So the mathematical marketers at Brainlabs (my company) wrote an AdWords script — published in its entirety below — that gives you control of your bids for every hour of the day. If you’ve never used scripts, you can read our recent series on AdWords Scripts or just copy and paste the code into your account to get started.
The script works by altering the ad schedule bid modifier by referring to a central managing spreadsheet. Your first job will be to set up a correct spreadsheet. Copy and paste this generic ad schedule into a Google doc of your own. Be sure to rename the sheet to the actual account name from which you will be running the script.
Next, enter your own bid modifier values into the table. Entering 100% will leave the bid as is, while …read more