We just sent out an eDM campaign to specific data lists (list a, b and c). Our marketing team just realized that they have missed some of the subscribers and they provided a new data list (d). As we don't want the subscriber receiving the same email twice. so we need to make sure to exclude anyone that exits in list d but also exist in list a, b, c. is there a way to quickly implement the exclusion of previous email address in a particular delivery ?
You have several ways of doing this. What you would implement depends on whether you want to send different emails to the rest at the end or not. As you are talking about lists, I will assume that you use Campaign v6.
1st solution is to create a union of the 3 lists a, b and c and to exclude its recipients from list d. For example like this:
2nd solution is to query the broadlog table to target specifically recipients who received a specific email. You can do that with by adding a Query activity and selecting "Recipients of a delivery". Then just choose the delivery and the query will retrieve its recipients for you. Then you can do as above (exclude the result of the query from list d)
Let me know if this is a solution that can work for you and don't hesitate to share more details if you need more help.
As a side note to my answer, if you want to implement this mechanism so it works on a regular basis, please have a deeper look at what Amit said.
What I propose is more of a one shot and quicker way of doing it but in the long terme you may want to look at pressure rules.
As for the workflow, you simply have to set a primary set. It will simply exlcude all the population of the union from the list (d). If you want to make sure that you only have new emails left, try running the workflow without the delivery activity and inspect the transition.
Much appreciated Florent. This is exactly what I want to achieve.
In the Exclusion do I need to set up exclusion rule in there or just make sure the primary set is list d then campaign will do the work? After the exclusion can I just send out the email via Email delivery as below screenshot ?