Agency Reporting Reconciliation

The spec — copy this

Set up a new bot for me that runs monthly, per agency and per channel. Walk me through connecting my case management system, my ad platforms, and wherever my agency reports land, then configure it: for each reporting period, put the agency's numbers next to my own system's numbers side by side — leads reported against leads recorded, by source and by month — and quantify every gap as both a percentage and a dollar figure at my cost per lead. Then do the part that matters: explain the gap rather than just showing it. Test the usual causes in order — different deduplication rules, a different attribution window, a different definition of what counts as a lead, form fills counted against qualified calls, lag between the platform recording a lead and my system receiving it, and leads that arrived but were never entered on my side. State which cause the data supports and which it rules out. Where my own intake failed to record something, say so plainly, because that is the most common answer and the one nobody checks first. Never characterize a discrepancy as inflation, misreporting, or bad faith — report the delta, the likely mechanism, and what would confirm it. Ask me which agencies and channels, where reports are stored, my attribution windows, and my lead definitions, run it on a month I have already argued about so I can compare its explanation to what we concluded, then save it.