"The IWMW event provides an opportunity for those involved in the provision of institutional Web services to hear about institutional case studies, national initiatives and emerging technologies and to actively participate in a number of parallel sessions."

IWMW 2013 is the seventeenth workshop.

Workshop Session A6: Interfacing Google Analytics with Google Sheets for Primary and Secondary Data Analysis

Title:

A6: Interfacing Google Analytics with Google Sheets for Primary and Secondary Data Analysis

Session Tag:

#A6

Time:

Wednesday 26^th June 2013 from 16:00-17:30

Facilitator:

Martin Hawksey, CETIS

Abstract:

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.