01
What to pull
- Store truth: orders and net revenue by creation date, excluding cancelled and fully refunded orders.
- GA4: purchases and purchase revenue, session-scoped, with the attribution model stated.
- Meta: purchases and purchase value at the 7-day-click, 1-day-view setting you actually optimise on.
- Google Ads: conversions and conversion value, with the counting setting (one per click, or every conversion) stated.
- Spend per channel for the same seven days.
- Derived: reported ROAS per platform, and blended ROAS computed from store revenue over total spend.
