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!
[New Webinar!] How Brands Can Effectively Use Display Advertising
In this new live webinar, Hanapin Account Manager Kristin Vick will dive into the meat of Display advertising, revealing tips to use the strategy to its full potential and more specifically target your audiences.
5 Ways To Improve Display Network Performance By Using Layered Targeting
Display campaigns can be difficult when it comes to targeting the right audience. In this post, you will learn 5 ways to improve your Display strategy with multi-layered targeting.
Expanded Text Ads And Other Bing Ads Editor Updates
Pilot access for Expanded Text Ads is now available to Bing Ads users. Get access to the link and learn about other new features in the latest Bing Ads Editor update.
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
Keynotes from Bing & Google + the Hero Conf Advanced Track
Where do you go to get the most relevant information in PPC, plus the opportunity to network with the best and brightest the industry has to offer? Why Hero Conf, of course.
3 Questions You Need To Answer Before Beginning Paid Advertising
So you’ve you decided you want to start PPC advertising, but now you are asking, “Where do I start?” We've listed and answered 3 questions you should be asking.
Road Trip - 5 Tips For Creating International Campaigns
International markets can add complexity to any account, but here are a few settings and opportunities to make your global ad strategy stand out in non-US markets.
Discover 3 Levels Of Geo Targeting For Beginners, Intermediates, & Experts
Setting geographic targets is day one. Whether it’s to exclude places you cannot sell or serve or to specifically target your primary customer base, the implementation of geo-targets is on the must-do list.
[New Webinar!] What You Need To Know About New AdWords Features
In this new live webinar, Hanapin Associate Director of Services Jeff Baum and Optmyzr’s CEO Frederick Vallaeys will walk you through the new AdWords tools and show how you can use them to optimize your accounts.
The Social Strategies You Need To Know For App Promotion
Create social strategies to promote app awareness and leverage geographic and demographic data reported by these platforms to refine audiences.
Guide the Industry and Take the 2016 State of PPC Survey!
Each year, Hanapin Marketing manages extensive research into the State of PPC Report, which provides a statistical breakdown of the digital ad industry and guides expectations.
What's In A Name? Building Powerful Product Titles For Ecommerce
Over the years, we've tested a variety of different product title alterations in hopes of finding the perfect title. Did we? Yes, and no. The fact of the matter is, it depends.
What Upgraded Bing URLs Mean For You
Bing is continuing its effort to catch up with Adwords. Upgraded URLs, which isolate tracking parameters from final URLs, are now available to Bing advertisers.