Combining WHERE and FOR CUSTOMERS WITH Filters
To apply WHERE filter logic at both the customer and journey-level in a single query, you can combine FOR CUSTOMERS WITH filters with WHERE filters.
Comparing WHERE and FOR CUSTOMERS WITH Filters
WHERE (combined with FROM and TO) filters apply at a journey-level. FOR CUSTOMERS WITH filters apply to the full customer path.
Order of Processing
When combining filters in the same query, product processes the customer-level FOR CUSTOMERS WITH filter BEFORE any Journey-level filters are applied.
Example
The above query is processed in the following order:
- Look for customers that skipped more than two stages.
- Apply the journey cutting and splitting logic to those customers.
- Check each customer journey to see if it has more than 3 interactions.
- If yes, that journey is included in the results for the query.