Get Bargain-Basement Leads Every Hour- Micro-Dimensioning for Fun & Profit

Avatar Path Interactive June 16, 2014 Category Paid Search (PPC)

You know how you can use Dimensions to break out AdWords performance by period of time—by hour of day, day, day of week, etc.—for reporting or optimization? You might already be doing that, actually. (If not, check out Dimensions → Time.)

Imagine if you could see not just performance by day or hour, but performance by day and hour. Meaning, for example: On Mondays, from 9 to noon, the cost-per-lead (CPL) is $15, and from noon to 5, the CPL is $11. On Tuesdays, from 9 to 1, the CPL is $17, and from 1 to 5, the CPL is $14. And so on.

Imagine, particularly, the chance for optimization.

With the data you can now get with Dimensions, and not too much work in Excel, you can create mini, usable dimensions like that, and bid adjust for savings.

1. Export the regular day of week and hour of day performance Dimensions for the date range you want to go through. (I added calls from an external source, and calculated CPL myself. Unless you have a fair number of leads invisible to AdWords, this is an extra step.)

2. Create a day-hour expanded CPL grid, with the value of each intersecting cell equaling the product of the corresponding day and hour CPLs, e.g., the Monday at 8 cell equals Monday’s CPL multiplied by 8’s CPL. This shows the relative CPL of each day-hour block. If you want, you can use Conditional Formatting → Color Scales on the values. This makes it obvious which day-hour CPLs are above or below average—and looks pretty neat.This already provides some interesting information, namely they tend to get the best bang for during the later hours earlier in the week and the, well, less good value during the earlier hours later in the week.

3. Convert that into the adjustments needed to reduce the higher CPLs to the average expanded CPL. (I used the average as a “satisfactory” baseline, but you can really use any figure.) Just create a second grid with each intersecting cell equaling one minus the average expanded CPL divided by the day-hour expanded CPL. A positive percentage is a negative bid adjustment—lower by that percentage. (Conversely, or in addition, you can try using the negative percentages as positive bid adjustments, to gain lead volume, albeit with a possible higher CPL.)


4. Bask in the glory of high (well, possibly better) performing online ads.

If you are curious about which internet advertising practices might be best for your business, give us a call today at 800-680-4304 or fill out our express form for a free consultation.

Contact Us Now!

  • This field is for validation purposes and should be left unchanged.

Most Recent

Impact of the Coronavirus (COVID-19) On Google Organic Search Visibility

By Lily Ray, Path Interactive March 19, 2020

The outbreak of the coronavirus (COVID-19) in 2020 has created global upheaval as businesses and economies shift […]

Read More

Future-Proof Your Site For Google Core Algorithm Updates

By Lily Ray, Path Interactive February 19, 2020

I spoke at SMX West in February 2020 about how to future-proof your site from Google’s core […]

Read More

Path Interactive Makes AdAge 2020 Best Places to Work List For Third Time

By Benton Olivares, Path Interactive February 18, 2020

Everyone at Path Interactive is thrilled to once again be named among AdAge’s 2020 Best Places to […]

Read More