SEO Revenue Estimation Tool

February 3rd, 2011

I built a tool in excel that can help estimate the revenue generated from a having a certain ranking in Google’s organic search results. This is the formula: Local Monthly Search Volume X Click Through Rate of your site’s position X conversion rate X average order value = Estimated sales from SEO rank.

The click through rate of a ranking in Google’s search results is a very fuzzy metric. I took a look at what a few other sites have written on the subject and did an average of my own. Also take into account that not all searches are purchase motivated, some people are looking for information, some are doing research etc.
So plug in your own keyword, global monthly searches from Google’s keyword tool, select you desired rank from the drop down, enter your site’s average order value and average conversion rate and see what you get.

Download SEO Revenue Estimation Tool (xlsx)

Entry Filed under: SEO

Leave a Comment

Required

Required, hidden

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed


Hi, my name is Zach Olsen, internet marketing professional, web entrepreneur & proud dad. Read more...

Get New Posts Via Email

Enter your email address:

Digital Marketing Top Posts

Web Analytics Top Posts

Display/Remarketing Top Posts

Paid Search Top Posts

SEO Top Posts