AdWords Graphs Are My Best Friend
January 20, 2012
A couple weeks ago I wrote an article about desired outcomes in PPC. A big idea behind that article is to know what you are doing and why you are doing. This is a follow-up to that and some advice on how to retrace your steps in an effort to duplicate great account performance of past. I’ll also give you some insight into how I go about diagnosing account issues. In my current role as Account Supervisor, I have my hands in every Hanapin Marketing client account from an analysis and strategy perspective. Sometimes you simply need another set of eyes on an account to realize opportunity and risk in PPC and my role is to be that set of eyes, giving us the best chance to capitalize on our client’s opportunities and minimize their risk.
Because we have a good amount of clients, the amount of touch time I have with each is extremely valuable, putting an emphasis on efficiency. With that said, I typically need to dig a little deeper because our staff is extremely talented, which makes it difficult for me to poke holes in their existing strategies. I’ve found that the most loyal tool in my analysis arsenal is the AdWords graph feature (And AdCenter’s now that they’ve added this). It’s always the start of any diagnosis I’m conducting. It allows me to quickly sort through and visualize large data sets at many levels of granularity and at several different periods of time. What I’m looking for with this information are trends. I want to identify changes in the account and draw attention to significant or subtle changes in the account that can be acted upon. Here are some examples of graph settings I look at and what I’m looking for in each:
Year Over Year CPL Performance:
I take a look at year over year performance to have a better understanding of seasonality and how far an account has come in the past 12 months. The above chart is a branded AdGroup. You can see that 2012 January performance on cost per conversion is considerably better than 2011. Not only is it better, it’s also more consistent as the line is more flat than previous years. These are the types of results I want to see and are something that is valuable to show a client, especially on accounts with a high level of seasonality where month over month stats may vary. This chart only shows part of the performance though. To get a full understanding of the performance you need to start swapping the first metric:
Year-Over-Year Cost Performance:
This is a shot of the same AdGroup but looking at cost. What this allows me to see is that, while CPL did improve dramatically on the previous chart, spend actually decreased. Sometimes true performance can be clouded by the performance of metrics and drawing out additional information could allow me to better understand what is happening on an account. An assumption I can make here, and one that took only a few seconds, is that CPL performance improved because this account manager “cut out the fat.” The manager probably reduced spend on keywords that weren’t working and probably invested more heavily in the keywords that were working, which allowed her to spend more efficiently and produce a lower CPL. To prove this, I’ll need to look at one more metric for year-over-year.
Year-Over-Year Conversion Performance:
Here’s that same AdGroup with the same date range on conversions. As you can see, 2012 is actually driving more conversions than 2011. This is what ties it all together and proves to me that optimizations over the past year have resulted in significant improvements in account performance for this branded AdGroup. This account manager is driving a significantly higher volume of leads for a significantly lower cost, resulting in higher budget efficiency. Now I can go give her a high five. Plus, it took me less than a minute to run through this entire process. I could scrub the entire account at the ad group level (30 AdGroups) in this manner in less than 10 minutes. With that said, looking at year over year data isn’t necessarily enough to have a full understanding of the accounts performance. From here, I’ll go into a six month trend analysis, starting with:
Clicks Versus Cost Per Click:
Now I’m at the account level and I’ve stretched my date range back about six months. The first thing I want to see is how the account was managed from peak season, which on this account is August, through their slow season, which on this account is December. I already know that on this account, budget is reduced through the slow season and they are limited by budget so there is no shortage of opportunities to find clicks. What this report is showing me is that cost-per-click shrank in relation to overall clicks. I assume that this was a tactic to mitigate a loss of traffic by lowering position and driving more volume for each dollar. During the high months, I’d imagine position was raised to gain more exposure and relevance when people are buying. I’ll confirm this by swapping cost per click for average position, which I did and the graph confirmed my assumed results. Now I want to know if the strategy paid off.
Conversions versus Cost:
Here’s where things get interesting on this account. As you can see in the business months at the start of the graph, the relationship of conversions and cost was close; high conversions and high cost. In the slower months a gap forms where conversions are peaking out considerably higher than cost. This shows better efficiency in the slow months, which we already noticed on the AdGroup graphs earlier. You can also see towards the end of this graph that the trend converges again as we head into January, which is one of this clients busier months. What this arms me with, is the ability to realign strategy with the client and walk them through the progression of their account. The best part is, I don’t actually push buttons or pull levers in this account and I’ve got the trend and strategy over the past six months pegged in about 15 minutes worth of research.
Performance on this account was outstanding so there wasn’t much for me to dig deep into but a similar analysis using only graphs on another account could uproot some items that need immediate attention. When I find trends that don’t look great to me, I zoom in on the date ranges in question and start doing a comparative analysis of the time period directly preceding the goof. It’s then that I’ll start looking at overall metrics to see what shifted and I’ll analyze change history reports to see if it was user caused. If so, we can easily go back and revert to the previous state and pick up with a new optimization. Analyzing accounts doesn’t always take a long time but you should make a habit of analyzing your accounts on a short-term and long-term basis regularly. If you only stay within the day, week, or month, you might be losing site of just how much your account is changing.
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.