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)