Learn more in video demo
Useful when you want to...
- Segment your dataset by the first ad source (first touch attribution) (dataset example)
- Segment your dataset by the first item they ordered (split by customer tenure)
- Segment your dataset by the date of the first subscription (think retention curves)
- Segment your dataset by the first page the customer saw
FROM dw_demo.activity_stream AS s
JOIN ( SELECT ... ROW_NUMBER() over (partition by s.customer order by s.ts) as row_num FROM dw_demo.activity_stream AS s WHERE s.activity = 'started_session' ) as first_ever on (s.customer = first_ever.customer and first_ever.row_num=1 )
WHERE s.activity = 'completed_order'