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.