Thankfully there are a lot of free and commercial tools out there that can help a lot. What they don’t offer though is a way to keep track of all your own vital SEO information in a centralized manner, and you have very little customization or control available.
With this in mind we have been turning our Excel talents towards building some small tools that you can customize easily and completely, and taken together give you a great deal of SEO insight.
The Excel SEO Tools
These tools should be looked at as a suite of utilities but also as a guide to the main tasks that you should be performing in your SEO work. We start with getting an idea for where you are now. What do you already rank for, and how much work will be involved in getting further ahead?
Track Your Search Positions
Over time you will need to monitor your search positions, take note of what helps you creep nearer to that coveted number 1 spot, and what impacts you negatively, driving you down the rankings? The more terms you want to rank for, the more you need to automate this monitoring work!
Generate Keyword Variations
As just mentioned, it is not likely that you will only want to target one search phrase. Generating new phrases that you want to rank for is also important. One way we generate additional phrases is to create small variations on our existing keyword choices, especially when looking at PPC and the long tail. This Excel spreadsheet helps you do this.
Monitor Backlinks
Do you know how many of your link building results are sticking and which links are getting broken or pulled? You need to monitor your links and this spreadsheet will help you automate the process. It will also tell you if the link is passing Google juice or if it has been “no-followed”.
Check Your Redirects
Redirects can have a profound impact on your search results. Ideally when a page is moved, or when you want to send a visitor to a new URL, the redirect should be a permanent one so that the search engines know what to do with it. This tool will check a link and tell you what redirect type is returned and if it is working correctly.
Predict Organic Keyword Traffic
Do you know if that keyword phrase is worth the effort? Use this tool to predict the kind of travel levels you can expect for various rankings.
SEO Competitor Research
SEO is not just you versus the search engines, as you have no doubt realized. Yup, all your competitors are going after the same search results that you are. You need to watch what they are up to and react accordingly. Step one is finding out where your direct competitors are performing.
