You’ve heard it before. Whether it’s a new idea you’re gearing up to pitch, or a request handed down to you from upper management. “Show me numbers!” Thus, you have carefully examined and prepared data that show exactly what has happened in your accounts to-date, what’s worked and what hasn’t, and you are equipped to […]
PPC Divination: Forecasting Uncertainty in Excel Read More »
If you are a hard-core Excel only user this article is not for you. While Excel is powerful especially combined with Power BI, sometimes Google Sheets is the answer. In an industry such as digital marketing where everything we do is online, highly collaborative, and shared with outside clients Google Sheets has its benefits. We
June 22, 2018 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? At Hero Conf you can. Hopefully by now your experience with PPC Hero has
April 9, 2018 Have you been itching for some more time back in your life? Think about all the time you spend in Excel…and imagine that time cut in HALF. Drooling a little? We thought so. We have a whole host of PPC Excel shortcuts to add to your repertoire and give you a few
April 3, 2018 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
3 Essential Excel Formulas to Automate PPC Reports Read More »
March 21, 2018 In How to Get More out of Excel Solver I covered techniques to enhance your model and empower your analysis. One of the topics I received the most questions on is the automating the solver to solve for multiple values. There was a brief explanation in the previous article, but nothing dedicated
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
Last week, Hanapin hosted an Excel Extravaganza, which was a compilation of 3 Excel for PPC webinars in 3 days. On day 3, Lara and I discussed bidding methods with Excel. I specifically discussed bid tables and how to use Lookup functions to automatically pull bid changes from a bid table. We discussed how to
December 12, 2017 Projecting an account’s trajectory is a vital skill for every account team. You can’t escape it. It comes up when performance is great and it comes up when performance is poor. Despite the demand for these skills and insights, it can be one of the scarier tasks. The uncertainty of accounting
December 1, 2017 Next week, Hanapin kicks off a week long celebration of Excel in the Excel Extravaganza. The whole thing includes 3 webinars and handy resources on the most essential tool in PPC. It’s definitely something you don’t want to miss. DID YOU KNOW YOU CAN SEARCH FOR ALL THINGS EXCEL IN HANAPIN’S
EXCEL-erate Your Learning with Hanapin’s PPC Library Read More »
