Build a source-quality check for a dashboard refresh

Catch silent data problems before a report is shared.
Select independent checkpoints
Choose one spend total, one settled outcome, and one recent event that can be verified from another system. Record time windows and scope before comparing them.

Check known failure modes
Look for missing dates, unexpected zero totals, duplicates, and abrupt changes in unclassified sources. If a number moved, distinguish a real business change from a missing load or updated definition.
Provide a clear status
Mark figures current, provisional, or unavailable. Give uncertain fields an owner and next check date. Keep the last verified report available with its date.
Try a related tool
Find the share of eligible visits that completed a defined action. Count at most one conversion per visit for this calculation.


