Institutional Web Management Workshop, IWMW 2013
Workshop Session A6: Interfacing Google Analytics with Google Sheets for Primary and Secondary Data Analysis
- A6: Interfacing Google Analytics with Google Sheets for Primary and Secondary Data Analysis
- Session Tag:
- Wednesday 26th June 2013 from 16:00-17:30
- Martin Hawksey, CETIS
A recent conservative estimate indicated 88% of UK universities use Google Analytics on their main website. At the IWMW 2010 event Ranjit Sidhu highlighted the value of using Google Analytics data to justify the roles of web teams. One of the issues with Google Analytics data is it is often the domain administrator is the gatekeeper, selectively releasing the data in a controlled way can be a challenge and often the only option is all or nothing.
In this workshop delegates will learn how Google Sheets and Google Apps Script can be used to selectively extract data from Google Analytics making it possible to analyse using built-in Google Sheet tools like tables, charts and pivots, or selectively republished for use in other tools like R or InDesign. Additionally participants will also learn how using Google Sheets data can be combined with other datasets such as Twitter, providing near realtime insight to website traffic and interaction.
Workshop Session Page on Lanyrd
Further information about this session is available on Lanyrd. If you attend this session or would like to track it feel free to join the Lanyrd entry.