How To Determine Your Hourly Bid Multipliers In AdWords

Since I received some solid feedback on my last column detailing how to determine mobile & geo bid multipliers for enhanced campaigns, I thought I’d share some more actionable stuff this time around. While hourly bid multipliers aren’t new, they remain a crucial tactic for optimizing your AdWords campaigns. They work by reducing your ad spend at […]

Chat with SearchBot

Since I received some solid feedback on my last column detailing how to determine mobile & geo bid multipliers for enhanced campaigns, I thought I’d share some more actionable stuff this time around.

While hourly bid multipliers aren’t new, they remain a crucial tactic for optimizing your AdWords campaigns. They work by reducing your ad spend at poor-performing times of the week and increasing your exposure at the best times of the week. Here, I’m going to share the steps you can take (along with a helpful spreadsheet) to determine your hourly bid multipliers for better campaign optimization.

Step 1: Pulling An Hourly Performance Report From AdWords

On the Campaigns tab in AdWords, go to Columns>Customize Columns and ensure that you’ve selected the appropriate metrics. Performance metrics required for the spreadsheet to function properly are as follows: Campaign, Clicks, Impressions, Cost, Avg Pos, and Conv (1-per-click) — all other metrics selected in the screenshot below are optional:

Column Set

Once your performance metrics have been selected, hit the “Download Report” button. When prompted, add the “Day of the week” and “Hour of day” segments:

Segments

This should provide you with all the data you need to analyze hourly performance at the campaign level.

Step 2: Determining Hourly Bid Multipliers

Similar to the template used to determine mobile and geo bid multipliers, I’ve created a basic spreadsheet to help analyze hourly performance and easily determine your hourly bid multipliers. You can download it here.

Copy and paste your AdWords report into this spreadsheet as directed. From here, you can take a closer look at the following:

a. Performance By Day Of Week

by day of week

b. Performance By Hour

by hour

c. Performance By Hour & Day Of Week

by day of week and hour

If you have collected enough hourly data for each day of the week, you should absolutely make bid adjustments on an hourly basis. This process can be time consuming, as it requires making adjustments on a very granular level, but the results are well worth it.

For those times with less traffic, you can still leverage daily and/or hourly trends. For instance, looking at campaign #43 in the attached spreadsheet, it appears that there was not enough data collected on Sundays from 4:00 am to 5:00 am to make a specific bid multiplier suggestion — but you might still want to increase the bids, since the data indicate that both Sundays and the 4:00 am to 5:00 am window perform well in general.

The attached spreadsheet will only address those times of the week with sufficient hourly data, while keeping in mind that “bid adjustments for locations, days, times, and any ad group-level targeting methods can be set from -90% to +900%.” Thus, it can help you to determine relevant hourly bid multipliers between -90% and +900% when there are a statistically significant number of clicks:

hourly bid multipliers calculations

Step 3: Implement Hourly Bid Multipliers In AdWords

At the campaign level, navigate to the “Settings” tab; then, go to the “Ad schedule” section. The first step is to specify when you want to make bid changes. Select a day of the week from the drop-down menu:

setting time periods

From there, you can you can adjust the effective hourly bid multipliers, as calculated by the spreadsheet:

setting hourly bid multipliers

Conclusion

All of this is fairly straight-forward; however, your hourly bid multipliers need to be maintained over time, hence the importance of a (semi-)automated process. Also, keep in mind that once set in AdWords, those hourly bid changes do not take into account multiple time zones. For instance, if your AdWords account is set to “(GMT-08:00) Pacific Time,” and you want to increase the bids by 20% at 1 pm, then these bid changes will occur at 1 pm PST across all PST/MST/CST/EST locations. As a result, it makes sense to break down your top campaigns by time zone in order to set more accurate hourly bids.


Opinions expressed in this article are those of the guest author and not necessarily Search Engine Land. Staff authors are listed here.


About the author

Ben Vigneron
Contributor
Ben Vigneron is a seasoned marketing analyst and product analytics leader with a startup culture. Ben was listed as one of the best eCommerce PPC Experts by PPC Hero in September 2014, and spoke multiple times at the Search Marketing Expo (SMX) in Europe and the USA. With a vision to change the way marketers think and operate, Ben and his team work with leaders and organizations to bring data to the center stage, and help make more informed decisions. After more technical training at Adobe, and years of experience with advertisers in the Bay Area at Blackbird PPC, Ben has uncovered remarkable patterns about the incremental effectiveness of paid advertising through search, programmatic, and social initiatives.

Get the must-read newsletter for search marketers.