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
New Sessions. New Networking. An All New Experience.
When we get feedback on ways to make Hero Conf more relevant, more actionable, and more meaningful, we take it pretty seriously. It's our most powerful tool in creating an event we believe helps our industry thrive. And we've used that information to build our...
Why Digital Marketing: Traditions Aren’t Always the Best
Explore how digital marketing can take your business goals to the next level and start expanding into new markets.
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
PPC Budgets: Pass Go into 2018 and Collect Optimal ROI
In this webinar, Shape CEO Jon Davis and Hanapin Director of Services Jeff Baum will share their expert advice about how you can perfect your 2018 budget strategy to achieve optimal ROI in the new year.
Setting Up and Analyzing Universal App Campaigns
Now that UAC adoption is mandatory for promoting an app on AdWords, it's important to compare Universal App Campaigns vs Mobile App Install Campaigns.
RStudio for PPC: A Beginner's Intro
A beginner's intro to using RSudio for PPC analysis and reporting.