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
Investigate this case →