SEO NEWS 
News Archive
March 2012
February 2012
January 2012
December 2011
November 2011
October 2011
September 2011
August 2011
July 2011
June 2011
May 2011
April 2011
March 2011
February 2011
January 2011
December 2010
November 2010
October 2010
September 2010
August 2010
July 2010
June 2010
May 2010
April 2010
March 2010
February 2010
January 2010
December 2009
November 2009
October 2009
September 2009
August 2009
July 2009
June 2009
May 2009
April 2009
March 2009
February 2009
December 2008
November 2008
October 2008
September 2008
August 2008
July 2008
June 2008
May 2008
April 2008
March 2008
February 2008
January 2008
December 2007
November 2007
October 2007
September 2007
August 2007
July 2007
June 2007
May 2007
April 2007
March 2007
February 2007
Rapid Protoyping with the SEOmoz API
August 31, 2010, 1:05 pmI am out in Seattle for the SEOmoz PRO seminar (don’t forget to come to the London seminar!) where the second day has kicked off with two of the best presentations I’ve seen in a long time from Seth Besmertnik from Conductor and Wil Reynolds from Seer Interactive. Feeling the pressure a little bit for my session on Sexy Reporting this afternoon, I thought I’d share one extra tip.
I often need to build a quick n’ dirty bit of analysis of link data. Since the exports from Open Site Explorer only pull 10,000 links at a time, I look to pull data out of the SEOmoz API and dump it into Excel.
This little bash script (which needs the domain and credentials inputting) lets you quickly pull backlink data:
( for i in {1..250}; do curl "http://lsapi1.seomoz.com/linkscape/links/XXXXXXXXXXX?Filter=external&SourceCols=133982846973&TargetCols=133982846973&Sort=page_authority&AccessID=XXXXXXXXXXX&Expires=XXXXXXXXXXX&Signature=XXXXXXXXXXX&Scope=page_to_domain&Limit=5&Offset=$((i*100))&"; done ) | tr "}" "\n" | perl -pe "s/[\]\[]//g" | perl -pe "s/,{//g" | perl -pe "s/\"[^\"]*\"://g" | perl -pe "s/^{//g" >> output.csv
I’ll be talking a little bit about doing stuff with this in my presentation later today, including decoding bitflags in Excel.
If you like the presentations from the Distilled crew, you might like to sign up to our free conference calls:
