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
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]