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]
Search Results for: budget solver
How To Use Excel Solver To Power Your 2017 Budgeting
It’s that time of the year again – time to set budgets and get ready for 2017. Not to mention budgeting for some successful holidays. How do you know what to spend on advertising efforts, and how do you know where to put that spend? This is where the use of Excel Solver can come in handy. Are you using it to its full potential? The Solver tool in Excel is an extremely … [Read more...] about How To Use Excel Solver To Power Your 2017 Budgeting
Using Excel Solver To Set Daily Budgets: Part 2
Earlier in the week we posted on how to use Excel Solver to set your daily campaign budgets. For those of you who wanted to see the whole process in action we put together a video to clarify how to use it. As always if you have any questions or comments feel free to leave them below! … [Read more...] about Using Excel Solver To Set Daily Budgets: Part 2
How To Use Excel Solver To Optimize Your Campaign Budgets
One of the problems I had been having this month came down to the issue of optimally efficient budget allocation. For some of you out there, this won't be something you'll ever have to worry about, but for a couple of my accounts, we have to maintain a rigid budget that we can't go over. With lots of lost impression share out there, one of the easiest ways to let computers rule … [Read more...] about How To Use Excel Solver To Optimize Your Campaign Budgets
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
The Case For Time Flexible PPC Budgets
"Just wanted to let you know your campaign has a limited budget. You're hitting your goals so might as well raise it!" I'm guessing I'm not the only one who hears this from platform reps, account executives, and sales associates. In a perfect world, every client has an unlimited budget restricted only by the maximum scale at which ROI remains positive. In the real world, that … [Read more...] about The Case For Time Flexible PPC Budgets
How Much Should I Spend: Aligning PPC Budgets to Goals
“How much money should we spend on PPC this year?” “How many sales can we get with X amount of budget?” “We are looking at expanding into ____ platform, how much budget should we allocate?” In the five years I’ve worked at Hanapin, these types of questions from clients are becoming more and more common. Budget recommendations and planning are not so straightforward as they … [Read more...] about How Much Should I Spend: Aligning PPC Budgets to Goals
How to Project Budgets for PPC Accounts with Sporadic Spend
Part of paid search is planning ahead to know how to spend your client’s money in the best possible way. To do that you need to start with a budget and delegate which platforms get a piece of your budget pie. But what happens when you aren’t given a budget and asked to give projections for a client? If the client has an established search campaign you can look at past … [Read more...] about How to Project Budgets for PPC Accounts with Sporadic Spend
Enhanced Day-Of-Week Budgeting With Non-PPC KPIs
Last month, I came to you with 3 ways to use ROAS for lead gen optimization. Today, I want to talk about another way Hanapin Marketing has begun embracing “back-end,” atypical KPIs in our PPC strategies and tactics. This example comes from a dynamic, sometimes complicated vertical that blends both lead gen and e-commerce attributes: Healthcare. The Complexity Of Healthcare … [Read more...] about Enhanced Day-Of-Week Budgeting With Non-PPC KPIs
Be Smart In 2017: Use Seasonal Budgeting
What's your 2017 budget? That's the question everyone was trying to figure out in the marketing world over the past 2-3 months. Many got the answer and split the budget up evenly across 12 months and went forward with the year. Others segmented the year into quarters and budgeted on a quarterly basis. Some segmented the budget down to the month. The goal of this post is to get … [Read more...] about Be Smart In 2017: Use Seasonal Budgeting
How to Make Your Excel Skills Superhero Worthy
Excel is a crucial tool for any PPC marketer. Between building accounts, analyzing data, and applying macros, Excel saves you valuable time and makes your job just a little bit easier. 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! The first one is to download … [Read more...] about How to Make Your Excel Skills Superhero Worthy