Interview Guides
You are given a small marketing pipeline feeding an executive dashboard. Write a PostgreSQL query that returns one row per report_date and campaign_name for January 2024, showing the cleaned spend, clicks, and conversions used in reporting, plus a data quality status. Treat missing metric rows as 0, negative spend or clicks as anomalies that should be replaced with 0, and rows with NULL conversions as missing conversions that should also be reported as 0. Label each row as ok, missing_metrics, or anomalous_metrics.
Return only active Google Ads campaigns, keep dates even when no metric row exists, and sort by date then campaign name.
