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) Google: This is pretty straight forward but it’s the main reason I like it. I search for my main seed keyword in Google, and use the keywords that Google itself highlights in bold on the search results, plus the “Searches related to” section at the bottom to get keyword variations or LSI. That’s basically what Google is telling you that topic is about. No need for a thousands other tools. I use these to optimize the on page of my target pages as well.
Be sure to re-evaluate these keywords every few months -- once a quarter is a good benchmark, but some businesses like to do it even more often than that. As you gain even more authority in the SERPs, you'll find that you can add more and more keywords to your lists to tackle as you work on maintaining your current presence, and then growing in new areas on top of that.
1) Ahrefs to quickly see “the big picture” when it comes to any keyword I'm researching. I can instantly see the top holders in the SERPs. I then immediately take the top holders list and go check out their sites. I need to make sure I can beat them content-wise, otherwise I will search for another keyword to try and rank for, or perhaps go down the long-tail route. The Ahrefs tool and data quality get better and better every year. It's one of my favorite tools.
How do I know this? Because I’ve done it! In late 2013 I was still struggling to earn a respectable income online. I started up a keyword research service and marketed it to just this blog audience. It turned out to be quite popular. Basically – I would find niches using Long Tail Pro then create Keyword Research Packages. Each package contained usually several hundred keywords with KC scores calculated. I was selling these packages for anywhere between $97 to $147. I even sold one single package for $597! That one had very high search volumes and very low competition.
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.