USING and EXCLUDING Filters
USING and EXCLUDING filters enable you to find journeys based on customers being included in or excluded from the results of another query.
Combining USING with EXCLUDING
When combining a USING filter with an EXCLUDING filter, always specify the USING filter first. Specify the EXCLUDING filter immediately after the USING filter.
Examples
discover journeys using (query='Awareness to Enrollment') excluding(query='Customers in Control Group')
Applying USING
You apply USING to any query with the following requirements:
- With the exception of an EXCLUDING statement it must be the last portion of the query before the NAMED portion.
Examples
discover journeys using (query=<QueryName>)
discover journeys for customers with count of stage skips > 1 using (query=PMA Candidate Offer)
discover journeys where count of stage skips > 2 using (query=<queryname>)
Applying EXCLUDING
When using EXCLUDING the results of the specified query are ignored in the execution of the current query.
Using EXCLUDING with USING
When applying the USING filter, you can exclude a query result that is is being used by another query. EXCLUDING follows USING directly in the query.
Examples
discover journeys using (query='Awareness to Enrollment') excluding(query='Customers in Control Group')