Evaluating Your Keywords With The CPL Matrix
May 6, 2013
Here at the PPC Hero Headquarters, we do a lot of talking about metrics. How to measure, what to measure, how often to measure, and then of course what in the world to do with all that data.
Today’s question revolves around how to make bid changes based on your desired CPL. This alludes to the Conversion Threshold Matrix, originated by one Jeffrey Allen.
As with most PPC-related questions, the answer varies. “It depends of the account” is one of my favorite answers to questions about how to manage PPC advertising, as it is terribly frustrating and yet entirely 100% true.
For a lead generation account, with a very clear idea of the CPL they are willing to pay, there is one simple table you can create to verify if a keyword should be paused, reduced in bid, left alone, or even bid up.
This table is based on the idea that you prefer to get all of your leads at the ideal CPL. But it’s understandable that some may come in a little bit above that goal. And yes, that a few conversions might come in a bit further beyond that desired CPL. And sometimes, you can make the excuse for a conversion that exceeds what you’re really able to allot for a single conversion. So how do we quantify that? With an Excel matrix of course!
As you can see, my “low” CPL goal is $15. That is the actual CPL goal for this account. This matrix is built to assess those leads that are coming in past the CPL goal. (For hints on general tactics for bid changing, check out Amanda’s tips!)
Based on the sagacious words of our own PPC Hero Jeff Allen, this matrix makes that assumption that if you must spend over your CPL goal, you should set limits to assign what behavior necessitates a bid change or bigger yet, a pause.
This makes the assumption that if you’re coming in at 1.5x the goal CPL, you can afford up to 4 conversions. Once you’re beyond 4 conversions at that higher cost, you are going to need to take some serious measures. This will most likely look like a reduced bid.
The second row of our matrix shows that the keywords coming in above $22.50 but below $37.50 are allowed a few conversions before needing to take action. This row suggests that if a keyword is spending up to 2.5x beyond the desired CPL , more than 3 conversions is just too much.
shows that if you’re spending between 3.5x and 4.5x the goal CPL, which in this case is $67.50, you can only afford a single conversion at a time. This is a big red flag for the offending keyword. Is this keyword usually responsible for some quality lead volume? If so, don’t be so hasty to pause it, perhaps you need to evaluate the other metrics contributing to this costly keyword. What is the CTR? If it’s not looking great, reexamine that keyword’s max CPC and quality score. It may not be as simple as bidding up or down, you may need to work a little harder to make a keyword like this perform better. How is this word’s conversion rate? Maybe you’ve got a great CTR but all that activity comes to a screeching halt when the user gets to your landing page. Our PPC Heroes have tons of suggestions for how to combat issues just like this. And these scenarios are only talking about keywords you really believe in.
So let’s go through a quick application of this whole idea:
First let’s pull up a keyword report from the past 30 days. Sorting out any non-converting keywords, we’re left with those that are bringing in leads.
Depending on the list size and the conversion volume of your keywords, it may be most helpful to open only 1 range at a time. For this set, I’ll pull up all keywords whose CPL fell into my second row (those converting at 1.5x to 2.5x the desired CPL).
This then shows me only the keywords that have converted for the second grouping or “3 or Less.” Three is the magic number as anything more than this is just spending too much.
So you can see that the bottom keyword 27, 29 and 30 are going crazy! Lots and lots of conversions (which is great!) but at a cost that’s just too much to be happening so frequently when my goal is $15.
From this point, we take a look at what’s happening with these keywords. What’s the current bid? How’s the average CPC? Does the average position give any flexibility to bid changes?
While this post is not meant to give specific solutions for every case of overspending keyword, it’s intention is to give you a measurable, repeatable threshold for making decisions about your keywords. When you’re able to plug in ranges based on your own goals, it makes that intuition of “I think I need to pull back on these keywords” something that follows a consistent pattern. It’s a hard and fast set of parameters so that when clients ask about this whole “bid change hullabaloo,” you’ve got more than a hunch to justify it.
The conversion threshold matrix is a structure that works for this PPC Hero, have you tried something similar? Have you found that a template like this keeps your changes consistent (not to mention easy to track)? Let us know!
Browse By Category
Smart RLSA Tips for the Holiday Season
The holiday season is just around the corner! Get tips on how to fine tune your RLSA audiences to capture additional conversions or revenue.
Our Attendees Have Spoken - Why You Can't Miss London
At Hero Conf London, 23-25 October, we've created a schedule that can be tailored to any PPC role. In-depth, actionable sessions for the PPC Specialist and high-level strategies and tactics for the Marketing Manager looking to generate new opportunities.
Using Google Sheets as a Script Controller
Learn how to use Google Sheets to make AdWords script adjustments via spreadsheet rather than through the code itself.
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
How To Setup An Apple Search Ads Campaign
Apple Search Ads has become a huge force in the world of app downloads. Get tips on how to launch a campaign to promote an app!
Adding Facebook Ad Block Lists
Get tips on how to add a Facebook ad placement block list and start blocking your ads from appearing on certain websites.
Optimizing Display Advertising in an Omni-Channel World
We’re teaming up with DialogTech to tell you all about display tactics you can put in place for conversion success, both online and over the phone. DialogTech’s Blair Symes and Hanapin’s Stephanie White will show you the advanced strategies that will have a big impact...