Appends the FIRST append activity that happened IN BETWEEN that primary activity and the next instance of the primary activity. Said another way, append the first activity that happened before the next primary activity.

First In Between

Appends the FIRST append activity that happened IN BETWEEN that primary activity and the next instance of the primary activity. Said another way, append the first activity that happened before the next primary activity.

Learn more in video demo

Example: "For each Started Session, append the first Completed Order that happened but only if it happened within that session (before the next session). "

Useful when you want to...

  • Calculate a conversion rate from the primary activity to the append activity (dataset example)
  • Enrich your dataset with the first order after a session started (dataset example)
  • Find the first order that happened after each order occurred (Order Retention) (dataset example)

‍

SQL Query