The Data Standards Authority has published guidance about creating and sharing spreadsheets to help people avoid errors and make their spreadsheets easy to find and use across government.
I wanted to analyse when some GOV.UK foreign language content had last had a content update. I regularly use Google sheets for my analysis, and so use the DETECTLANGUAGE function within sheets to audit our pages without having to worry …
GOV.UK’s search engine is powered by lots of underlying information that isn’t always shown in the main search results. But you can access this valuable metadata through a more technical interface, with filters to get just the details you want.
In my role as the performance analyst for the Digital Marketplace I often need to show the locations of suppliers and buyers. In this post, I want to share some free tools that I use to convert postcode data into …
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 …
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 …
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 …
By adding a piece of Google Apps Script to your Google spreadsheets you can get dashboards containing up to date metrics from Google Analytics automatically emailed to your contacts.
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 …
Using Google Analytics and Google Sheets, you can set up a dashboard to see search terms that people are looking for more than usual. By filtering out searches that are popular all the time, you can focus on what’s new …
Sign up to get updates direct to your inbox and stay informed about improvements to digital products and services in government.