Appends the FIRST EVER append activity for each customer in your dataset, regardless of when the primary activity occurred.

First Ever

Appends the FIRST EVER append activity for each customer in your dataset, regardless of when the primary activity occurred.

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

‍

‍

SQL Query

SELECT ...
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'