adsays.
Analytics & Measurement

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.

Select independent checkpoints. Check known failure modes. Provide a clear status.
Key decisions covered in this article.

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.

Open Conversion Rate