Daniel Robertson: Data analytics for social impact
The current crisis is tough on everyone. I recognise that even in the good times, charities, non-profits, and NGOs can struggle to fund, deliver, and justify their essential work.
We’ve all suffered losses in business, funding, and activity (not to mention the terrible human toll of Covid-19), so I’ve decided to offer some pro bono consultancy to any charities large or small who would like to explore the potential of data analytics.
Charities are undergoing digital and data transformations with increasing pace.
My new case study, courtesy of Scottish Book Trust, explores some of the data analytics work we did following the launch of their new website. We worked with Google Analytics, Google Tag Manager, Firebase, BigQuery, and Google Data Studio to structure and improve their insight.
Our work together encapsulates web and mobile app analytics, as well as looking at the wider measurement and optimisation strategy for Scottish Book Trust as an organisation.
Google Data Studio is becoming the go-to reporting tool for data analysts in many sectors. In this article I take a look beyond the typical marketing data connectors like Google Analytics and delve into open source data from a wealth of freely-available sources, courtesy of data.world.
No need for complex engineering or data pipelines – with just a little bit of SQL and using Data Studio’s native connector, a whole new world of data can be delivered right to your dashboards!
“It lives, Igor!” Or so I wanted to shout out across the cafe as I was sitting working on my laptop. Probably best that I didn’t.
After months of architecture documents and repeating the phrase “from an analytics point of view…” as part of a website rebuild, it was time to put my process to the test.
Rome wasn’t built in a day. That’s as true if you are talking about an historic city, a megalithic software project, or a web analytics implementation.