-- Compare June channel contribution
SELECT oe.channel, SUM(oe.profit_before_marketing) - ms.spend
FROM order_economics oe JOIN marketing_spend ms
ON ms.channel = oe.channel AND ms.month = oe.order_month
WHERE oe.order_month = '2026-06' GROUP BY oe.channel, ms.spend;

channel	contribution_profit
paid_social	−4,972.75
organic_search	6,653.11