Tell Me Where It Hurts - A Quick Diagnosis Tool for Ailing Accounts
February 4, 2016
Every so often, an account lands in your lap and you just don’t know where to begin. Performance might be in a downturn and what is converting is coming at a high cost. You want to dive in and start optimizing, but how can you decide what to focus on first? By combining a couple of simple reports, you can quickly diagnose an ailing account and go from zero to PPC Hero.
Get Your Account On The Scale
The elusive quality score. When it is good, your account often looks and performs wonderfully. When quality score drops, finding the right fix can be an uphill battle. If you have been following PPC Hero for some time now you know what we preach: averages lie.
In order to get a clear understanding of ad group quality score, you need to look at weighted quality score. Calculating weighted quality score is easy and gives you more insight into the health of your account. You can calculate this metric by following these steps.
- Download a keyword report to Excel with clicks, cost, impressions, impression share, and quality score, as well as any other metric you might find useful.
- Create a new column called “QS*Impressions” and calculate the quality score times the impressions for each keyword.
- Create a pivot table of your data so that your pivot table builder resembles this:
- Now create a calculated field in the pivot to get the normalized, or weighted, quality score, which will be the sum of QS*Impressions divided by Impressions.
- Add the field to your pivot and you can now see quality score next to weighted quality score for a truer picture of health.
Sometimes the average quality score is lying for the better, sometimes for the worse. It is really helpful to see where the bulk of the campaign spend and impression volume is. As you continue to diagnose, it will tell you where your efforts will make the most impact.
Now that you have a good look at weighted quality score, time to add impression share to the mix and see where your keywords have been. PPC Heroes know there are multitudes of ways to optimize your account by looking at impression share. Just type in “impression share” into the PPC Hero search bar and you will find ways to maximize revenue and get more budget, to name a few.
What we are going to do with impression share is push it right up next to the weighted quality score. Go back to your pivot table and add “Average of Impression Share” to the columns. I then like to add conditional formatting to my data for quick comparisons. For both Weighted QS and Impression Share, add formatting so that the highest numbers are green and lowest are red.
We have all the information we need. Now what?
Diagnosing The Underlying Cause
Look at the data. If the quality score is low and the impression share is low, that tells us we need a good old-fashioned restructure. The poor quality scores are limiting keywords from showing in results. Hone in on structure: tighten up your ad group themes, cut unnecessary keywords, write better ad copy.
If you find that quality score is good, but impression share is low then you’ve got bidding issues. Download a keyword report with estimated first page bids and make sure your max CPC is competitive enough. If not, raise those bids. Limited by budget? In this case, you might consider a smaller scale restructure in order to give breathing room to your core keywords.
Finally, if you find that both your quality score and your impression share are high, you are in luck. You can start working your best practices on the account right away.
Finding A Cure
No two accounts are the same. What is a cure for one account may not work for another. Regular check-ups are key. The report outlined here is just a starting point. Schedule some time to periodically check your account and try one of the following:
- Audit your account: Check in on settings, extensions, bid modifications to make sure they still make sense.
- Use a QS Tracker Script: Keep an eye on your top keywords, making sure other optimizations in the account don’t negatively impact your quality score.
In conclusion, before you start shoving solutions in an account, make sure you know what you are dealing with first. While it can be exciting to jump into accounts and throw your mad PPC skills at it, get your bedside manner in check and make sure you are listening to what your account is telling you. A correct diagnosis leads to happy and healthy accounts.
What other reports do you use to diagnose your account?
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.
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.
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
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.
Where Does Your Hero Conf Dollar (or Pound) Go?
5 Common Excel Issues And How To Fix
Excel, while a fabulous tool for PPC, is not without its occasional hang-ups. In this post, we’ll go through some common problems, and how to fix them.
[New Whitepaper!] Guide to Google AdWords: Advanced Edition
In this whitepaper, you will gain a greater understanding of the distinction between e-commerce and lead generation PPC strategies, learn the effective use of Remarketing, how to utilize advanced segmentation for improved targeting, cross-device attribution, and how to use automated rules in your accounts.