I am looking for best way to handle the duplicates in nms.recipient. The scenario is like we have few duplicate profiles in data source (i.e. 2 recipient IDs for same profile) and would like to know can I create a typology rule or user filter where in I restrict the users by checking the delivery log if the recipient has already received the same delivery then do not send he delivery again.
Tried doing the dedupe by picking up the recent recipient ID but in that case a duplicate entry comes in the latest ID will receive the delivery and then the marketing history will be with with two different recipient IDs.
Is there a way in typology rule or user filter to select any other dimension from different table than recipient? Need to avoid the delivery if sent to same recipient.
The delivery details stored in RecipientDeliveryLog table. When you are creating your query, you can select RecipientDeliveryLog as filtering dimension with Recipient and targeting dimension, as shown below
Add below criteria to select targeting recipients who had already received a particular delivery
Now you can exclude above population from your eligible targeting population.
Also inside delivery you have a option to exclude duplicate recipients.
Open delivery > Click on To > Exclusions tab > Edit > tick check box