Skip to main content

Using XPath and Python with the Google Analytics reporting API to report on a large data set

Posted by: , Posted on: - Categories: Data science, Google Analytics, Python
highwaycode, xpath and python script

A year and a half ago, two GDS Designers asked me, “Can you show us how Highway Code content on the GOV.UK site is performing?” This would have been a simple request, were it not for the sheer number of pages …

Data science projects from our Accelerator and 7th Show & Tell

Posted by: , Posted on: - Categories: Data science, Data Science Accelerator

We’ve recently invited another round of applications to the Data Science Accelerator Programme. This blog gives you a taster of what that involves. It covers recent Accelerator projects and our latest Data Science Show and Tell (where 2 of these projects …

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 …