3 Ridiculously Awesome Resources To Prevail Over Excel
May 18, 2015
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
Bing Ads Content Data To Be Deleted
Bing Ads is Deleting Content Data. What you should know and do before-hand.
What Will 2018 Hold for Social?
In this webinar, join AdStage’s JD Prater and Hanapin’s Steve Burnett as they look into the next year and show you what to look forward to in the social advertising world.
Why Brand Ad Campaigns Are Important
Explore reasons why you should consistently bid on your brand name and gain more real estate in search results for branded searches.
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
How To Better Organize Your Shopping Campaigns: A Tiered PLA Structure
Part 1 of 2 in Shopping structures for PPC accounts. Learn how to organize your PLA campaigns using a tiered prioritization strategy.
Your Last Chance to Join Us at Hero Conf London
We're ready to welcome more than 300 PPC pros to Hero Conf. And we'd love to add your name to the attendee list at London's Only All-PPC Event.
4 Tips For Troubleshooting PPC Performance
Get tips on how to troubleshoot PPC performance and start on your way to becoming a PPC troubleshooting pro today!