Sherlock – Your Smart GA4 Auditor with BigQuery

Sherlock is a robust Looker Studio Data Connector that securely taps into your GA4 export table in BigQuery. It gathers pristine, unaggregated evidence to uncover subtle anomalies and deep insights that traditional audits miss. Sherlock can audit every parameter of every event, for each session, user by user

Sherlock’s Key Capabilities

  • Observes Every Detail

    Gains raw, unaggregated data from BigQuery to audit every parameter of each event, per session, user by user.

  • Exposes Channel Lies

    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.

  • Uncovers Anomalies

    Leverage BigQuery ML to detect unusual spikes, dips, or patterns in any event or timeframe.

  • Unmasks Bot Traffic

    Use advanced modeling to distinguish genuine user activity from deceptive bot sessions.

  • Keep Records

    Archive every investigation in BigQuery for ongoing reference and historical analysis.

 Private by Design and Cost-Optimized

Private GA4 Audit

Completely Private

Sherlock uses a secure service account to to generate a one time tocken to access to run queries and store data in your own BigQuery environment, same project and location (EU, US) that you store your GA4 export table. Everything stays under your control, ensuring maximum data privacy.

Cost-Effective GA4 Audit

Cost-Effective

We carefully designed the storage and query models so that even a property with 1M daily events will likely spend ~ $1 per day.

Seamless Access to Audit Results

Seamless Access to Audit Results:

You will have access to a copy of your audit results in a dataset that is created in the same location where your GA4 tables are stored.

Next-Gen GA4 auditor

Next-Gen GA4 auditor

Ready to Hire Sherlock?

Contact us today to discuss your unique GA4 challenges. We’ll tailor Sherlock’s investigation to your data volume, goals, and compliance needs—no one-size-fits-all pricing or enrollment caps.

✓ Secure & Private
✓ Fully Customizable
✓ AI-Powered Analysis
✓ Efficient & Scalable
✓ Proactive Alerts

Frequently asked questions

  • Sherlock is our next-level data detective that taps directly into BigQuery for raw, unaggregated insights—unlike Watson, which relies on GA4’s API and can face sampling or data limits.

  • Absolutely. Contact us if you’d like to handle the installation yourself, customize the code, or prefer a fully ready-to-use dashboard solution.

  • Not necessarily. We provide setup guidance, and our user-friendly dashboard makes most tasks straightforward. Advanced users can still leverage full SQL and ML capabilities if they want.

  • Just let us know! We’re happy to arrange a demo so you can see Sherlock in action with your own data or sample data.

  • Yes. From specialized metrics to custom ML models, Sherlock’s framework is designed to adapt to your business and analytics requirements.

  • All data stays within your private BigQuery environment, ensuring maximum control and security. We never store your data on external servers.