Why do “great numbers” sometimes feel dangerous?
User counts explode. Conversions exceed forecasts. Channels look wildly efficient. Based on this, decisions are made:
• scaling
• bonuses
• ownership
I’ve seen careers built — and damaged — on these numbers.
Where does the illusion start?
Deduplication errors quietly inflate reality. One user becomes two. One conversion becomes many. Reports look better, decisions follow — until reality catches up.
Then the system stays invisible. People don’t.
What usually gets underestimated?
Deduplication isn’t a technical nuance. It’s the foundation of trust. Errors at the identity level scale into management mistakes.
How I make it visible early
I treat deduplication as a first-class metric:
• duplicate share
• ID collision rates
• stitching scenarios
These numbers must be visible 'before' decisions are made — not after consequences appear.
Want all my best GA4-BQ queries in one place? I turned them into a Chrome extension — top SQL queries you can search and copy in seconds.
Go here to install it for FREE.
Prefer the web version? It's here.
