Large PPC Account Conundrums: Data Management
Large PPC accounts can be fun to work on, but a common frustration is how to manipulate and gather insights from mountains of data. In order to take advantage of said data, you need to be able to easily (and quickly) pivot, label, group, sum, etc. In this post we’ll walk through a few options to make your data easier to manage.
In a nutshell: tons and tons and tons of data! How do you manipulate it? What’s the best way to pull actionable insights from it? So many questions!
Here’s a breakdown of one of our larger paid search accounts that we’ll be using as an example today.
For this particular account, the numbers above only represent one AdWords account out of many, and they also operate on Bing. As you can see, the numbers very quickly add up when you combine all the accounts.
We need to run analysis broken down by month, with the data grouped by brand vs. nonbrand, and single keyword ad group (SKAG) vs. non-SKAG. We’d like to look at overall keyword and ad performance, as well as quality score.
Solution #1 – Use Filters
There are multiple ways to use filters to pull less data into Excel or sheets. Two common ones are filtering by status or filtering by category (brand vs. non brand, etc.)
The pro here is that this is easy to do within most interfaces. The con is that once you pull the data, you lose the option to use data that has been filtered out later on. For me personally, I like to have all the available data to mess around with, in case I decide I want to tackle something from a different view. Going back to the interface to re-download can be quite a time suck.
Solution #2 – Labels Galore
If you want to take the time to label all of your campaigns / keywords / ads / etc., then you have the option to use the Report builder in AdWords.
This will group all of your data together by label, but you do lose some potential detail here. For example, if you pull campaign labels you won’t be able to see keywords. There are some instances where this is a great option, but again, you’re a little limited in what you can do.
Solution #3 – Third Party Platform
This is where platforms such as Acquisio, Marin, Kenshoo, etc come into play.
One benefit of using these services is the ability to link with multiple ad platforms such as Google, Bing, Facebook, LinkedIn, etc. Reporting abilities typically come built in, and some of the dashboards are pretty slick.
You may be reading this thinking “great! Sign me up!” but hold on to your horses. The downsides of going this route include
- Price – be prepared to fork over some cash for a subscription
- Usability – speed can also be an issue here, and often we run into issues when trying to export large amounts of data
Solution #4 – RStudio
If you are getting bogged down with slow platforms or tools (lookin at you – rainbow spinny wheel when Excel is about to crash) and are comfortable with a little code, RStudio can be a great option to manipulate your data. While this isn’t a super common tool in the PPC world – it’s extremely versatile and PPC managers would be well served to use it for their larger accounts.
There are several ways to get your data into RStudio,
- Have it read a csv file
- Have it read from a Google Sheet
- Pull directly from the AdWords API (note: this requires an AdWords developer token)
Once you reference the data, there are tons of opportunities to slice, dice, and analyze to your hearts content. In addition to manipulating data quickly, there also also some advantages to pulling things into RStudio that you can’t easily do in Excel. For example, this account is mainly comprised of single keyword ad groups, and we want to easily find which ad groups contain one keyword, label them, and then compare brand vs. non brand.
A simple script groups the data in an easy-to-read table:
If you prefer visuals, R has some great options for graphing:
R also has a variety of statistical analysis tools (which can be handy for landing page or ad tests!).
I won’t go into all of the code here, but if this interests you there are tons of free resources available online.
If you find yourself immersed in data from a huge account, hopefully the solutions outlined above can help you manage your data. I’d love to hear how you currently handle these situations! Do you use any programming language to manage your data? Rely on third party platforms? Let us know @ppchero!
Browse By Category
How We Gained $21,000 More in Revenue by Changing One Color
Testing button color, or the color of any element on your page can be extremely rewarding - if it is done correctly. See how you can turn a simple test into drastic results.
New Research! The State of PPC
This year's State of PPC annual report has arrived! Grab the download for the latest trends and benchmarks in the PPC industry.
Bing's New(ish) Automated Bidding Strategies
Bing continues to roll out automated strategies to extract more performance from your campaigns. Take a look at the two newest and how to best use them.
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
Google Quality Score – Should You Optimize for This Metric?
Pulling Quality Score reports in Google Ads can benefit your account by providing a guiding light on where you can optimize with future tests.
I used the Budget Optimizer in Facebook for 30 Days, here's what happened.....
Explore insights from testing the Facebook campaign budget optimization tool for 30 days.
PPC Audiences: What Are They and How Does Google Determine Them?
Explore what PPC audiences are, as well as what signals may be factored into the Google algorithm that determines who is included in these audiences.
Load More »