Calculate Q1 2025 Campaign Performance Metrics

Tell me about a project where you used SQL, Python, and Excel to analyze marketing data.

For the SQL portion, write a query using the provided campaign and performance data. Calculate campaign-level marketing results for campaigns active during Q1 2025, handling campaigns with no performance records or zero spend.

Output

1. One row per eligible campaign, including campaigns without performance records.
2. Return campaign_id, campaign_name, channel, total_spend, total_revenue, total_conversions, conversion_rate, roi, and performance_band.
3. Sort by total_revenue descending, then campaign_id ascending.

Output details

• Consider a campaign eligible when start_date is before 2025-04-01 and end_date is null or on or after 2025-01-01.
• Include only performance records dated on or after 2025-01-01 and before 2025-04-01.
• Use zero for total_spend, total_revenue, and total_conversions when no performance records exist.
• Calculate conversion_rate as conversions divided by clicks and roi as revenue minus spend divided by spend, rounding both to four decimals and returning null for zero denominators.
• Label zero-spend campaigns No spend, campaigns with ROI at least 1 Excellent, campaigns with nonnegative ROI Good, and all others Needs review.