Excel Macros - The Unsung Hero Of PPC
March 10, 2016
Show me a PPC professional, and I’ll show you an avid Excel user (most of the time).
We tend to be wizards at formula writing, concatenating, and calculating cell length. Templates are pretty easy to set up (utilize formulas and simply dump in the data when you’re ready), but this process can get a bit messy depending on what you’re trying to accomplish.
Enter the Macro. While they can take a bit more time writing and setting up, many times you’ll end up with a cleaner end product. In this post, we’ll discuss what a macro is, why you’d want to use one, pros and cons, and how to get started with writing Visual Basic for Applications (VBA). The example we’ll use is a macro that takes a list of modifiers and categories and builds out campaigns automatically.
What Is A Macro?
Simply put, a macro will automatically run through certain tasks that you tell it to.
On the Developer tab in Excel, there is a category for Visual Basic. Here you’ll find the following buttons:
Editor – to edit VBA code
Macros – to view/run a list of macros in the workbook
Record – to record a set of actions as a macro
Templates are great as they work well for so many PPC related tasks. However, with more complicated tasks, things can get a bit messy.
Yikes. If one formula gets botched, you’re in trouble. In our new Macro version of the tool, we input all of the variables once, click a button, and the macro does the rest.
Here is our end result.
Nice, clean, and ready for Editor upload. The macro runs through your list of modifiers and categories and concatenates them to create keywords, and concatenates sub-category with match type for ad group names.
The Pros And Cons For Macros
- Much cleaner
- No formulas to mess with
- Run Fast (mostly)
- Can execute complicated actions like loops
- Takes time to write
- Need to learn VBA if you aren’t already familiar
- Can crash Excel (I’m looking at you, accidental infinite loop)
Learning VBA And Writing Your First Macro
This post has barely scratched the surface of VBA. However, there is an abundance of VBA tutorials online. WiseOwlTutorials has a great YouTube series on VBA. You can also reference Microsoft’s support materials.
I highly recommend watching a few videos to get you started. Once you get more comfortable, you can start piecing together bits of code to accomplish the task you’ve set out to complete. If you do get stuck, something I’ve found helpful is to record a quick macro, then look at the code to see how it’s structured. Do note that when you use the Record feature, Excel will oftentimes add in little bits of code that aren’t completely necessary.
Excel Macros have the ability to speed up your workflow substantially if you’re willing to put in the time upfront to create them. Consider creating them for any tedious tasks that you find yourself doing day after day.
How Should You Use Display Advertising?
We hear similar questions from clients on a regular basis. One question we hear often is “How do your other clients use Display Advertising?”
Expanded Text Ads: 7 Million Clicks Say They’re Underperforming
Over the past 6 weeks, we have been lucky enough to experiment with expanded text ads, and frankly, I’m not impressed with their performance.
£300 Off Hero Conf London Ends Tomorrow!
Time is nearly gone to reserve your seat for Hero Conf London, 24-26 October at etc.venues St Paul’s, at a huge discount off the regular conference rate!
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
Expanded Text Ads Come To Google AdWords Editor
Advertisers have been able to create expanded text ads, but couldn't utilize AdWords Editor. That has now changed with the release of the latest version of AdWords Editor.
Bidding Farewell to Adwords Converted Clicks: Don't Panic
AdWords will soon be saying goodbye to the "Converted Clicks" metric. Learn more about what this means for your account and how to prepare for the transition.
Olympic PPC Ad Strategies
How spectators consume sporting events and a massive expansion in the digital space will prove to shake up who and how advertisers reach their audiences.
Hanapin's PPC Resources Are Now Ungated!
You can now access Hanapin's whitepapers and toolkits without having to fill out a form!
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.
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.