Working with SEOmoz Linkscape Data
The fine folks over at SEOmoz provide Pro members with the ability do neat link analysis of web sites and download a CSV of the raw data. Will Critchlow posted over there recently about Advanced Link Analysis Charts to analyze SEOmoz data through their API and a bunch of spiffy Excel graphs. I’m more of a PHP guy, so I put together some very raw beginning code to read in the Linkscape CSV and show pretty pictures using Google Chart.
Getting the data smoothed was one of the hardest things, and I’m still very much not happy with the results.
To use this, upload the following PHP to a web server, put a linkscape.csv file in the same folder, and run the PHP. You should see two charts like these:
Here’s the PHP code. If you add to it, email me a copy at firstname.lastname@example.org and I’ll post an update. I know the code is awful, it’s just a quick hack to play with CSVs and Google Charts.