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.
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.
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
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.
How To Get More Out Of Excel Solver
Excel Solver is a fantastic tool, but most examples only cover simple marketing use cases. We’ll cover the next steps of enhancing your models and how to automate the process.
Where You Should Focus Your Facebook Brand Awareness Efforts
Learn the basic metrics to focus on when you want to build awareness on Facebook.
Google To Release New Shopping And Travel Features
Several upcoming changes to Google Shopping and travel-related ads can be expected in the near future. Read to find out more.