Adobe Campaign and Web Tech | Dataford Interview Questions

Tell me about Adobe Campaign Classic and your experience with HTML, CSS, JavaScript, and SQL.

For the SQL portion, write a PostgreSQL query using the Adobe Campaign Classic delivery and broad log data to report email performance for deliveries launched during the first half of 2025.

Output

One row per qualifying delivery, ordered by launch date and delivery ID.
Return delivery_month, delivery_id, delivery_name, recipient_count, delivered_count, failed_count, opened_count, and delivery_rate_percent.
Include deliveries with no broad log records, and calculate the delivery rate as delivered recipients divided by all logged recipients.

Schema

adobe_campaign_deliveries

Column	Type	Description
delivery_idPK	INT	Unique Adobe Campaign Classic delivery identifier
delivery_name	VARCHAR(150)	Delivery label
channel	VARCHAR(30)	Campaign communication channel
start_at	TIMESTAMP	Delivery launch timestamp

adobe_campaign_broadlogs

Column	Type	Description
broadlog_idPK	INT	Unique broad log identifier
delivery_id	INT	Referenced Adobe Campaign Classic delivery
recipient_id	INT	Recipient identifier
status	VARCHAR(30)	Delivery outcome status
opened_at	TIMESTAMP	Timestamp when the message was opened

Your question is Adobe Campaign and Web Tech. 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