Using Gephi with Google Analytics to visualize keywords and landing pages As of late, I've been playing a lot with data analysis and visualization tools. Recently I've read two interesting books (Statistical Analysis with R and Visualize This: The FlowingData Guide to Design, Visualization, and Statistics ) and I'm on my way to another two to refresh my statistics knowledge. But this post is only mildly related to these books, since it started way before: the day I read about Gephi. A directed graph is a graph with arrows. Keywords (arrow) Landing pages What interesting things you can read from such a graph Clustering: In this particular instance, I can find the "clusters" of my blog. Step by step guide I'll assume that you can manage to download and install gephi on your own, and have some knowledge of Google Analytics. Then select Show Rows and select 500: And get a nice CSV file with the export tab on top: Remove all this, below Table you should have the useful data, Remove the last line with dashes. And now you should select edges table and comma-separated: Oops!
New public relations: Beating back bad press with Google AdWords The New York Times reported on its front page in September that hoki, an unattractive sea creature best known as the primary ingredient in the Filet-O-Fish, is at risk of depletion. Naturally, the New Zealand companies that farm hoki by the metric ton weren’t pleased by the article, which pointed to “ominous signs of overfishing.” Time was, the subject of a critical news story could write a letter to the editor, issue a press release, maybe demand a correction. Not content with those options, the New Zealand Seafood Industry Council took an approach I hadn’t seen before: buying Google ads for keywords like new zealand hoki and hoki new york times. The ads sought to target people discussing or searching for more information about the story. Now, I don’t really care who’s right in this dispute, though I should note the Times only apologized for using the trade association’s photograph without permission. Targeting reporters where they hang out online is McCarthy’s grating specialty.