I know, I know – 3 weeks in and I already missed a couple of posts. In my defence, I’ve been pretty damn busy on a Sunday night but hey ho. As always, this entry is from a series of weekly posts highlighting a handful of interesting links I bookmarked each week(s). For the full archives visit the SEO Sunday category page.
- Automating and Scaling Keyword Research
While the techniques and tools discussed are a little bit harder without an Adwords API key, @richardbaxter provides some great insight into scaling keyword research and prioritising keyword targets. - SEO P.I.M.P Music Video – T-Money feat. Craig
Probably the funniest SEO video you’re likely to see this year – seriously good work by the master @ToryMcGill with the usual G.I.T. cameo by @animaxy. I’m hugely surprised this didn’t go a bit more viral among the UK SEO scene. - SEO/social reporting with Google Spreadsheets
This is so awesome. If you ever wanted a Google Docs Spreadsheet to use as a client dashboard then you’re prayers have been answered. I can think of a few extensions but it’s a fantastic first draft. - Copy Detection Mechanisms for Digital Documents
This is a paper written by Sergey Brin way back in 1995, it’s scary to think where Google could be 16 years on – and yet they still seem to fail massively on occasions (hat tip to @paddymoogan for sharing). - 7 Technical SEO Wins for Web Developers
Speaking of @paddymoogan, here’s a post on Distilled covering 7 SEO wins for developers. In conclusion – “Love your developer!” and “Give developers credit where its due”. - Conquer Link Directory Best Practices for SEO
A useful post and well worth a read for anyone in the SEO game. - Keyword Research for Affiliates
A video from @wilreynolds (of SEER Interactive) for a talk given at Affiliate Summit to “help you understand where pockets of opportunity exist” with affiliate keyword research (slides here). - Ex-Googlers Debut Zillabyte To Let Business Users Easily Analyze Big Data
Some ex-Googlers formed a company called Zillabyte and one of their ‘off-the-shelf’ datasets will include a full crawl of the web. Yes, you heard me right. Holy shit. - Data Scraping Guide for SEO
Ultimate round-up of how to scrape every kind of data imaginable for your SEO campaign from @seohimanshu. - Competitive Backlink Analysis
Fantastic post on the Ayima blog by Jane Copland on how to analyse your rivals strong and weak points in regard to their link building campaign. - Excel Dashboards
Not strictly just for SEO, but we can all do with improving our Excel-fu (via @stuntdubl)