Winooski - 11:29 pm on Dec 6, 2011 (gmt 0)

Apologies in advance if this is something that's been hashed over forever, and I'll gladly take my lumps if so.

So a client of mine has an analytics package set up that's capturing good referring URL data but not organic keyword data. What I have is lots and lots of referring URLs from organic search engines, but the precious keyword data is still "locked up" inside those URLs.

I'm thinking, "Hey, it's 2011, there *must* be some desktop app out there that'll take a column of search engine referrer data and then extract the keywords into a new column." However, so far I'm striking out.

What say you, Webmaster World sages?