Excel

Love and marriage, love and marriage, goes together like Excel and pay-per-click… As PPC account managers, we spend most of our day in Excel sorting and summing and doing just about anything else we can to PPC data. You truly can’t have one with the other.


Excel Solver Video

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 …

Excel Solver Featured

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 …

Frequency Cap

Frequency Capping with Confidence on the Display Network

Google offers a really great report on the Dimensions tab that shows you how your display ads perform depending on how many times a user has seen them.  We’ve talked about the report before (along with how great it is), …

sotheby's

Use Google’s Auction Insights to Find Your Competitors’ Mistakes

Auction insights is a feature that Google launched in May of 2012 and it is incredible. It lets you see who is participating in the same auctions as you along with their impression share and some other fun metrics. I …

Analytics Featured

Judging your PPC Ads by Analytics Metrics

I thought I’d write a quick blog post as I’ve been working on some ad test results this morning and wanted to share a quick set of techniques for judging winners without conversion data. Most of the time we talk …

pivot table love

The 10 Reports that Made Me Fall in Love with Pivot Tables

Lots of crazy stuff has happened in PPC during 2012.  Even though that’s been true pretty much every year since its launch, we at PPC Hero felt that it was a big enough year to justify its very own series.  …

Thyme. Get it?

PPC Hero’s Top Time Saving Tips During Your Busy Holiday Season

It’s a busy time of year.  There are so many products you want to sell, so many bids that need to be changed, so much ad text you need to refine.  We here are PPC Hero have thought that you …

Untitled 2

Wasting Money In Your PPC Accounts? Pivot Tables Are Here To Help!

Dave Rosborough shows you how to use pivot tables in Microsoft Excel to make your PPC accounts more profitable!

Gumshoe

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 …