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.

Note: In effect, this prevents one query from deleting the results of another query that is being used elsewhere in Dynamic Audiences.

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.

Note: In effect this prevents one query from deleting the result of second query that is being used by another query.

Examples

discover journeys using (query='Awareness to Enrollment') excluding(query='Customers in Control Group')