All free tools / Programmatic
KARI TOOLKIT / PROGRAMMATIC / RECONCILIATION

Placement discrepancy checker

Compare DSP and ad server impression counts, choose your calculation reference, and export the placements that need review.

Free to use. Runs in your browser. No signup or uploads.
Align the reports first. Use matching placement IDs, date ranges, timezones, filters, metric definitions, and fresh reports. A flag is a reason to investigate.

Compare your counts

Up to 500 rows. Required headers: placement, dsp_impressions, ad_server_impressions. Use whole-number counts without thousands separators. Duplicate placement IDs need resolving first.

Absolute difference ÷ ad server impressions × 100. A calculation reference does not establish the source of truth.

10% is an editable example, not an industry tolerance.

Your review queue

2 TO REVIEW
Valid placements4
At threshold or zero reference2
Total DSP impressions249,000
Total ad server impressions224,500

Reference: ad server impressions. Review threshold: 10%.

PlacementDSPAd serverDSP minus ad serverDifference %Status
Prospecting Display120,000100,000+20,00020%At or above threshold
Retargeting Display45,00044,500+5001.12%Below threshold
CTV Awareness82,00080,000+2,0002.5%Below threshold
New Placement2,0000+2,000UndefinedReview: zero reference

Aggregate difference: 10.91% of total ad server impressions. Opposite placement differences can cancel in totals. Small counts can produce large percentages.

Export includes both counts, signed and absolute differences, reference, threshold, and reason. Invalid rows are excluded.

A comparison, then an investigation.

Counting events, reporting latency, filtering, and creative setup can produce different counts. Check the context before escalating a tracking or billing concern.

Google’s guide to reporting discrepancies
Explore Programmatic workflows and custom solutions

Useful once. Even better, connected.

We can explore how this step fits into an automation built around your agency’s tools.

Discuss your workflow