Have them check out Hanapin’s new video series, Hero Academy! Hero Academy offers short, entry-level how-to training videos for marketers new to paid media at no cost. This is perfect for an employee that just started working at your digital marketing agency or is transitioning to a role working with paid channels. Current videos include: The basics of […]
Free PPC Training for the Noobs at Your Agency Read More »
How do I lower my average cost over sale (ACoS)? This is the question I hear most often when working on Amazon Advertising accounts for clients. It can be a challenging question to answer as there are often several factors going into the ACoS. However, in my time managing Amazon accounts I’ve come up with
4 Steps To Saving Money & Lowering ACoS on Amazon Read More »
Sometimes I need to do a really simple task about 1,000 times. Although I’d love to say I have the bandwidth to pour over my accounts line-by-line, I simply don’t. Fortunately, I’ve crowdsourced some useful functions that help me maintain sanity and get things done quickly. I’ll share these processes with you and expand on
3 Essential Excel Practices for Formatting Read More »
In recent years, the nature of SEO has become more and more data-driven, paving the way for innovative trends such as AI or natural language processing. This has also created opportunities for smart marketers, keen to use everyday tools such as Google Sheets or Excel to automate time-consuming tasks such as redirect mapping. Thanks to
Excel Fuzzy Lookup for SEO: Effortless 404 and site migration redirects Read More »
A lot of the time when someone is asking me charts questions it’s simply a matter of not being able to find the setting option or not knowing if the option exists. I am going to share a few tips and tricks that I have in my toolbox that may help you better display your
Excel & Google Sheets Chart Resources That Will Make Your Life Easier Read More »
When you’re working with enormous amounts of data in Excel all day long, you’re constantly thinking of ways you can speed up your work without sacrificing quality. When you’re performing routine reporting and budgeting, or data analysis and data visualization, your time is valuable. Let’s spend less time and gain more results. Who’s with us?
Excel Tips for the Time-Crunched Marketer Read More »
Excel is a crucial tool for any PPC marketer. Between building accounts, analyzing data, and applying macros, Excel saves you valuable time and makes your job just a little bit easier. That’s why it’s important to continually brush up on your skills and make sure you use Excel to your full advantage. Here’s two resources
How to Make Your Excel Skills Superhero Worthy Read More »
One of the most useful documents in the “Useful Stuff” folder I keep on my desktop is an Ad Copy Proposal Template. It’s not the sexiest Xcel file you’ve ever seen, but it is simple, efficient, and I make copies of it nearly daily (I write a lot of ad copy). I’m going to walk
Building an Ad Copy Excel Template Read More »
One of the most useful documents in the “Useful Stuff” folder I keep on my desktop is an Ad Copy Proposal Template. It’s not the sexiest Xcel file you’ve ever seen, but it is simple, efficient, and I make copies of it nearly daily (I write a lot of ad copy). I’m going to walk
How To Build An Ad Copy Proposal Template In Xcel Read More »
The new year often comes with a resolution to find a new job. As such, many companies put off their hunt for new talent until after the holidays. That makes January the perfect month to review resumes and make sure they’re up to date on the skills employers are looking for. And for those looking
Top skills for PPC, Paid Search, and SEM Specialists in 2019 Read More »
