SQL for Drop-Off in Registration | Dataford Interview Questions

Write a SQL query to find the daily active users who interacted with a marketing campaign but did not complete the registration funnel.

Use the campaign_interactions and registration_funnel tables. Treat a user as having completed the funnel when their funnel status is completed.

Output

One row per activity date with columns activity_date and daily_active_users.
Include only users who interacted with campaign doximity_registration_campaign and have no completed funnel record.
Count each user once per date and order results by activity_date ascending.

Schema

campaign_interactions

Column	Type	Description
interaction_idPK	INT	Unique interaction identifier
user_id	INT	User who interacted with the campaign
campaign_id	VARCHAR(100)	Marketing campaign identifier
interacted_at	TIMESTAMP	Timestamp of the campaign interaction
interaction_type	VARCHAR(50)	Type of campaign interaction

registration_funnel

Column	Type	Description
funnel_event_idPK	INT	Unique funnel event identifier
user_id	INT	User associated with the funnel event
funnel_status	VARCHAR(30)	Current registration funnel status
completed_at	TIMESTAMP	Timestamp when registration was completed

Your question is SQL for Drop-Off in Registration. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem