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!
View Ad Creative Through The Eyes Of Your Searchers
Learn to understand that ads do not live in the vacuum of an excel sheet and common practices should be tested.
[New Webinar!] 11 Red Flags To Watch Out For When Working With An Agency
Leveraging Analytics For Remarketing: Picking The Ripest Fruit
Remarketing prevalence is well founded based on competitive returns in both volume and efficiency. With that said, this "low hanging fruit" world isn't always easy to pick.
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 Analyze Time-Of-Day Performance For Luxury Products
The importance of ad schedules varies across industries, services, and products. For e-commerce companies that sell luxury goods, ad schedules are more crucial.
One Week Left to Save 25% at Hero Conf London!
You still have time to join us for Hero Conf London, 24-26 October at etc.venues St Paul's at 25% off the conference price. But time is running out.
4 Common Questions Prospects Ask Me During The Sales Process
There’s always new, hot topics and questions we get asked by prospects to see what our company’s take is, and how we go about implementing from a services perspective. Read what our most common questions are.
Mobile Price Extensions Rolling Out In AdWords
It looks like "Christmas in July" has come to Google. Recently announced price extensions are designed to help mobile marketers qualify clicks and inform prospective consumers.
[New Whitepaper!] 4 Ways To Survive PPC Campaigns for the Healthcare Market...
This whitepaper will highlight four examples of how thinking at the corners can help boost your PPC performance in the healthcare industry.
Create Visually Appealing Reports With Google Data Studio
When we talk about what tasks tend to eat up a significant chunk of time, reporting is surely mentioned. You may want to explore another option - Google Data Studio.
Liveblogging 2016 DoubleClick Announcements
Today is the day we learn more about the latest DoubleClick updates. Follow along live as we share DoubleClick's announcements as well as our opinions.
The 2016 Top 25 Most Influential PPC Experts
After a month of voting, rigorous research and data analysis, we are excited to announce the wildly anticipated list of the Top 25 Most Influential PPC Experts for 2016.
[New Webinar with AdEspresso!] 4 Effective Strategies for Facebook Lead Gen...
In this new webinar, AdEspresso and Hanapin experts discuss four effective strategies to use Facebook Lead Gen Ads for your business.
PPC Hero Launches New Site!
We're excited to announce the launch of a brand new PPC Hero! We've redesigned the site to be more search friendly with a better navigation system and more opportunity to find the right resources quicker.