TO EACH LAST

A TO EACH LAST filter splits the journey on every last occurrence of the final interaction context you specify in your query.

Example

TB - to each last query

Splitting Process

IconDescription
TB - Badge 1Find first interaction on Mobile and continue to first non-mobile interaction.
TB - Badge 2Mark the Mobile interaction prior to that interaction as the end of the journey.
TB - Badge 3Move back to the first interaction on the full customer path. Mark as the start of the journey.
TB - Badge 4Find the next Mobile interaction and continue to the first non-mobile interaction after that.
TB - Badge 5Mark the Mobile interaction prior to that interaction as the end of the journey.
TB - Badge 6Move back to end of previous journey. Mark interaction immediately after that as start of the next journey.
TB - Badge 7Repeat steps 4 through 6 to the end of the customer path.

Example

TB - to each last example

Results

In this example, you end up with a three customer journeys based on the specified filter criteria.

Suggested Scenarios

Use Case 1

Initial Question

What products did customers purchase together?

Query

FilterQuery Parameters
TO EACH LASTActivity Type = Check Out
discover journeys to each last interaction(activity="Check Out")

Analysis

  • Finds each instance of a check out event and defines that event as the end of the journey.
  • Includes all interactions, such as add to basket events, taking place prior to the check out event in the same journey, providing a very good idea of all products purchased in that single check out event.

Use Case 2

Initial Question

I want to identify customers making repeat calls to the assisted channel, for help and assistance.

Query

FilterQuery Parameters
TO EACH LASTChannel = Assisted
discover journeys to each last interaction(touchpoint="Mobile App" device="iPhone")

Analysis

  • Cuts the journey on each last assisted interaction, when there are a series assisted interactions in a row.
  • May include other assisted interactions that occurred without any non-assisted interactions in between.
  • Need to view the journey to see if there were transitions into the specified assisted node, from other assisted nodes.