Hello,
I have promoted two lists; and there seems to be some patrons that were on BOTH, so now they have two promotions under their account.
What criteria and operators do I use in List Manager to get the small list of patrons that appear on BOTH lists. I cannot seem to figure out the logic.
Thank you,
Jessica Kalinski
McCarter Theatre Center
Hi Jessica,
Since we can't use the HAS operator with Promotion Source Number I think we need to make two lists to get your results.
Make a list with one of the source codes as the criteria using the equals operator.(Promotions > Promotion Source Number)
Generate that list.
Make another list with the same criteria but using the other source number as well as adding in the list you made with an operator of IN.(Other > List)
Generate that list
That should give you all the people that are on both.
Hope that makes sense.
Or even better (just realized you mentioned using the lists), if you still have those two lists you used to do the promotions you can use those by creating a new list using the Other > List criteria twice.You can use the operator of HAS for both.
Example.
List HAS (your first list)List HAS (your second list)
Generate that and you should have your results.