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)