Skip to main content

Google Analytics

Using relative date formulas in Google Sheets to query Google Analytics data

Posted by: , Posted on: - Categories: Google Analytics, Google Sheets
Calendar dates

I regularly use the Google Analytics add-on in Google Sheets for reporting data to stakeholders. It's a way to obtain data via the API and run queries which are not possible to do within the Google Analytics interface. I find …

Big sites in Google Analytics Premium: sharing tips & techniques

Posted by: , Posted on: - Categories: Google Analytics, Google Sheets, Tableau
Photo of group in Autotrader's reception, with a Mini half way up the wall

The practical issues of working with huge volumes of data are similar for both public and private sectors. These are the security of third party tools, the challenges of visualising data and the frustrations of working at scale. I joined colleagues from …

7 ways we’ve used Google Analytics ‘outside the box’

Posted by: and , Posted on: - Categories: Google Analytics, Google Sheets, Implementation
Real-time search screen

We’ve been using Google Analytics on GOV.UK for the past 3 years to gain insights into the behaviour of our users. As our knowledge of the product has grown, we’ve regularly explored original ways of using the interface functionality and …

How the Carer’s Allowance service implemented and used digital analytics

Posted by: , Posted on: - Categories: Google Analytics, Implementation
Example of goal funnel on the Carer's Allowance service

This post describes how analytics was successfully implemented and used to develop the new online Carer’s Allowance service. Our experience of many of the existing digital services showed that analytics was thought of as an ‘add-on’ towards the end of …

‘Hacking’ Google Analytics to get real-time internal search terms data

Posted by: , Posted on: - Categories: Data insights, Google Analytics, Implementation

I’ve previously blogged about how we’ve been experimenting with real-time data to create dashboards and custom automated email alerts. In this post I want to share how we’ve been ‘hacking’ Google Analytics to gain useful insights into what our users …