Charity analytics case study: Scottish Book Trust

Scottish Book Trust – an Edinburgh-based national charity that believes books, reading and writing have the power to change lives – launched a new website in 2019. They quickly realised that they needed rich web analytics data to evaluate its performance.

What did we do?

  • Set up custom event tracking in Google Analytics & Google Tag Manager
  • Completed a full digital analytics audit of Scottish Book Trust website
  • Integrated Firebase app data with Google Data Studio using Google BigQuery

What was the outcome?

  • Comprehensive and clear custom events now form the basis of Scottish Book Trust’s Google Analytics reporting
  • We can now easily report on app data through Google Data Studio
  • We are also working through a roadmap of analytics improvements

After launching our new website at Scottish Book Trust in 2019, we wanted to enhance our web analytics capabilities. Daniel very quickly got up to speed with our organisation and what we were trying to achieve. He developed a detailed analytics audit which we worked through with him to improve our setup and use of Google Analytics and Google Tag Manager. Alongside this Daniel was integral to helping us improve our approach to our mobile app analytics.

We found Daniel easy to work with, approachable and very quick to deliver results.

Samantha MacKinnon

Initially, Scottish Book Trust needed custom tracking in Google Analytics to evaluate website KPIs such as interactions with audio and video content, as well as content downloads and clicks through to external websites.

Charities often have a complex, broad set of activities, which is then reflected in the outcomes we need to measure. These can range from events and fundraising, to advocacy and providing valuable content.

Due to extensive experience working in the charity sector and with other large charity clients, we were able to progress quickly and effectively from the brief to a concrete work plan. Based on our initial consultation, Scottish Book Trust agreed that we should set up a more comprehensive range of tracking and carry out a web analytics audit.

Digital analytics audit & review

The web analytics audit is extremely helpful for any charity or organisation to review their current analytics setup and identify any opportunities and issues. An audit will typically focus on Google Analytics and Google Tag Manager, touching on other tools such as Google Data Studio for reporting, dashboards, and visualisation, or Google Optimize for AB testing and conversion rate optimisation.

After reviewing the completed audit, we identified a list of analytics tasks by priority. These ranged from simple rationalisation and tidying of the Google Analytics account and tagging, to more strategic questions around an organisational measurement framework and approach to reporting.

Mobile app analytics

As a separate mini-project, Scottish Book Trust were also keen to be able to report on their mobile apps more easily. Separate apps used Mixpanel and Firebase, and we evaluated methods of creating dashboards for this data.

In particular, we found an opportunity to set up an automatic export of data from Firebase to Google BigQuery, which in turn allows Scottish Book Trust to easily pull the data into their Google Data Studio reports.

Over the course of a few months, we have completed some highly targeted and impactful analytics work, characterised by a relaxed, professional, and efficient working relationship. The work was carried out on an on-demand basis – no contract or retainer - and amounted to a few days in total.

We hope to continue working together and bringing value to Scottish Book Trust and all their beneficiaries through data analytics.

If you'd like a consultation about how I can help your charity or organisation with data analytics, you can find me on LinkedIn, or email me at [email protected]

linkedin