Tricky~25min

The Open Rate Fraud

October email campaign hit 51% open rate — best ever. The marketing team is writing it into the board deck. Someone in growth notices the click-through rate dropped to 0.4%. Run the numbers.

Tables you'll query

campaignssubscriberscampaign_events

What you'll learn

SubqueriesJOINsAggregations & GROUP BY
Investigate this case →