I recently decided to go with ahrefs after using spyfu for a couple years and trialing secockpit. I was a moz client for awhile too about a year ago. I found spyfu data to be sketchy (or just plain wrong) fairly often, and moz, I don’t know, just didn’t seem like they were really into supporting what I wanted to know. secockpit was achingly slow for a trickle of data. ahrefs isn’t nearly so graph-y as spyfu, but they are so blazing fast and the data is so deep. I enjoy it a great deal, even if it is spendy.
This database was built using data from BEFORE Google required active ad accounts to get good keyword data & before they started blending data together for similar terms. Even if you set up an AdWords account and spend significant sums of money with them, they may require you to run your ad campaign for 3 or 4 months straight before they will show reasonably precise data instead of exceptionally broad data ranges.
I’ve got to say thanks for the introduction to Long Tail Pro, It’s because of this review that I even came across it in the first place, I’ve been testing it out for the past few days and it’s awesome. Already found some “low hanging fruit”, though I do still prefer Niche Genetics for the organic listings. This has easily replaced using Google’s keyword planner and a note pad. Thanks again 🙂
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.
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.
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.