A few weeks ago we covered INDEX MATCH as a replacement for VLOOKUP in excel. We only scratched the surface though. There are many more uses for INDEX, MATCH and VLOOKUP, using them together can even help you in a few tricky situations where a simple VLOOKUP or INDEX MATCH doesn't do the trick. Using MATCH to Deal with Inserted Columns in VLOOKUP One of the major issues with … [Read more...] about Two Simple Tricks To Enhance your Excel Lookups
Search Results for: excel
6 Excel Tricks to Save Your PPC Life
It comes as no surprise to most of you, but we get a lot of mileage out of Excel in PPC. Seeing as how the AdWords and Bing Editors are capable of accepting spreadsheet uploads, and how each interface can turn out roughly a billion Excel-based reports, it doesn't hurt to brush up on your Excel skills from time to time. While every function listed here isn't always useful 100% … [Read more...] about 6 Excel Tricks to Save Your PPC Life
This 15 Minute Excel Macro Provides Granular Search Term Data
It's series week on PPC Hero and we continue our run-down of time-saving techniques we've adopted in the past 12 months. This week Eric has already looked at building out your account, Carrie has dived into quick and dirty quality score techniques, and Sam showed you the ten minute 'sense-check' audit. Today, I'll be showing you how to analyze every word of every search term … [Read more...] about This 15 Minute Excel Macro Provides Granular Search Term Data
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
Analyze Your Account in Minutes With Excel
This week, we've been focused on giving you all kinds of tips and tricks with Excel to help you build out your accounts. Kayla showed you how to use Excel to estimate new account performance. Sean showed you how you can use Excel to find the best budgets for your campaigns. Dave showed you some quick tips with Excel filters to quickly structure your keyword … [Read more...] about Analyze Your Account in Minutes With Excel
5 Excel Time Savers For PPC Ad Writing
For the next edition of our Excel for PPC series, I'd like to show you some cool tricks I use for Excel when writing ads. 1. Use Ad Groups as Ad Titles For this to work, you need to structure your ad group to describe perfectly what you're selling or advertising. Like, if I'm selling coffee mugs, and I decide to make an ad group for every color. So, my ad group will be … [Read more...] about 5 Excel Time Savers For PPC Ad Writing
3 Time-Saving Techniques For PPC Managers Using Excel Filters
Mounds of data, MS Excel and large coffee; these are three things that I’ve come to know and love as a PPC manager. In fact, these things go hand-in-hand with each other (some would argue about the coffee) because Excel provides us with ways to manipulate and analyze all of the data we’re confronted with on a daily basis. Perhaps this is why we’ve decided to pursue the topic … [Read more...] about 3 Time-Saving Techniques For PPC Managers Using Excel Filters
Using Excel to Get the Best Budgets for Your Campaigns
One of life’s essential conundrums is how to allocate your resources. Whether it’s your energy, your time or your money, figuring out what to do with what you have determines what kind of person (or company) you’re going to be. When it comes to life, most of us are left to our own devices, which explains why I spend such an inordinate amount of my time watching reruns of … [Read more...] about Using Excel to Get the Best Budgets for Your Campaigns
How to Use Excel to Estimate New PPC Account Performance
To start off our September PPC Hero series on how to use Excel for that next level of PPC super performance, I decided to do just that: start from the beginning! Is there a way to determine possible account performance before opening up the floodgates and turning your account on? We got this question via our Twitter account last month and the short answer is yes…and you can do … [Read more...] about How to Use Excel to Estimate New PPC Account Performance
Templated Success: How To Make Your Life Easier With Excel
Anyone who has ever been put under pressure to build out a large account in a short space of time will know the trademark feeling of despair that can come with such a task. Luckily for us, there are a number of tools at our disposal that can speed up this process. When trying to build out thousands of ad groups, ads and keywords, templates can really improve your overall … [Read more...] about Templated Success: How To Make Your Life Easier With Excel
How To Prepare A Landing Page Report In Excel
So, you've been testing landing pages like a good little PPC Account Manager should. Good job! But, now what? How do you tell which is doing the best? How do you present this to your boss/client? Prepare a landing page report in Excel--duh! Don't worry, Jessica Cates is going to show you exactly how to do it. You'll be on your way to showing the results of all your hard work … [Read more...] about How To Prepare A Landing Page Report In Excel