Reconciling against source systems
Purpose: Verify analytics accuracy against other systems.
Who this page is for
| Audience | Why it matters to you |
|---|---|
| Analysts | Verify data |
| Architects | Design validation |
Reconciliation Against Source Systems
After go-live, verify accuracy.
Common reconciliations
Form submissions:
- Analytics count: event5 = 100
- Database count: submit_form table = 100
- Match? → Data is good
Revenue:
- Analytics revenue: $10,000
- Order system: $10,000
- Match? → Good
Users:
- Analytics visitors: 1,000
- User database: 1,000 logins
- Match? → Good (usually 95-105% is acceptable)
Reconciliation process
- Pick a metric
- Query analytics
- Query source system (same date)
- Compare
- Investigate discrepancies
- Document findings
Expected variance: 1-5% (due to timing, bots, etc.)
---
End of EA · Delivery Lifecycle