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 …