Skip to main content

Google Sheets

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 …

How to scrape page data using the ImportXML function in Google Sheets

Posted by: , Posted on: - Categories: Google Sheets

When I’m doing content analysis on GOV.UK, sometimes I need to analyse page level data which is not tracked through analytics software but still represents valuable information. In these circumstances I use the ImportXML feature in Google Sheets which enables …

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 …