"This is the only keyword research tool that I recommend. The ideas, inspiration, and content longtails you will get for your niche topic are going to result in you producing a page of content that is more than going to pay for this tool. And as they are Google's database then we KNOW that these terms are being searched by a decent volume of peeps every month. It's a goldmine dudes."

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.

3. Finally, there's just good old research through trends and news. Google Trends, keeping up on industry news of the business, and even newsjacking (if there are relevant topics). These all require different resources depending on the business, but once you find the leaders in their news you can not only leverage them for keyword research but also glean insights into how you can become an industry leader yourself (and dominate SEO).

This is a really straight-forward strategy. Contrary to popular opinion – small niche websites can actually still work. Basically, you create a small website that is hyper-focused on one long tail keyword. You create the very best resource on that specific topic and publish the very best content on the internet based around that long tail keyword. Monetize with something simple like Adsense, Amazon or another affiliate product – then just sit back and watch the money roll in every month!
3. Set your pre-search filters. Depending on whether you are looking for a new niche to build a site around or trying to find keywords to target on your already existing website, the minimum amount of local monthly searches (LMS) you set might vary. For new niches my LMS criteria is 1,500-5,000 searches, for posts anything from 10-800 is fine. Also, depending on one of these goals you can add a lower or higher number of words in the respective filter: for new niches 3 (or, at times, 2) words minimum, for new posts from 3 or 4 words up.
Am I worried that my keyword research might not be effective since I only look at the KC score? No. Not really. Because I tend to target only the longer tail keywords these days. I don’t go after the huge main keywords anymore. They’re too hard to rank for. But long tail keywords are really easy to find with Long Tail Pro and they are usually much easier to rank for.
Keywords are supplied with accurate, clickstream-based metrics, some of which are exclusive to Ahrefs. For example, Clicks and Clicks Per Search can give you a better idea of how much traffic your content can get. That’s a burning issue today – many queries never translate into clicks because Google reveals answers for them at the top of SERP (i.e., Knowledge Card).
The “Starter” tier, with 1000 keyword lookups every 24 hours should be enough for anyone starting out in blogging – or even people who are quite established. It’s pleasing to see a product where they don’t seem to trick you into having to pay for a more expensive version. On the more negative side, I did feel that you’re nudged towards doing annual payment, with the monthly option kept slightly “hidden.”

So what exactly is Keyword Competitiveness (KC)? It’s only the feature within Long Tail Pro that completely changed the game and made keyword research so ridiculously simple that even a dumb truck driver like me could become an expert! It basically works like this. As soon as you click the button in Long Tail Pro Cloud to retrieve keywords, it automatically calculates a number for each keyword (between 1 and 100) based on several different SEO factors. Lower numbers mean the keyword is easier to rank for and higher means it is harder to rank for. More on that below…

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.