If you own a small company and use or are considering using Google pay-per-click (AdWords) for your goods and services, this article is meant for you.
I’m including two practical Excel techniques in this article:
First the fun stuff. Seven years ago when I ran my one and only Google PPC campaign (a profitable one), I really didn’t enjoy writing Google pay-per-click ads. I hated counting the letters in the ads to meet Google’s criteria.
I wrote the ads on scraps of paper when I had creative flashes. Naturally I lost some of the slips of paper and started using Microsoft Word. That’s how I wrote Google PPC ads seven years ago.
Too late I realized I could have used Excel to write my Google PPC ads.
Whenever I type a new ad line or revise one, Excel calculates the number of characters in the ad line and tells me if it’s too long. If the length of the ad is OK, there’s no warning.
In column B I used an =LEN formula and in column C I used an =IF formula. Some people love Excel, some hate it, and some tolerate it. If you love Excel you can build your own spreadsheet like the one shown above. If you’d rather use my spreadsheet, you can visit my Excel site to download my Google AdWords campaign spreadsheet, which includes the PPC ad writing tool.
Starting a Google AdWords campaign without estimating the profit/loss of a test campaign is foolish. You absolutely need an Excel spreadsheet to make estimates.
Seven years ago I sold an ebook in 40 countries on how to use Excel. Years ago, my average CPC was 8 cents. Google’s Traffic Estimator tool now estimates that a click will cost me 75 cents. But absolutely no one is advertising for my chosen keywords so I’m hoping Google’s estimate is wrong.
Shown below, the colored cells are the most important to me.
Will it run at a profit? Column B is a breakeven analysis. Column C is the blue sky analysis where my wife is shocked with income magically appearing in our checking account via PayPal.
If my new ebook and Google AdWords marketing is just 1/3 as successful as my Column C, you’ll hear shouts of joy from Chicago, IL, USA.
If you know Excel, reverse engineering my spreadsheet above won’t be hard. If you’d rather use mine, you can download my Google AdWords campaign spreadsheet here.
My Google AdWords PPC spreadsheet is for selling an ebook. My only cost was Google AdWords. If you’re selling new garages your estimates will be different. As a business owner with a team of garage builders sitting idly by, you have different costs to add to your spreadsheet. If you’re thinking of outsourcing a Google AdWords campaign to someone, then you need to add that cost structure to your spreadsheet. Google AdWords experts don’t work for free.
Isn’t that the line from Forrest Gump? He and his girlfriend were like “peas and carrots.” If someone is advertising profitably with Google AdWords, somewhere there’s an Excel spreadsheet keeping score.
I’d like to thank Elisa Gabbert and the nice people at WordStream for helping me with this blog post. If you need copies of my Google PPC spreadsheets, just visit Your Excel Coach.
This is a guest post by Richard Kraneis, a frequent commenter and occasional contributor at the WordStream blog. Richard is a training consultant and online marketer. He’s offering his Microsoft Excel services at Your Excel Coach and his just for fun blog is What is a Film Camera?
(Read More: A Tutorial on How to Create Excel Bubble Charts)
Please read our Comment Policy before commenting.