discrepancy-and-reconciliation

Reconcile ad impression discrepancies between ad servers and DSPs.

1|Updated Jun 24, 2026
One-click install
npx skills add https://github.com/scumunna/programmatic-skills --skill discrepancy-and-reconciliation
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: discrepancy-and-reconciliation
Source: https://github.com/scumunna/programmatic-skills/tree/main/skills/discrepancy-and-reconciliation
Command: npx skills add https://github.com/scumunna/programmatic-skills --skill discrepancy-and-reconciliation

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill resolves discrepancies in ad impressions reported by ad servers and DSPs, ensuring accurate billing and month-end closes.

Core Features & Use Cases

  • Reconciliation: Automatically match ad impressions reported by different systems.
  • Tolerance Band Analysis: Evaluate the acceptable difference in ad impression counts.
  • Root Cause Analysis: Identify and fix issues causing discrepancies.
  • Monthly Close Support: Facilitate month-end reconciliation and invoicing processes.
  • Use Case: If your third-party ad server and DSP report different impression counts for the same campaign, this Skill can help identify the discrepancy, assess whether it falls within an acceptable range, and if necessary, recommend corrective actions.

Quick Start

Reconcile the impressions between Campaign Manager 360 and DV360 for the current month.

Frequently Asked Questions about discrepancy-and-reconciliation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I reconcile ad impression discrepancies between my DSP and ad server?

Yes, you can perform DSP vs ad server reconciliation for monthly billing by providing reports from both systems. The skill matches impression counts, evaluates tolerance bands, and highlights root causes to facilitate accurate month-end invoicing.

What is an acceptable tolerance band for ad impression reconciliation?

An acceptable tolerance band is the predefined variance threshold allowed between DSP and ad server impression counts. This skill evaluates your reported differences against this band to determine if the discrepancy is normal or requires investigation.

How do I identify the root cause of ad server and DSP impression mismatches?

To identify the root cause of impression mismatches, the skill cross-references campaign data from both the ad server and DSP. It isolates the specific campaigns and metrics where counts diverge to recommend corrective actions.

Do I need reports from both the ad server and DSP for campaign auditing?

Yes, campaign auditing requires access to raw reports from both the ad server and DSP. Accurate comparison and discrepancy resolution depend on having the complete impression data sets from both platforms.

Can I automate month-end finance reconciliation for ad campaigns?

You can automate month-end finance reconciliation by matching impression counts between your ad server and DSP. This process supports monthly closes by resolving billing accuracy issues and identifying campaign discrepancies.