(Apologies in advance if this is something that everybody else already knows...)
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 do you think, esteemed forum members?