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

Last In Between

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

Learn more in video demo

Example: "For each Started Session, append the last FAQ page that was viewed but only if it happened before the next session."

Useful when you want to...

  • Identify the action that caused a customer to leave/abandon.
  • Find the last search term in between every started session (what caused the customer to leave)
  • Find the last Viewed Ad in between every page view
  • Find the last FAQ page of a customer's session

‍

SQL Query