eCommerce · campaign analysis
Ad spend and order value in one campaign report
The challenge
Ad spend and CRM orders covered different scopes. Comparing the headline totals did not give a reliable campaign comparison.
What I did
I aligned the reporting periods, separated the ad accounts and matched orders to campaigns using unambiguous campaign names or tags. Unresolved records stayed separate.
The outcome
I produced a report that compares ad spend with created-order value at campaign level. It makes the supporting data and the remaining verification gaps clear.
Created-order value is not paid revenue or profit. The result is a reconciled report, not evidence of sales growth.
