1 – I’ve found a niche with low competition and good CPC . but the thing is the while doing competition analysis. I observed that most of the sites that are in the top 10 serps ranking are small ecommerce site selling their own product or sites like niche specific classified ad site with low and thin content. What are your suggestions ? Should I go for such 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.
1. Create a New Project. By clicking on the “+” icon located at the left upper corner, a new pane will show up allowing you to: enter your new project Title; choose your project’s Country (which affects the total of local monthly searches and top 10 Google results shown); pick your project’s Language (which affects generated keywords and the top 10 Google results for users that use that language); select your Search Network (which affects the number of reported searches depending on your choice between “Google” or “Google & search partners”); and toggle the Adult Ideas switch on or off.
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.

To be convinced of the effectiveness of the product, you have to watch the video. The major benefit you are going to derive from the product is the multiple seed keywords it delivers. Unlike other similar products that give only single seed keyword, you would get multiple seed keyword with this program and you can get this at a time. Because you can process more than one seed at one time, it saves you a lot of time and resources. This is a huge plus to this product.
"Our whole team has a copy of Keyword Researcher, we use it for everyone of our client's keyword research for the 'Long Tail' and we use it every day to come up with blog post ideas and ideas for guest posting. We couldn't live without this tool. I have used every paid keyword research tool under the sun, and this by far is my favorite tool for mining the Long Tail."
The limit on manual keywords could be higher.  I personally wish we could input 10,000 keywords at a time, instead of 200.  However, I understand the costs that Long Tail Pro has to maintain each time a new manual keyword is input.  Not a deal breaker, I just wish the limit was higher. (To be fair, I don't think most keyword tools have a bulk manual option at all).