This guest post is brought to you by Jason Pellissier, Paid Media Manager at Nebo. See Jason live at Hero Conf Austin, April 16-18. The daily life of a PPC manager can be summed up with one word: Reports. Day of week reports, hour of day reports, keyword reports, the number seems to always be increasing with less and less time in the day to actually do them. Because time … [Read more...] about 3 Essential Excel Formulas to Automate PPC Reports
Search Results for: pivot table
Large PPC Account Conundrums: Data Management
Large PPC accounts can be fun to work on, but a common frustration is how to manipulate and gather insights from mountains of data. In order to take advantage of said data, you need to be able to easily (and quickly) pivot, label, group, sum, etc. In this post we’ll walk through a few options to make your data easier to manage. The Problem In a nutshell: tons and tons and tons … [Read more...] about Large PPC Account Conundrums: Data Management
RStudio for PPC: A Beginner’s Intro
With the ever-changing PPC landscape, we’re always looking for new ways to access, manipulate, and analyze data. The Account Analyst team at Hanapin has begun working with RStudio as a tool to do just that. This article is a basic intro to RStudio, describing what it does and why you’d want to use it for your PPC endeavors. RStudio? What the heck is that? “RStudio is a free and … [Read more...] about RStudio for PPC: A Beginner’s Intro
6 Bottom Line Boosting Tips for Paid Search
"It depends". In my 2+ years at Hanapin Marketing, I've come to learn that this is a universal truth across the industry. There is no shared magic number for ROI or CPA. There is no perfect CTR or CVR. And there most certainly isn't a singular strategic approach that can navigate across all industries and account types. That said, I do think there is a handful of search … [Read more...] about 6 Bottom Line Boosting Tips for Paid Search
6 Things You Didn’t Know You Could Do In Google Sheets
Google Sheets is a versatile tool for PPC marketers. Whether you’re using it build reports for your clients, analyze data, or other miscellaneous PPC tasks, getting familiar with some of the lesser known functions can be beneficial. Here are the features we’ll cover in this post: Import Sitemaps Currency Conversions Sparklines Import from other workbooks Check for … [Read more...] about 6 Things You Didn’t Know You Could Do In Google Sheets
4 Things I Learned as a New Hire at a PPC Agency
Six months ago, I embarked on a journey. I became The New Kid at Hanapin Marketing, and in the time that I've been here I've learned more than I could have imagined about the beautiful world of PPC advertising. Along the way, I found that a few key lessons could get me through the chaos of PPC account management and production work. When I made a list of the things I've learned … [Read more...] about 4 Things I Learned as a New Hire at a PPC Agency
The Complete PPC Account Audit Guide
11/12/2019 Your PPC account is never perfect. Hopefully, that doesn’t come as a surprise to you. The truth of the matter is that no matter how hard you work on building an account and optimizing it according to best practices, you will probably miss something. An even truer statement is that the longer you work in an account, the easier it is for things to slip past … [Read more...] about The Complete PPC Account Audit Guide
The 5 Stages Of PPC Account Restructuring
During my tenure as a PPC account manager I've found few things to be more anxiety provoking than the performance of a brand new account structure. Those first couple weeks of data are pivotal not only for account success, but for establishing client confidence moving forward. Following the launch of a brand new account structure, I typically go through a series of emotions … [Read more...] about The 5 Stages Of PPC Account Restructuring
Expanding Your PPC Coverage Beyond Google And Bing
Here at Hanapin, we have clients in seemingly every vertical with budgets ranging from penny-pinching to limitless. Despite their many differences, nearly all of these accounts have one thing in common: Google AdWords is their most important network. For these accounts, Google receives the lion's share of budget and optimization resources. Beyond Google, however, Bing is … [Read more...] about Expanding Your PPC Coverage Beyond Google And Bing
Top Bing Updates of 2016 and How To Get Your Campaigns in Shape for 2017
I think we can all agree that 2016 has left its mark as another year of overwhelming growth in search. It continues to impart our lives with more answers, more intelligence and more value. Let’s go through some of the highlights from Bing Ads as we move forward and build on our knowledge in 2017. New and Significant in 2016 Each year, Bing Ads, like many other platforms, … [Read more...] about Top Bing Updates of 2016 and How To Get Your Campaigns in Shape for 2017
Use The AdWords Reports Tab With Authority
When I talk to people in any industry about reporting, after I pause for the obligatory deep sigh, the most common response I get is, “there is just so much information.” We have all been there, drowning in a sea of numbers and not sure how to best answer the questions that have been asked of us. If you have an AdWords account, you have probably seen the Reports tab, nestled … [Read more...] about Use The AdWords Reports Tab With Authority
Campaign Groups Now Available In AdWords
We are all aware that the marketing industry is growing continually more complex. Frequent expansions and innovations in the digital marketing world are the evidence. As marketing strategies become more intricate, we see that AdWords is working hard to keep up. Our PPC strategies often involve multiple touch-points across various media when inviting users to convert, yet the … [Read more...] about Campaign Groups Now Available In AdWords
