In the figure below, you can see I have set up a keyword rating spreadsheet. I first gathered keyword data from a keyword tool to populate the orange columns. In this example, I used the Google AdWords Keyword Tool. From there I began looking at each keyword and gave each one a score from one to 10. For some I built a formula to automate the process, which comes in handy with larger keyword lists.
Why make the same mistakes your competitors have made when you can learn from them? As its name implies, SpyFu is a great way to spy on the competition so you can learn from their failures and more importantly, their successes. When you type in a competitor's URL, you'll be able to see how many keywords they are ranking for organically and even the ad value of those keywords. It also offers good analytics on backlinks driving the most traffic to your competitors' sites so you can see where you might want to publish guest blogs or be listed. If they are running any paid advertising campaigns, you can even see what campaigns they're running and how much they're spending.
Now the ad servers don’t create this table themselves, they license it from another company like MaxMind or DigitalEnvoy, whose primary business is geolocation data. This is no enviable task; IP addresses themselves don’t necessarily have an obvious pattern in the way they are assigned like a telephone area code would. It’s a bit like solving a mystery, and the geolocation companies use a variety of methods to approach the problem. /injects>