Adobe Campaign and Web Tech

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

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

Output details

• Filter to deliveries whose channel equals Email.
• Treat the date range as inclusive of 2025-01-01 and exclusive of 2025-07-01.
• Count records with status Delivered as delivered and status Failed as failed.
• Count records with a non-NULL opened_at as opened.
• Round delivery_rate_percent to two decimal places and return NULL when no recipients are logged.