Tricky~24min
The Referral Paradox
Affiliate commission spend jumped 23% last quarter. Conversions are up too, so it looked fine. But someone in fraud noticed something strange about the timing between when referral links get clicked and when orders get placed.
Tables you'll query
affiliatesreferral_clicksordersaffiliate_credits
What you'll learn
SubqueriesJOINsDate & Time Functions