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