Complex~40min

The Channel That Looks Efficient Only Because of Lag

content_seo's month-aligned CAC swings from ₹2,500 (looks terrible) to ₹100 (looks amazing) two months later, purely because its signups lag its spend by 2 months. Once spend is compared against signups from 2 months later, the channel's true CAC is a steady ₹500 all year. affiliate also has a bad-looking CAC, and it's tempting to write it off the same way — but its signups genuinely decline every month no matter what lag you test.

Tables you'll query

channelsmonthly_spendconversions

What you'll learn

CTEs (WITH clause)Window Functions
Investigate this case →