Explain how you would utilize Python, R, or advanced spreadsheet functions to diagnose an unexpected drop in marketing campaign performance.
For this SQL exercise, use the supplied weekly campaign and regional benchmark data to identify campaigns whose latest conversion rate declined materially from the previous week and declined more than their regional benchmark.
Output
- Return one row per qualifying campaign with
campaign_name, channel, region, previous_conversion_rate, latest_conversion_rate, campaign_drop_pct, and benchmark_change_pct.
- Include only campaigns with at least a 20% conversion-rate decline and a worse decline than the regional benchmark.
- Sort by
campaign_drop_pct descending, then campaign_name ascending.
