2) SpyFu: I suggest to have paid account on SpyFu. I just need to find my competitors who using Adwords and review them using this tool. It will show me what ads and keywords they are using. Note that my competitor who paid for that particular keyword knows exactly that it is important for his business including recent trends. Also using SEO feature you can input any URL and find our which keywords they are ranking for.
Because great content requires a deep understanding of the main idea (e.g., “ac repair houston”) and the supporting subtopics that require coverage (e.g., “central ac vs portable ac systems”) and the common issues that users seek answers for (e.g., “freon,” “refrigeration loops,” “coolant refills,” “troubleshooting”), the effectiveness of a keyword reporting tool is only as strong as the SEO pro using it.
I also want to emphasize that Microsoft Excel and Google Docs perhaps play an equal, if not more important role in keyword research than any of these tools, because at the end of the day, the mountain of data you end up with is of no use if you can’t perform calculations, sort, filter, present or store it in a way that’s best suits the task at hand. Head over to Distilled for a comprehensive Excel for SEOs guide. Alternatively, bug this guy—he’s the Sensei who trains Excel ninjas in the dark of the night.