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
Search Results for: excel
Limited Seats Remain for Advanced Excel and Agency Growth Workshops
Hero Conf London is coming soon, 24-26 October at etc.venues St Paul's. And we still have a few seats remaining for our intensive workshops on Day 3. Grab one of 6 seats remaining for our advanced Excel workshops with our Excel Hero Pass. The Excel Hero Workshop is designed with the expert-level account manager in mind, with sessions dedicated to uncovering efficiencies and … [Read more...] about Limited Seats Remain for Advanced Excel and Agency Growth Workshops
How To Utilize Excel Data Tables For Better Projections
We’ve all been in a situation where we needed to see the results of an equation based on a range of values. Maybe it was “what if we spent X amount or Y amount” or “what are the potential impacts of another ad test?” Calculating by hand is slow and cumbersome. Thankfully, data tables allow you to quickly compare values and run calculations multiple times. Rather than … [Read more...] about How To Utilize Excel Data Tables For Better Projections
5 Common Excel Issues And How To Fix
Excel, while a fabulous tool for PPC, is not without its occasional hang-ups. In this post, we’ll go through some common problems, and how to fix them. To kick things off, it may be helpful to review Excel errors and what they mean. The Error The Meaning The Fix #NAME? Excel doesn’t recognize text in a formula Ensure your formulas are typed correctly, and that any text … [Read more...] about 5 Common Excel Issues And How To Fix
[New Whitepaper!] 34 Excel Tricks To Save Your PPC Life
PPC and Excel go hand in hand. Like peanut butter and jelly. Not only will you become better at analyzing account performance, but you’ll also save a lot of precious time by becoming savvy with Excel and all of it’s features, formulas, and shortcuts. In this whitepaper, excel wizard and account analyst, Rachael Law, lists out 34 tricks to make your PPC life better. Tricks … [Read more...] about [New Whitepaper!] 34 Excel Tricks To Save Your PPC Life
How To Excel Your Search Query Reports
Search query reports are a fact of life in paid search. No matter how great your keywords are, there will always be queries that, for better or worse, don’t quite match your target. Although it’s a crucial part of account success, the web interfaces leave much to be desired. Choosing queries one by one and setting them as negative or adding them as keywords is inefficient … [Read more...] about How To Excel Your Search Query Reports
[New Guide!] The Complete Guide to Using Excel for PPC
Excel is a crucial tool for any PPC marketer’s daily workflow. From building campaigns and writing ads to analyzing aspects of your account, your job will be made (a bit) easier by being Excel savvy. Written by PPC Hero bloggers and excel masters, Rachael Law and Jacob Brown, this whitepaper will outline the most important tasks that we use Excel for in our day-to-day PPC … [Read more...] about [New Guide!] The Complete Guide to Using Excel for PPC
Excel Macros – The Unsung Hero Of PPC
Show me a PPC professional, and I’ll show you an avid Excel user (most of the time). We tend to be wizards at formula writing, concatenating, and calculating cell length. Templates are pretty easy to set up (utilize formulas and simply dump in the data when you’re ready), but this process can get a bit messy depending on what you’re trying to accomplish. Enter the Macro. … [Read more...] about Excel Macros – The Unsung Hero Of PPC
How To Perform Excel Lookups With Multiple Criteria
Everyone loves Vlookups, the formula that helps us quickly match data across our ever-increasing Excel tables. However, there is a glaring weakness - lookups for multiple criteria. Vlookup accepts one value in its first parameter. Need more? Well, that is too bad as the technology just isn’t there yet so break out your pencil and paper, you’re going to be here a while. Now … [Read more...] about How To Perform Excel Lookups With Multiple Criteria
[New Flash Webinar!] Mastering the Art of Ecommerce Reporting with Excel
If you work at an ecommerce company or work with an ecommerce site, you know how important it is to get accurate reporting, in order to manage your marketing programs. In this webinar, experts from Hanapin Marketing walk you through a number of reports and calculations you can use in excel to make sure you have the most relevant and valuable information for your ecommerce … [Read more...] about [New Flash Webinar!] Mastering the Art of Ecommerce Reporting with Excel
Webinar Confirmation: Mastering the Art of Ecommerce Reporting with Excel
You're All Set! You're now registered for Hanapin's Flash webinar, Mastering the Art of Ecommerce Reporting with Excel. Check your email now for a link to join the webinar. Know of a fellow PPC fan who would also love this webinar? or Email It » Other Resources You Might Like: 4 Insanely Easy To Implement Features for Ecommerce Retailers How to Use … [Read more...] about Webinar Confirmation: Mastering the Art of Ecommerce Reporting with Excel
Flash Series: Mastering the Art of Ecommerce Reporting with Excel
More about this 20 Minute Webinar If you work at an ecommerce company or work with an ecommerce site, you know how important it is to get accurate reporting, in order to manage your marketing programs. In this webinar recording, experts from Hanapin Marketing walk you through a number of reports and calculations you can use in excel to make sure you have the more relevant and … [Read more...] about Flash Series: Mastering the Art of Ecommerce Reporting with Excel