Has anyone come up with a solution for gathering "trends", if you will, from a large amount of longtail data? Say you have an automobile site, and you get tons of longtail searches every day (as I'm sure most of us do). Is there any easy way to go through and find similar search queries? Obviously a lot of people are looking for the same thing, but don't type the exact same thing into Google when they're looking for it: How long do tires last? What are the longest lasting tires? Which car tires will last the longest? How long will tires on my car last for? Is there any way to find similar searches and group them together or something? This could be very useful, especially in generating new content for your site.
Not sure if this is helpful or not but... If you go to traffic sources > Keywords > non paid > then find keyword containing "YOUR KEYWORDWS" you can at least find organic search visits that are related to a couple of keywords e.g "car tires".
Not sure of a tool, but you can go through your keywords in Google Analytics and pick the long tails.
SpotOn, not trying to be harsh, but are you just trying to increase your post count? Obviously I know I can pick the longtail out of analytics, but when you have thousands of them it becomes a daunting task =)