Generate campaign revenue reports

Create the revenue report for Q2 email campaigns to send to finance on Friday. Include total attributed revenue, revenue by campaign, revenue per recipient, and a month-by-month trend for April through June. Verify the attribution window used and make sure totals match the payments report.

Make this revenue report easy to approve by finance: summarize total attributed revenue and revenue per recipient at the top, show a reconciled column that maps email revenue to payments entries, highlight any campaigns with attribution windows different from 7 days, and flag anomalies where revenue spikes but conversion rates did not. Add footnotes explaining attribution rules used this quarter.

Finance emailed that attributed email revenue for May is $12,000 higher than their ledger. I pulled the report that used a 7-day attribution window but I don't know whether they used cash or invoice basis, or whether our UTM tagging caused duplicate counts. What steps should I take, in order, to reconcile the two figures and what specific files or queries will resolve it fastest?

Every quarter we spend days reconciling email-attributed revenue with finance and lose credibility. The recurring issues look like inconsistent attribution windows, loose UTM naming, and ad-hoc overrides to conversion settings. Which single change to our reporting process will give the biggest reduction in reconciliation time and what governance step enforces it?