Hello SEO: Where worlds collide

Something I’m increasingly become aware of is SEO is not just about having the right metadata on your webpage, in fact arguably this is the least important aspect. The area I’m particularly interested in is the tools/techniques the SEO community use to gain ‘actionable insight’. In this post I highlight how some of my tools have made it into the SEO community and why this area should be on your radar.

Using Google Spreadsheets as a Google Analytics Data Bridge

Access control to Google Analytics data is very coarse. Via the web interface you can have full access or none at all. Given the growing interest in data driven decision making at all levels of the institution I thought it would be beneficial to demonstrate how Google Spreadsheets and Google Apps Script could be used to selectively distribute Google Analytics data. This solution was developed for my session at the Institutional Web Managers Workshop 2013 (IWMW13) which I talk about in more detail at the end of this post.

Sankey your Google Spreadsheet Data #d3js

“Sankey diagrams are a specific type of flow diagram, in which the width of the arrows is shown proportionally to the flow quantity.” In this post I introduce a basic wrapper to render data from a Google Spreadsheet with a d3js generated sankey diagram