You can try DeepMiner. It is good for scrapping, rank position, generating long tails and keyword suggestions. You can export the data to document for later analytics. You can find popular keywords that people are searching for. 7 major engines are supported, Google, Yahoo, AOL, Amazon, YouTube, Ask, Bing. It supports multi-threading so it is very very fast scrapper. BTW you must use proxy list if you plan to scrap thousands and thousands of keywords.
As you can see, LongTailPro is pulling data from Google Adwords. WHAT?! So LTP uses a mix of their own massive data (launched in 2011) and data pulled via API from Majestic.com, Moz.com, and Google Adwords (http://adwords.google.com). Once you input your seed keywords, LongTailPro outputs suggested keywords related to your seed keywords, search volume, Adwords suggested bid, Adwords competition, total words, rank value, average keyword competition, language searched, and location searched.
A very popular and highly competitive keyword on Google search engine is "making money." It has 85,300,000 search results, meaning that millions of websites are relevant or competing for that keyword. Keyword research starts with finding all possible word combinations that are relevant to the "making money" keyword. For example, a keyword "acquiring money" has significantly fewer search results, only 61 000 000, but it has the same meaning as "making money." Another way is to be more specific about a keyword by adding additional filters. Keyword "making money online from home in Canada" is less competitive on a global scale and therefore easier to rank for. Furthermore, keywords also have various intents which can affect whether the marketer would want to target that keyword. Multiple tools are available (both free and commercial) to find keywords and analyze them.
This might be the easiest way to make Long Tail Pro pay for itself. I’m pretty sure that the affiliate program is open to anybody (even if you don’t currently own the product). Simply get signed up and then promote it any way you see fit (within the Terms of Service, of course). If you couldn’t tell, I’ve been doing this for quite awhile via this blog and I’ve earned a healthy sum of money over the years as a result.
Google's AdWords Keyword Planner tool is another common starting point for SEO keyword research. It not only suggests keywords and provides estimated search volume, but also predicts the cost of running paid campaigns for these terms. To determine volume for a particular keyword, be sure to set the Match Type to [Exact] and look under Local Monthly Searches. Remember that these represent total searches. Depending on your ranking and click-through rate, the actual number of visitors you achieve for these keywords will usually be much lower.
"I rarely get excited about SEO and SEM tools...But, when it comes to keyword research it is virtually impossible to produce a quality worksheet without software. When I have to perform the same task for my customers, the process is even more daunting and time consuming...there is now a better way to manage huge keyword lists and this tool is called WordStream."
I want to share how and why I sold the company in order to both educate and inspire potential software entrepreneurs. I certainly don't know everything and obviously companies sell for much more than I sold Long Tail Pro for (I won't be featured in Tech Crunch anytime soon); however, I'm willing to share what I have learned and hopefully that can be beneficial to a few of you.