3 Ridiculously Awesome Resources To Prevail Over Excel

By Jamie Newton | @jnewton09 | Senior Communications Manager at Hanapin Marketing

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:

34 Excel Tricks To Save Your PPC Life – Whitepaper

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!
Download Now>

11 Excel Tricks To Improve Your PPC Life – On Demand Webinar

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.
Watch Now>

Mastering Excel: The Essential Toolkit for PPC Marketers

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.
Download Now>

The Future of Ad Copy in an AI World

In this webinar, AdFury’s Christopher Hoover and Hanapin’s Lauren Rosner will discuss the hot topic of AI and what the future could look like when automation becomes more and more popular in our industry – the good, the bad, and the challenging.

Reasons to Not Use an Automated PPC Bidding Strategy

There are so many situations when it is a good idea to test out PPC Bidding Strategies on campaigns. In this article, we are going to discuss different reasons why you might want to avoid using automated bid strategies.

Take the 2018 State of PPC Survey!

We're looking for marketers to take our State of PPC survey! The survey takes about 5 minutes to complete and establishes benchmarks, identify trends, and helps marketers around the world understand what's working and what's not in PPC.

Amazon Launches Seller Central Sponsored Products Dashboard

Amazon has released a new dashboard feature for the Seller Central marketing platform. Found in the Seller Central campaign manager, the dashboard makes it easier than ever to visualize your campaign data and take away valuable insights from your Amazon marketing account.