PPC Excel Tips For Every Level: Part 2, Faster Campaign Analysis For Intermediates

Today we have more handy Excel tricks from Bing Ads Evangelist John Gagnon. This second installment of PPC Excel tips focuses on intermediate level techniques for speeding up campaign analysis. Paid search managers will benefit, but really anyone using Excel for data analysis will find good…

Please visit Search Engine Land for the full article.

Dashboard Series: Creating Combination Charts In Excel

I’m starting a series on dashboards because I think creating sexy dashboards is a critical skill every marketer needs to know. It’s going to be a long series — but by the time we’re finished, you’ll be able to create dashboards that excel in both form and function. Why Use Combination Charts?…

Please visit Search Engine Land for the full article.

Deduplicate Your Google Analytics Reports in Excel

One of the steps in my last post on finding 404 pages worth saving involved determining if any of your404 pages received traffic in the past year. This can be accomplished by pulling a landing page report and using VLOOKUPs in Excel to see any of your …