The back to school audience will be in the market to purchase. Make sure you are present when they are showing purchasing signs.
Continue Reading Project Your Ad Spend During Back To School Season
Excel
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!
Time is Money: PPC Shortcuts For The Busy Account Manager
I’ve found that people who work in PPC love to work efficiently. We love creative problem solving, but aren’t always particularly fond of spending time doing the more nitty gritty tasks that come along with the job. Time wasting is...
Continue Reading Time is Money: PPC Shortcuts For The Busy Account Manager
Pivot Tables Made Easy: The Last Demo You’ll Need
The more PPC managers I’ve gotten to know, the more I realize that all nerds are not created equal. We talk of Analytics and Excel, and we use the term “pivot tables” a lot. And if you’ve ever tried and...
Continue Reading Pivot Tables Made Easy: The Last Demo You’ll Need
How To Get The Most Out Of AdWords Editor
AdWords Editor is great for making bulk changes to your accounts. It isn’t just a tool for uploading your excel work though. The editor has some great but overlooked features. Features that go beyond the “make multiple changes” button for...
Dynamic Data and Presentation Pizzazz With Excel PowerMap
When it comes to analyzing and optimizing search advertising campaigns, Microsoft Excel is one of the most powerful tools available, and can be found pinned to just about every search marketer’s taskbar or even home screen. When it comes to...
Continue Reading Dynamic Data and Presentation Pizzazz With Excel PowerMap
The 4 Big CRO Lessons I Learned at OptiCon
Last week I flew west to San Francisco to attend the very first OptiCon. OptiCon is Optimizely’s brand new conversion rate optimization conference. Experts from many different companies took the stage to talk about their work and shed a little...
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...
Excel Tips for Working With Modified Broad Keywords
We’ve mentioned it before, but Excel can be a lifesaver when working in PPC. If you know the right tips and tricks, Excel can not only save time, but help you be more accurate. I always create an Excel file...
Continue Reading Excel Tips for Working With Modified Broad Keywords
How to Catch an Affiliate Red-Handed in PPC
It’s important to understand that in PPC, you’re often part of a bigger picture than you realize. Whether in-house or agency, there are many moving parts– external non-Google display buys, social networking, old media advertising, SEO, webinars… the list is...
Continue Reading How to Catch an Affiliate Red-Handed in PPC
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...
Two Simple Tricks To Enhance your Excel Lookups
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...
Continue Reading Two Simple Tricks To Enhance your Excel Lookups
