Great rundown of the keyword tool strengths. I've also used and continue to use several tools to get a complete picture. Have you tried SEOCockpit? (https://www.swissmademarketing.com) It is one of my favorite overall tools and I am curious how well it performs on the long-tail side.

George-We supported an event with a Real Estate Association that was a casino night. We brought a photo booth that gave the realtors the ability to tweet and post to FB immediately, along with a photo clip to take with them.

This resulted in brokers and realtors sharing the event and the pictures on their local profiles, along with shares from broker offices on their own websites. Great local link building results from an event they already had on the calendar, we just added some digital to it!