Classifying Device Categories from User Agent String in SQL with Regex
Our Brands.
Analytics Consulting.
- End to end Analytics
- Measurement Frameworks
- Data Visualisation
- Journey Analysis
- Optimisation Targeting
- Product Analytics
Technologies.
 |  |
 |  |
 |  |
 |  |
 |  |
 |
Analytics Consulting
Analytics Projects
Classifying Device Categories from User Agent String in SQL with Regex
So you have a User Agent string field to transform into Device category, but you want to do it using least resource on query time as possible. The assumption we have made is that for mobile device categories below we are looking for three letter characters and then…
GA4 Ecommerce Implementation Review
SiliconRA have recently been involved in an end-to-end GA4 (Google Analytics 4) implementation. GA4 is a massive booster Companies can: Focus on core KPIs (events) Slice and dice around customer events with value added insight Improve conversion and audience definition Improve customer marketing and optimise site…
PII (Personal Identifiable Information) Redact Regex Pattern
In order to redact PII (Personal Identifiable Information) like name, numbers, a company name or an email from text strings such as comments we have one generic regex pattern to perform the action. This could be used in a SQL statement to remove (the majority of)…
Supercharging Apache Superset – Chart Caching
Great tips for supercharging superset that we are following – caching charts in dashboards for improved performance. Eureka of sorts! – using the cache timeout setting in chart setting. Setting all our charts to 604800 seconds = 1 week where appropriate has increased load time of…