Sherlock
Private Detective
Enterprise Grade GA4 Data Quality Monitoring & Alerts
Sherlock monitors the raw GA4 BigQuery export table to uncover critical issues and problems that are buried deep within your data and are completely invisible to the GA4 UI, API, and other standard audit tools.
Private, on-premises setup
Your data and audits stay in your GCP
Checks everything on a daily basis
Alerts when something is off
Want to hire Sherlock?
Deploy Sherlock in your Google Cloud. We set it up once; it watches your GA4 BigQuery export every day and alerts you the moment something breaks.
Runs entirely in your own GCP (project/region you choose)
Incremental, cost-optimized daily monitoring
Slack/webhook/Google Chat alerts
Looker Studio audit report + case history in BigQuery
This is a paid service, please get in touch so we can confirm scope and deployment details and provide a quote.
Want to run Ad-hoc SQL?
You can access the SQL queries used by Sherlock perform audits and train ML models for bot and anomaly detection.
The daily monitoring and alerting systems are not covered by these ad-hoc queries and they do not process incrementally so keep an on your data processing costs!
Private by Design
Sherlock deploys entirely within your Google Cloud environment, ensuring your data, processing, and audit results never leave your secure cloud infrastructure and designated region.
Your data and insights remain private, and your audit results stay protected under your full ownership.
Everything stays in your GCP, ensuring maximum data privacy and compliance.
Surprisingly Cost-Effective
Sherlock is carefully designed to leverage historical runs for incremental processing, and it only stores, queries, and processes the minimum data required for its monitoring and model training purposes. The cost of running Sherlock will be rounding error compared to the value and peace of mind it provides.
Sherlock’s Unique Skills
Hire Sherlock
Observes The Tiniest Details
Gains raw, unaggregated data from BigQuery to audit every parameter of every event, for every user and session.
GA4 Lie Detector
Spots incorrect channel assignments (e.g., paid ads labeled as direct) to keep your data honest.
Tracks Hidden Traffic
Flags internal and untagged traffic, plus suspicious measurement protocol events that might go unnoticed.
Detects Anomalies Early
Leverage BigQuery ML to detect unusual spikes, dips, or patterns in any event or timeframe.
Unmasks the Most Sophisticated Bots
Uses advanced modeling and BigQuery ML to distinguish genuine user activity from deceptive bot sessions.
Keeps a Full Record of Case Files
Archive every investigation in BigQuery for ongoing reference, historical analysis, and cost savings by incremental processing.
Frequently Asked Questions
Hire Sherlock.
How is Sherlock different from Watson?
Sherlock is the next-level data detective that taps directly into BigQuery to automatically monitor the most reliable source of truth, the raw and unaggregated GA4 export table. Watson relies on GA4’s API and can face sampling and data limits.
Can I access the source code or set up Sherlock myself?
If you want to run ad-hoc audits on your GA4 data in BigQuery, you can access and use the main queries that are used by Sherlock for audit, ML training, and forecasting for free, but you will miss daily automated monitoring, alerts, and cost optimization that can only be gained through incremental processing so keep an eye on the costs. Contact us if you’d like to setup the automated and optimized version of Sherlock in your Google Cloud.
Do I need BigQuery skills to use Sherlock?
Not at all. You only need to have your BigQuery data transfer enabled in your GA4 settings. We will deploy Sherlock within your Google Cloud, customize it to your needs, and will wire the Slack alerts and Looker Studio report as well. From there, it runs automatically and lerts you on Slack if something goes wrong in your data.
You only need BigQuery skills if you want to run the ad-hoc queries of Sherlock yourself.
What if I want a free demo before committing?
We’re happy to arrange a call so you can see Sherlock in action and discuss your specific needs and use cases.
Is Sherlock customizable to my unique needs?
Absolutely! From specialized metrics and custom ML models and more frequent monitoring, Sherlock’s framework is designed to flexibly adapt to a wide range of business models and analytics requirements.
How secure is our data with Sherlock?
Sherlock fully deploys and runs on-premises, within your own Google Cloud Project. Your raw data, processing, ML models, and audit results will stay within your GCP project and designated region, ensuring maximum control and security. Sherlock never stores or processes your data on any external servers.
Sherlock’s Audit Handbook
Hire Sherlock.