Tricky~24min

The Notification Black Hole

Churn is up and retention emails are supposedly catching at-risk users before they leave. The retention team swears the "we miss you" campaigns are running. Pull the email delivery logs and find out who actually received them.

Tables you'll query

usersemail_logs

What you'll learn

SubqueriesJOINsNULL Handling
Investigate this case →