Independent analysis · Public sample data
Product Analytics Command Center
The decision
Could a product team trust the commerce funnel and revenue figures enough to prioritize a change?
What the project built
BigQuery SQL models turn nested GA4 events into sessions, cleaned purchases, product metrics and dashboard-ready views. Purchase events with usable transaction IDs are deduplicated per session. Records without a usable ID are flagged so their uncertainty stays visible.
What the analysis surfaced
The project documents 320 duplicate positive-revenue purchase rows removed and 9.26% of cleaned positive-revenue purchase records without a usable transaction ID. Intermittent cart tracking drove a later reporting cutoff for cart metrics. The published funnel counts sessions with each event and reports a separate sequence check.
Why a partner would refer this work
It shows how to trace an unreliable KPI to source events, document exactly what a dashboard measures, and give engineering a specific repair to make.
Figures are reported in the project’s analysis of Google’s public, obfuscated GA4 sample.