Long Tail Pro is a very useful piece of software for long tail keyword research. One of its best features is that you can carry out heavy analysis on the keywords of your choice, without being limited to only working with one or two at a time. It can provide you also with vast numbers of longtail keywords, or you can apply filters to find the precise keywords to fit your bill. And you can check your rankings at the same time!
I’ve found google trends to be an interesting way to see if a keyword (and by extension a niche) is growing or shrinking, and whether it’s seasonal or not. I can’t think of any other tool out there that can reliably tell you this information, so that’s really useful. Also, if you’re building a site, especially an authority site, getting onto something that’s trending upwards is a fantastic idea.
Long Tail Pro is a keyword research tool that helps you quickly find low competition keywords for your website. In particular, the tool is built for people doing SEO (search engine optimization) as opposed to people doing paid ads (Google Adwords PPC). I'm sure there are some advertisers that use the tool for paid ad keyword research, but the tool was built for SEO keyword research.