In this post we'll go over If/Then statements, =SUBSTITUTE, and =CONCATENATE for keyword formatting and ad copy auditing.
Excel
Excel & Google Sheets Chart Resources That Will Make Your Life Easier
Here are a few tips and tricks for Excel and Google Sheets that may help you better display your data using charts or even just save you time.
Continue Reading Excel & Google Sheets Chart Resources That Will Make Your Life Easier
Excel Tips for the Time-Crunched Marketer
Let’s spend less time and gain more results. Who’s with us?
How to Make Your Excel Skills Superhero Worthy
Excel is a crucial tool for any PPC marketer. 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 that can help you do that!
Continue Reading How to Make Your Excel Skills Superhero Worthy
How To Build An Ad Copy Proposal Template In Excel
Explore how to build an ad copy template in Excel that will save you time formatting and organizing proposals for your clients or boss!
Continue Reading How To Build An Ad Copy Proposal Template In Excel
PPC Divination: Forecasting Uncertainty in Excel
There may never be a true “crystal ball” to predict future account performance, but a well-constructed model and a handful of random variables can help.
Continue Reading PPC Divination: Forecasting Uncertainty in Excel
Google Sheets Query Function Need-to-Knows For PPC
The best instrument for building PPC reports is Google Sheets query function. I will cover some of the most important initial items to learn when starting out.
Continue Reading Google Sheets Query Function Need-to-Knows For PPC
Personalized Training to Become a PPC Superhero
If you could divulge your biggest challenges in paid search advertising to an expert who is highly revered by industry peers, approved by 15 US & UK agency leaders, and a driving force in PPC innovation, would you?
Continue Reading Personalized Training to Become a PPC Superhero
Time-Saving PPC Excel Shortcuts That Work
In this webinar, Hanapin experts Mike Matta and Connor Regan will show you some shortcuts to blow your mind in Excel and save you oodles of time.
3 Essential Excel Formulas to Automate PPC Reports
Explore 3 easy to learn Excel formulas that can help automate almost any PPC report and start implementing them into your daily routine immediately.
Continue Reading 3 Essential Excel Formulas to Automate PPC Reports
RStudio for PPC: A Beginner’s Intro
A beginner's intro to using RSudio for PPC analysis and reporting.
Troubleshooting Lookup Functions in Excel
It’s easy to get discouraged from using Excel when we run into errors. This post guides you as you troubleshoot your Lookup functions so you don’t refrain from using them!
