Analyzing Data from Scratch | Dataford Interview Questions

How do you analyze this data?

Use the tables below to assess lead quality across Insurify sources. Focus on leads created in the last 30 days and compare outcomes by source and response status.

Output

One row per lead source
Columns: source_name, lead_count, contacted_lead_count, contact_rate, avg_response_minutes
Include only sources with at least 5 leads in the period
Sort by contact_rate descending, then lead_count descending, then source_name ascending

Schema

lead_sources

Column	Type	Description
source_idPK	INT	Unique identifier for the lead source
source_name	VARCHAR(100)	Readable lead source name
channel	VARCHAR(50)	Channel category for the source

leads

Column	Type	Description
lead_idPK	INT	Unique identifier for the lead
source_id	INT	Source that generated the lead
status	VARCHAR(20)	Lead status such as new, contacted, or lost
created_at	TIMESTAMP	Timestamp when the lead was created
contacted_at	TIMESTAMP	Timestamp when the lead was first contacted
region	VARCHAR(50)	Lead region

Your question is Analyzing Data from Scratch. 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