Multi-Platform Revenue Rollup with Verified Caveats — 8 Ad Platforms + 2 Storefronts Deduplicated Honestly
Produce a warehouse-wide revenue rollup across many platforms with the caveats published alongside the number — including the ones that mean the headline total is a sum of competing claims, not deduped orders.
What was getting in the way.
"Give us total revenue across every platform we spend on" sounds like a simple sum. In practice, each platform reports a different kind of revenue (attributed vs. transacted, within-session vs. cross-device, deduped vs. claim-based), two of them don't carry the column at all, and a naive sum silently double-counts across most of them. The default output is a confident wrong number.
Context
Universal — applies wherever an AI agent is asked to compose a cross-platform revenue total from exports whose definitions overlap or disagree.
How the work runs.
- 01
Trigger
a stakeholder asks for warehouse-wide revenue across every advertising and storefront source.
- 02
Verify per-source, not per-aggregate
row counts, populated-column checks, and date ranges checked for every source individually; a single aggregate check will hide the sources that silently returned nothing.
- 03
Dry-run cost every scan before execution
no unmeasured warehouse scan runs; cost estimates land in the brief itself.
- 04
Attach caveats to the number
cross-platform attributed totals are declared as a sum of competing claims, not deduped orders; two sources are declared as reporting zero only because the column doesn't exist.
- 05
Ship the eight caveats with the eight-source rollup
every claim in the rollup is traceable to its source scan and its caveat.
- 06
Outcome
a usable warehouse-wide revenue number with its honesty intact.
Evidence from the workflow.
Each system has a role.
Intake
8 ad platforms (search / shopping / social / affiliate)
Intake
2 storefront sources
Record of truth
Data warehouse
Signal (budget guard)
Dry-run cost estimator
Why this is Coworker.
Takes assignments and reports back. You hand it work, it prepares and returns a result.
- 01
Read-only across platform exports and warehouse. The rollup output is never allowed to ship without its caveats attached; the attachment is enforced by the brief template, not left to drafter discretion.
Impact / Outcomes
Delivered a warehouse-wide revenue rollup across eight ad platforms plus two storefront sources, verified per-source by row counts, populated-column checks, and date ranges.
Shipped with eight caveats stated as plainly as the number itself — including that cross-platform attributed totals are a sum of competing claims, not deduped orders.
Two feeds flagged as reporting zero only because the column does not exist — not because performance was zero.
Every scan was dry-run costed before execution — zero surprise cloud bills from the rollup itself.
Find where a workflow like this fits.
Start with the systems, work, constraints, and authority already present in your operation.