Follow

Querying Multiple Lists for One Value Simultaneously

A SuppressionList Query step may look for a single value in multiple lists with just one query step.

The simplest use case for this feature would be if distinct lists are maintained for de-duping of different offers, but you want to filter for duplicate leads across multiple offers.

Mapping The Query

Assume that offer 1 maintains a duplicate-checking list named "offer_1_dupes" and offer two maintains a separate list named "offer_2_dupes". You'd check in both of those lists by mapping both List Names into the query step, separated by a comma:

 multilist_query_mappings_1.JPG

Using the Results - Simple Duplicate Checking

If you don't care which list might contain the query Value, your related filters or rules could be based on the "SuppressionList Query Item Found" appended datum. This will be true if the query value is found in at least one of the lists:

simple_dupe_filter.JPG

Using The Results - Identifying Which List(s) Contain the Query Value

Sometimes it may be important to know if the query value was found in a particular list or more than one list. That's where the "SuppressionList Query Item Found In" array comes into play. This is an array that contains elements containing the List Name of each list where the query value was found. For example, if as above you're querying two lists, there may be zero, one or two "SuppressionList Query Item Found In" appended data; Zero if not found, one if found in one of the lists, and two if found in both of the lists.

Here is a filter that will trigger if the query value was found in the "offer_1_dupes" list:

specific_list_filter.JPG

 and this filter triggers only if the query value is found in both lists:

found_in_multiple_lists_filter.JPG

 Note: You cannot query multiple values at once.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

You must be logged in to comment.