There are a lot of tools on the market for monitoring your ranking. As part of our offerings, our SEO Marketing Firm builds spreadsheets for our clients that provide them with the net improvement in keyword ranking they have month to month.
Utilizing a tool like SEMRush helps significantly because it outputs your keyword ranking in Excel. Month to month, you can simply add the data as a new tab. To show, for example, September versus August stats, I simply insert a column on September's data - then insert the following equation and drag it down:
=VLOOKUP(B2,August!A:B,2,TRUE)-C2
What this does is looks up the exact keyword from one tab, column B, to the next (August tab), and then pulls the rank number and subtracts it from the September rank number (in the second column on August, in "C" on September). If you're going to improve search engine optimization, validating and monitoring your keyword ranking is imperative.
Search engine traffic can rise and fall, so it's essential that you monitor ranking to know whether or not your program is working. In this case, our client improved 11 terms by a ranking of 1 in the last month... no terms dropped ranking. However, their search engine traffic did drop a little.
When the traffic comes back, though, their new ranking will really pay off!
Utilizing a tool like SEMRush helps significantly because it outputs your keyword ranking in Excel. Month to month, you can simply add the data as a new tab. To show, for example, September versus August stats, I simply insert a column on September's data - then insert the following equation and drag it down:
=VLOOKUP(B2,August!A:B,2,TRUE)-C2
What this does is looks up the exact keyword from one tab, column B, to the next (August tab), and then pulls the rank number and subtracts it from the September rank number (in the second column on August, in "C" on September). If you're going to improve search engine optimization, validating and monitoring your keyword ranking is imperative.
Search engine traffic can rise and fall, so it's essential that you monitor ranking to know whether or not your program is working. In this case, our client improved 11 terms by a ranking of 1 in the last month... no terms dropped ranking. However, their search engine traffic did drop a little.
When the traffic comes back, though, their new ranking will really pay off!
Powered by Compendium Blogware
Comments for Tracking Ranking with Excel and SEMRush