AdWords Tips

Using Excel for Google PPC: Fun Stuff and Hard Stuff

November 23, 2011 Posted In: AdWords Tips Comments: 4

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: 

  1. How to write Google PPC ads using Excel.
  2. How to estimate profit/loss for a Google PPC campaign.

Fun Stuff – Writing Google PPC Ads with Excel

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.

  1. Ad line #1: 25 characters.
  2. Ad line #2: 35 characters.
  3. Ad line #3: 35 characters.

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.

Ad Writing Tool

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.

Hard Stuff – Estimating Profit/Loss for Google PPC

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.

  1. Baseprice – I’m selling a product at $20 that I hope people will renew on monthly. That’s why cell B7 is $20 and C7 is $60.
  2. Cost per Click – Even though Google estimates my CPC at 75 cents, I hope they’re wrong. If the cost per click is 25 cents, my test campaign has a chance.
  3. Daily Budget – I’m willing to wager $20 a day for a few days to test the campaign. If it can sell profitably as a test campaign, I’ll advertise as much as I can up to $100 per day.
  4. Conversion rate – Years ago I converted at between 1 and 1.25%. It was an ugly little website that had no stickiness. All it had was a sales page that was done by me. Now that I know WordPress I’ve built a website that has value where there’s a greater chance a visitor will stick around and join my email opt-in list. Hope so.  If it can just sell profitably, I’ll get a professional copywriter for my landing page(s).
  5. Daily net – Green is for money. Currently I estimate the test campaign will break even. If it breaks even, I have a chance to alter it and make a profit.

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.

Campaign Estimator Tool

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.

Profit Complications

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.

Google AdWords and Excel Are Like Peas and Carrots

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)

Location targeting AdWords




If you enjoyed this post, please consider leaving a comment.

Comments

Thursday November 24, 2011

Prude (not verified) Said:

Nice post. This is new and interesting. Thaks for sharing. I'll try using Excel.

Thursday November 24, 2011

Jon Cooper (not verified) Said:

Awesome resource Richard! The future of SEO & PPC isn't nifty tricks, but rather how efficient you are with tools like Excel & Google Analytics.

 

 

 

Monday November 28, 2011

Richard Kraneis (not verified) Said:

Jon,

Thanks for the kind words.

I'm glad you enjoyed my guest post.

Richard

Friday November 25, 2011

Daniel Piechnick (not verified) Said:

I use Excel for AdWords too. Set the font to a monospace font, and set the cell width to 25 or 35 characters. :)

 

Daniel Piechnick
 

Leave a Comment

Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
 
Free Keyword Tool

Get thousands of relevent keyword suggestions - more,
faster, free!

Free Keyword Niche Finder

Discover profitable pockets of keywords for your
business.

Free Negative Keyword Suggestion Tool

Identify wasted spend before it happens and increase
your paid search ROI.

Contact Us | Company | Support | Site Map | Trademarks | Privacy Policy © 2007-2014 WordStream, Inc. All rights reserved.