Marketing Attribution SQL interview questions

Ad-tech and growth roles ask you to credit conversions to touchpoints. Practise lookback windows, last- and first-touch selection, linear splits and ROAS without double-counting spend.

Last-Touch Attribution by ChannelfreeMarketing Attribution · Window Functionshard
First-Touch Attribution with a 14-Day LookbackMarketing Attribution · Window Functionshard
Linear Attribution and ROAS by ChannelMarketing Attribution · Subqueries & CTEshard