I was surfing through Sphinn the other day, and I stumbled across an article titled ‘Search Engine Visibility As a Metric‘ written by Richard Baxter. I thought it was a really interesting article, and if you have some time you should read it.
Throughout the article, Richard mentioned many times the calculations on how to determine your SEO Visibility and I got to thinking, ‘I can do that in an excel spreadsheet’. So that’s what I did. At the end of this post I’ve allowed for people to download the Excel Spreadsheet to determine your SEO Visibility and that of your competitors as well.
Very briefly, let me go over how to use the spreadsheet.
- Make sure you have the Rank Checker tool downloaded from SEOBook
- Have a list of 5 other website competitors
There are few tabs in this spreadsheet:
*Competition is the only tab that you need to use for entering data. The rest of the sheets with populate using this data.
You will need to enter your top keywords in the first column. You can enter as many or as few keywords as you would like.
Just as Richard Baxter explains on his blog, there is a point system established for different positions within the search engines. If you’d like to know more on how to calculate your SEO visibility score, you can check you the metric at SEO Gadget.
*Although, Richard’s metic is set to 30 points, I have changed the point system in the excel spreadsheet to calculate up to 50 points for position one, and 1 point for the 50th position. You can actually change the key in the spreadsheet to fit your specific needs 
Once you have entered your keywords, and positions for each search engine you can view your results and graphs showing you how your site compares to other sites in SEO Visibility.
You can download the excel file here:
SEO Visibility Score Sheet
I hope this helps you keep track of your SEO health and saves you sometime is having to build a spreadsheet like this. If you have any questions you can email me at eli@semblem.com, or follow me on twitter: elistevens32 and make sure to subscribe to this blog. I got a lot more where this comes from!
{ 1 comment… read it below or add one }
This is an excellent follow up – cool work Eli!