… [Read more...] about Holistic search for brand and performance marketing excellence
Search Results for: excel
How To Get More Out Of Excel Solver
Excel Solver is a fantastic tool, but most examples only cover simple marketing use cases. In this post, we’ll cover the next steps for enhancing your models and how to further automate the process for multiple runs. The post focuses on the more technical aspects of Excel but will remain fully accessible. We’ll skip some of the finer details to better establish why and how to … [Read more...] about How To Get More Out Of Excel Solver
How to Automate Excel Solver
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 to how to implement it from start to finish. In this article we’ll go in depth from … [Read more...] about How to Automate Excel Solver
Excel Solver: Optimize Your Budgets Across Campaigns [Webinar]
Do you have an ideal paid media budget, but are struggling to understand how much you need to invest across different campaigns to get the results you want? Or maybe you have a budget range and need to understand what results to expect at each end. There’s an underutilized tool for that - and it’s built right into Excel (or Google Sheets, if that’s what you … [Read more...] about Excel Solver: Optimize Your Budgets Across Campaigns [Webinar]
How Excel Macros Save Digital Marketers Time
To Excel! The cause of, and solution to, all of my work-related problems. If you’re anything like me, you know that data in the PPC world is endless. Google reports, lead sheets, call forms, spend charts, daily reports, weekly reports, monthly reports! This list never ends. Enter Excel. Excel is everywhere and everything. Nearly every business and government in the world … [Read more...] about How Excel Macros Save Digital Marketers Time
Sheets & Excel Tips for PPC Newbies
Excel and Google sheets are every PPC account manager’s best friend. As a newbie, getting familiar with these tools and knowing their applications for everyday PPC is super important. In order to help you along, I’ve outlined some helpful tips and how to apply them to your PPC account management. Essentially, I’m helping you *excel* at your job. You're welcome! Disclaimer: I … [Read more...] about Sheets & Excel Tips for PPC Newbies
Excel Masterclass for Digital Marketers: 3 Sessions to Supercharge Your Efficiency
Excel is a crucial tool for any PPC marketer’s daily workflow. If you’re Excel savvy, your job will be so much easier. This webinar will be a deep dive into Excel. The 3 mini-sessions are geared towards improving the way you work. Your Excel pro for this Masterclass is Alaina Thompson, a Growth Marketing Manager at Hanapin Marketing. Alaina was previously an Adjunct Lecturer … [Read more...] about Excel Masterclass for Digital Marketers: 3 Sessions to Supercharge Your Efficiency
Excel For Marketers: Make Your PPC Dashboards Dynamic With Data Validation
PPC dashboards are great for account managers, but they're even better if they're dynamic! What do I mean by dynamic, though? A dashboard is dynamic when you can easily change inputs and review the corresponding output. For example, in the dashboard below, I can select any of my campaign labels and the data in the dashboard will adjust according to which label I've … [Read more...] about Excel For Marketers: Make Your PPC Dashboards Dynamic With Data Validation
How to Pivot Paid Search Data in Excel
Learning how to use Pivot tables in your PPC reporting helps you find insights in a quick and easy manner. I create Pivot tables to look at how our campaigns are performing across different marketing platforms for brand, non-brand, and specific client goals. Let’s dive into how you can feel confident with your data and start pivoting your way into data analysis. The … [Read more...] about How to Pivot Paid Search Data in Excel
Excel Coaching For Every PPC Hero
While Hero Conf is filled with insanely actionable insights, sometimes the work challenges you're facing need personalized attention tailored to your specific roadblocks - especially when it comes to Excel. An Excel Coaching Pass at Hero Conf London can help solve this problem. We've created this NEW pass to include 1:1 attention that is built into your 2 main conference … [Read more...] about Excel Coaching For Every PPC Hero
How To Write Excellent RSAs
When Google released Responsive Search Ads, my first reaction was, “great! I finally have enough characters to write decent copy!”. That reaction was short-lived once I found myself staring at 15 blank headline columns in Excel. How many ways can I say “Buy These Jeans”? I began to begrudge RSAs, thinking them excessive and annoying. I knew this was the way of the future but … [Read more...] about How To Write Excellent RSAs
3 Essential Excel Practices for Formatting
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 where they’ve served me best. If/Then for Logical … [Read more...] about 3 Essential Excel Practices for Formatting