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

Last Ever

Appends the LAST 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 last time the customer ordered (RFM analysis)
  • Segment your dataset by the last time the customer came to the site
  • Enrich your dataset with the last plan type they updated their account with

SQL Query