November 16, 2016
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 powerful budgeting tool when it comes to Adwords. You can read through performance and availability side by side in order to develop a sound strategy on where to put your money, whether you’re looking into a fresh year, a fresh quarter, a fresh month or need to make some mid-month adjustments.
In this whitepaper, Hanapin’s Senior Account Manager Jacob Brown (affectionately known here as Juice) will walk you through, step by step, the handy tools and tricks hidden inside the Excel Solver. From analyzing your data from the previous year to setting up the Solver to using Solver for monthly budgeting and adjusting, you’ll learn it all and get some new ideas of how to excel your accounts (…get it?).
This whitepaper will discuss valuable topics such as:
- How to use Excel Solver to budget per location
- How to gather data for the Solver
- How to run the Solver and get the best results