I just have the free version right now so I don't know all that the pro one can do. But even the free version has A LOT of tools you can use, I haven't even figured them all out yet. But one that I have used is their Content Optimizer. You can take a new or existing content piece of yours, and compare it to one of your competitor's pieces on a similar topic, and see where you might be lacking based on the keywords that are used in each piece.
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.