Find out how Path Interactive can deliver a customized approach to growing your business.
Please tell us about yourself and we'll contact you shortly.

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

Ari Berdy 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.

Most Recent

How to Build a Data-Driven Business Case for Content

By Paul VanHevel, PathInteractive | September 16, 2016

A Step-by-Step Guide to Quantifying the Value of Content In the sometimes-gray world of organic search marketing, conveying the value of your […]

Read More

The Science Behind Data-Driven Attribution, Google’s New Attribution Model

By Steven Sonnes, PathInteractive | August 5, 2016

When shopping online customers often touch multiple marketing channels before they convert. In marketing this is known as the consumer […]

Read More

The New Mad Men: Looking Back at Advertising’s Evolution Towards Digital Marketing

By Ann Paskor, PathInteractive | July 19, 2016

Everyone in the marketing world has heard of Mad Men. They were the cool guys in the 60’s who worked […]

Read More