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.
You would add the List criterion (which lives in the Other folder) to your set twice, select HAS as the operator both times, and then select the first list for one criterion and the second list for the other. That should give you everyone who appears on both lists.
Kevin Sheehan
Senior Technical Writer & Consultant
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com
Hi Ryan and Kevin:
Ryan's first suggestion of "I think we need to make two lists", generated a count of 2 patrons. Which are two patrons who do appear on both lists.
Your same suggestion of "using the Other > List criteria twice. You can use the operator of HAS for both." Generate a count of zero.
Jessica
To clarify, the two lists you add to the criteria set for my second suggestion (as well as Kevin's) would be the same lists that you used to create the promotions. One line in the set for each, using the operator of HAS for both.If that is what you did, is it possible that these lists got regenerated? Are they dynamic?Also make sure you used HAS and not IN.Just checking because this suggestion should work.
Anyways, glad you found your patrons.
Cheers!