Multi-touch attribution via correlated subqueries with date-window predicates. The brand team's most expensive marketing-mix question: are sample drops driving Rx, or just dressing up plain calls? Priority-resolved bucketing assigns each Rx to exactly one promotional touchpoint without double-counting.