If you work in the business world, you are most likely already familiar with the term QBR, or Quarterly Business Review. If you aren’t familiar, a QBR is a meeting held either internally or with clients once a quarter. The goal of the meeting is to recap last quarter’s strategy and results. It’s also an opportunity to present next quarter’s strategy plan, along with any budget … [Read more...] about How To Nail Your Next QBR
Search Results for: pivot table
3 Strategies To Consider When Thinking About Bidding
We all have to start somewhere. Whether we’re launching a new campaign, launching our first campaign, or taking a look at one that has been running for a while, we need to put into focus one of the key portions of the Google auction place, the bid. I’ll outline 3 different strategies and when to best utilize them. There are millions of different situations and caveats so … [Read more...] about 3 Strategies To Consider When Thinking About Bidding
Using Google Data Studio for Auction Insights Reporting
Competitor Insights data is very valuable to a PPC advertiser, but it isn’t always the easiest to collect and manipulate. This blog will give you a quick way to access this data for easy takeaways. Current Methods for Analysis Google Ads Interface This is the most straightforward method – just pop into the interface, select the campaigns you want, then navigate to Auction … [Read more...] about Using Google Data Studio for Auction Insights Reporting
Stop Whining. Start Winning. Swiftly Navigating the New AdWords UI
The new AdWords interface is here, and everyone has an opinion about the new layout. This blog is not an opinion piece. You won't find me crying into my pillow about the AdWords interface updating by the end of 2018, scrapping our old AdWords dashboard navigation for good. This blog will teach you the more technical side of actually navigating the interface, for those of us … [Read more...] about Stop Whining. Start Winning. Swiftly Navigating the New AdWords UI
3 Essential Excel Formulas to Automate PPC Reports
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
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
