Data & Attribution

The Quarterly Data Quality Audit

8 min read
The Quarterly Data Quality Audit

Tracking does not usually break loudly. A developer renames a form field, a consent banner update changes load order, a tag gets duplicated. Conversions drop or double, the dashboard still renders, and nobody notices for six weeks — by which time decisions have already been made on the corrupted numbers.

The monthly reconciliation

Compare orders in the analytics platform against orders in the finance or order-management system for the same period. They will not match exactly; what matters is that the gap is stable. A gap that was eight percent for a year and is now twenty-five percent is a defect, and you have found it in weeks rather than quarters.

CheckFrequencyFailure it catches
Analytics vs finance ordersMonthlyMissing or duplicated conversions
Event volume anomaly alertsDaily, automatedBroken or fired-twice tags
Key funnel step-through ratesWeeklySilent breakage in mid-funnel
Campaign parameter complianceMonthlyTraffic misfiled as direct
Consent state distributionMonthlyBanner regressions

Automate the watching

Humans are bad at noticing a twelve-percent drift. Set volume thresholds on your ten most important events and alert when a day falls outside the expected band. The alert does not need to be clever; it needs to arrive on the day it happens.

Every deployment is a tracking change until proven otherwise. Put event verification in the release checklist.

Prioritise by stakes

Not all data deserves equal scrutiny. Revenue events, conversion events and the fields that feed ad platform optimisation are worth strict monitoring. A scroll-depth event on a marketing page is not. Auditing everything equally means auditing nothing well.

Keep a visible register of known data issues with their impact and status. It prevents the same discovery being re-made every quarter by a different person.

Fix the source

Patching a dashboard to exclude a broken week hides the problem. Fix the collection, then note the affected period in the register and annotate the chart. Anyone reading that series in a year will need to know, and by then nobody will remember.

Related articles