3 Ridiculously Awesome Resources To Prevail Over Excel
PPC and Excel go hand in hand. Like peanut butter and jelly. Or macaroni and cheese. Or tortilla chips and salsa. Ok, you get the picture. Basically, you can’t (and shouldn’t) do one without the other.
We know how important Excel is to you, as well as the many struggles and time sucks you encounter in PPC. So, we’ve put together a number of resources (ridiculously awesome resources I might add) to help you out and send you on your way to becoming a better PPC marketer. Once you’re more savvy with excel, you WILL be a better PPC marketer. Not only will it help you do account work and analysis better, but you’ll work faster too.
Here we go:
This whitepaper by Hanapin’s Account Analyst, Rachael Law, covers features, formulas, and shortcuts in excel including pivot tables, conditional formatting, VLOOKUP, character length in ad copy, freeze panes, custom shortcuts, trendlines, macros, concatenate, trim, and SUMIF. It also gives you ideas on what tricks can be used for which task and bonus notes!
In this On Demand Webinar, Hanapin’s Jacob Brown, teamed up with 3Q Digital’s Oliver Eldredge for 11 excel tricks. I know what you’re thinking “But that whitepaper you just told me about covers 30 tricks!” You’re right, however, the webinar recording goes into some different and new tricks not mentioned in the previous whitepaper. Some tricks you’ll find out about in this webinar recording includes the quick keyword tool, calendar reporting, ad copy testing, dynamic ranges, bid strategy formulas, and graph scrollbars.
What if you could get the whitepaper and webinar recording, plus other resources all at once?? In this toolkit, we partnered with AdStage to pull together all the essentials you would need to become a master at Excel. Along with the whitepaper and webinar recording already mentioned, it includes two example excel spreadsheets (with accompanying whitepapers to explain and teach you how to use the spreadsheet), a couple more whitepapers, and an offer from AdStage.
Browse By Category
The 2017 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 2017.
What's Happening in the World of Paid Social? 2017 Insights and Predictions...
In this live webinar, Hanapin’s Mary Hartman and Simply Measured’s Bryan Blackburn join forces to share the insights gained from both Hanapin’s State of Paid Social 2017 and Simply Measured’s 2017 State of Social Report.
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
Facebook Ads For B2B: Presenting The Right Content At The Right Time
Proper content for an audience is the key to B2B Facebook ad success. Learn tips for creating better B2B ads.
Use AdWords Scripts To Update Negative Placements
In this article, we’ll show you how to use an AdWords script to implement negative Display Network placements.
London Workshops for Account, Agency, and Excel Heroes!
One of the most valuable pieces of the Hero Con experience is our day 3 workshops that dive deep into the topics most relevant to today's PPC marketer.