Taking this site as an example, “home working” is a pretty important keyword. I’d love it if I could be at the top of Google for that phrase. However, despite pouring heart, soul and a great many man-hours into creating a useful resource for home workers, I’m not yet anywhere near the first page of Google’s search results. (I’m actually languishing depressingly on the 11th page of results at the time of writing!)

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.

2) Software project no 2 – invite your readers to participate and select 2-5 that will enter a mastermind group with you – and let the readers follow the progress – from brainstorming to hiring a coder, to beta testing, to “how to reach out to get sales” (I know you wrote a post on this – but would be great to tag along). And then those that are not part of the Mastermind group could be added to a forum/FB group and can then follow along and develop and ask each other for help.
Joost developed his own keyword research tool to come up with keywords as well! Yoast Suggests uses the Google Suggest functionality you know from searching in Google. It finds the keyword expansions Google gives and then requests more of them. So if you type ‘example‘, it’ll also give you the expansions for ‘example a…’ till ‘example z…’ etc. Just go on and try it and fill out some of your potential keywords. It’s a great way to quickly find more long tail keywords you can focus on.
I love Moz’s interface and how they give you data on the keywords. It’s easy-to-read, making it an ideal solution for both experts and newbies alike. They’ll show you both numeric and visual representations of a keyword’s monthly search volume, its opportunity for ranking, priority, and difficulty. They’ll also show you keyword suggestions and SERP analysis, which is fantastic and detailed.

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).