Interview Guides
You are given campaign delivery, web session, and conversion data for a multi-channel digital campaign. Write a PostgreSQL query that returns one row per Arthur J. Gallagher campaign and channel for January 2024, showing delivered clicks, tracked sessions, tracked conversions, session tracking rate, conversion tracking rate, and a data quality flag. Treat missing downstream tracking as zero, and classify each row as complete, partial, or missing based on whether sessions and conversions are present relative to delivered clicks.
Use the campaign delivery table as the base so channels with clicks but no tracked sessions or conversions still appear in the output.
