It is always a great practice to revisit the basics in spreadsheets. By ignoring the basics, your spreadsheets will become unwieldy and difficult to manage.
Continue Reading Simple Tips To Enhance Your Excel Spreadsheets
Excel Mastery
Win the Mobile Bid Battle with 3 Easy Excel Reports
The battle for Mobile PPC supremacy never ends. Restock, reload, and learn how to report on three key mobile metrics you might be missing out on.
Continue Reading Win the Mobile Bid Battle with 3 Easy Excel Reports
Excel Correlation, Causation, and Optimization
Discovering why an account's performance is down isn't always as easy as a stroll through the change history. Sometimes, it takes a little creativity. Sometimes, it takes Excel.
Continue Reading Excel Correlation, Causation, and Optimization
Low Keyword Search Volume? No Problem!
"Low Search Volume" Keywords can be a problem, especially when you use embedded negatives. The solution: Excel-powered VLOOKUPS, naturally.
Excel PPC Heat Mapping 101
Spreadsheets are hard. For the uninitiated, diving in to an Excel file can be a daunting task. Make it easier on yourself with conditional formatting!
How Your Average CPC is Lying to You
“Averages lie.” I had a few statistics courses back in college with a professor who was fond of saying that. Seems like he might’ve gotten that turn of phrase from someone else, now that I think about it. This is...
A Crash Course in Excel URL Generation
Generating destination URLs can be a pain. Depending on your tracking requirements, a destination URL can be as simple as copying your display URL… or it can stretch on in an unending parade of UTM parameters, category IDs, and referral...
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...
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...
