Blog
Analytics insights
Practical articles on tracking, SQL, redaction, and measurement strategy.
A Practical First GTM Server-Side Tracking Setup for GA4 and Meta Conversions API
A guide to routing GA4 events through a server-side Google Tag Manager container.
Beyond Regex: How Cloud NLP Services Detect Personal Data at Scale
A practical review of the mechanisms behind modern entity detection, PII redaction, machine learning and transformer-based language tools.
First-Pass PII data redaction with SQL Regex at the core
Using regular expressions to reduce obvious personal data exposure before analysing free-text feedback comments.
Lightweight Device Categorisation from User-Agent Strings in SQL
A pragmatic way to classify mobile, tablet and desktop traffic without adding a full user-agent parsing library.
Joining CSAT Survey Scores to Page View Data in SQL
Analytics Engineering · SQL · Feedback Scoring Joining CSAT Survey Scores to Page View Data in SQL How to connect customer feedback to behavioural analytics s
Taming URL Chaos: Regex Strategies for Normalising GOV.UK Page Paths
How to group analytics events by meaningful page structure when your URLs contain user IDs, tax reference numbers, and random alphanumeric tokens