Popular Blogs

Search Advisory (127)
Stacy Williams
stacywms
Trust but Verify (104)
Kevin Beaver, CISSP
kbeaver
Hunter Technical Resources: Nothing But The Net (72)
Richard E. Steele, Jr.
ricky
Smorgasbord of IT/Biz Perspectives (38)
Ashu Bhatia
ashubhatia
Navigating the Meaning of Today's Accelerating Changes (38)
Sherry Heyl
sherryheyl
Media Exposure for Technology Companies (27)
Stephanie Richards
writeway
Leadership (18)
Mark Sohl
marksohl
(27)
Dux Raymond Sy
meetdux
Perceptions. Marketing through the B2B Technology Kaleidoscope (5)
Anne Marsden
anne@marsdenassociates.com
Southern Technology Leaders (1)
Kurt Uhlir
kurtb
(1)
Maurice Rosenbaum
mrosenbaum
Best Practices in Online Marketing (1)
John Waddy
john@twentysix2.com

Recent Comments

Stacy WilliamsSoCon 10: The Social Media “...
Stacy Williams says: More coverage: http://www.myurbanreport.com/2010/02/the-best...
Stacy WilliamsSoCon 10: The Social Media “...
Stacy Williams says: I have no idea why those links aren't live - I'm contacting ...
Stacy WilliamsSoCon 10: The Social Media “...
Stacy Williams says: Here are some additional posts covering the event: http://b...
Kevin Beaver, CISSPWhen using a Web hosting provi...
Kevin Beaver, CISSP says: Someone posted a comment to this post earlier today. I recei...
Kevin Beaver, CISSPFeatured in the new issue of E...
Kevin Beaver, CISSP says: Here's a direct link to the scanned magazine page in case yo...

Blog Posts


Print PDF
stacywms

We're getting better and better at predicting the success of our search marketing efforts in advance.  I'm just geeky enough to find it fun to dust off my high school algebra skills and crunch numbers.  Here's the scenario that a prospective client recently challenged us with.

They said, "We've got $2500 to spend on clicks with PPC.  Our goal is a $100 cost per sale or less, and we typically close 70% of our leads."  That's it -- that's all the information we had to go on, but it was enough.  Here's how I was able to use that information to predict whether or not we could be successful:

  • I put together a quick and dirty sample PPC campaign on Google.  First, I used Google AdWords' Keyword Tool to generate a list of about 180 relevant keywords.   (Note that a real campaign would contain thousands of keywords -- this is just a starter list to give us rough data.)
  • I downloaded the list of keywords into Excel and loaded them in Google's Traffic Estimator, using the $2500/month budget.  This allowed me to play around with different bids (maximum costs per click, or CPCs) to see how results varied.  Raise the max CPC and the average position/ranking increases, which can generate more clicks.  But it can also generate fewer clicks because each click is more expensive, meaning the budget buys fewer clicks.  So, by lowering the max CPC, I was able to find a "sweet spot" of $1.50 max CPC that generated more clicks -- 1290 -- than did either lower or higher max CPCs.  (Note that the actual CPC paid is predicted to be $1.13, and that Google estimates are often off, but it's a start.)
  • How many sales would we have to generate to meet our goals?  At a $2500 spend and a $100 cost per sale, we'd need to generate a minimum of 25 sales.
  • How many leads would we have to generate to meet our goals?  At a 70% close rate, we'd need to generate a minimum of 36 leads.
  • What kind of conversion rate would we need to generate 36 leads from those 1290 clicks?  Answer: 2.8%.  We know, based on past experience, that this is very do-able.
  • If you're really paying attention and breaking out your calculator here, you may notice that a $2500 budget and $1.13 actual CPC should buy 2200 clicks, not 1290.  By adding more keywords to the campaign (beyond the preliminary list of 180), we should be able to do this.  To generate 36 leads from 2200 clicks, we'd only need a conversion rate of 1.6%.  This is even more do-able than 2.8%!

Bottom line, when a prospective client can give us just a few basic pieces of information, we can fairly quickly tell them whether or not our search marketing services can help them reach their goals.  They know what to expect, and we know what to shoot for.  It's a win-win, and it doesn't even require statistics or calculus!


Trackback(0)
Comments (1)Add Comment
0
...
written by Mark S., June 04, 2009
Great post, Stacy. I haven't used the Traffic Estimator enough but this makes me want to use it more.

Write comment

security code
Write the displayed characters


busy