I need to send out an email with these requirements:
-Member of uploaded list
-Already in the database
What filter would I use?
The best way that I can think of for you to do this is to filter by the person was created filter and set that date to be before the day you imported the list. Because of Marketo's de-duping capabilities, it will just update the lead record to the preexisting lead when you upload them via list import if they were already in the database. So if you set the person was created filter to before the day you imported the new list, it should tell you who was already in the Marketo database prior to your new list upload. Hope this helps!
Hi Courtney and Casey,
The person was created is a good start, but the date is not the correct constraint. Use the "List Name" constraint instead.
And read this, it's all documented