Write a SQL query to analyze campaign performance by channel and date, including joins and aggregations across multiple tables at Root.
Use the provided campaign, spend, and event data. Include dates with spend or event activity, even when the corresponding metric is absent.
Output
- One row per channel and performance date.
- Columns:
channel, performance_date, total_spend, total_impressions, total_conversions, total_attributed_revenue, and campaign_count.
- Include zero-valued metrics where no activity exists, and order by
channel ascending and performance_date ascending.
