4. Set post-search filters. After your keyword suggestion fetch is completed — which might take a while if you input a lot of seed keywords — you need to filter your list. You can: filter out keywords that don’t include buyer modifiers like “best”, “buy”, “purchase”, “discount”, “review” (it’s possible to input one or more words in the filter field at the same time: just separate the words with a comma); add a minimum and maximum amount of LMS; set a minimum amount in “Suggested Bid”; and check for only high “Advertiser Competition” keywords.
"I rarely get excited about SEO and SEM tools...But, when it comes to keyword research it is virtually impossible to produce a quality worksheet without software. When I have to perform the same task for my customers, the process is even more daunting and time consuming...there is now a better way to manage huge keyword lists and this tool is called WordStream."
The Google Keyword Tool has a variety of helpful features meant to streamline the keyword research process. By entering terms or phrases into the search box, the Keyword Tool allows you to build extensive, relevant keyword lists from one simple interface. By default, the tool displays Advertising Competition, Global Monthly Searches, Local Monthly Searches, and Local Search Trends for each keyword. Additional options allow marketers to show the estimated Average Cost per Click, Ad share, and Search Share.
2) SpyFu: I suggest to have paid account on SpyFu. I just need to find my competitors who using Adwords and review them using this tool. It will show me what ads and keywords they are using. Note that my competitor who paid for that particular keyword knows exactly that it is important for his business including recent trends. Also using SEO feature you can input any URL and find our which keywords they are ranking for.
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.