Clean Null Campaign Metrics | Dataford Interview Questions

Task

You are given a single table of daily StackAdapt campaign performance metrics. Some rows have missing values in impressions, clicks, or spend. Write a SQL query that returns each campaign_name with the number of rows that contain at least one null metric and the average spend after treating null spend values as 0.

This tests whether you can handle incomplete performance data safely in PostgreSQL without dropping rows that still matter for reporting.

Problem

Task

This tests whether you can handle incomplete performance data safely in PostgreSQL without dropping rows that still matter for reporting.

Problem

Task

This tests whether you can handle incomplete performance data safely in PostgreSQL without dropping rows that still matter for reporting.

Problem

Task

This tests whether you can handle incomplete performance data safely in PostgreSQL without dropping rows that still matter for reporting.