Predefined filter for avoiding duplicates

mohiniu12161390

25-06-2020

Hi,

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.

Really appreciate if someone can guide.

Thanks!

Duplicate Predefined filter Typology

Accepted Solutions (1)

Accepted Solutions (1)

InMo

25-06-2020

Hi @mohiniu12161390 ,

 

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

 

InMo_0-1593085306543.png

 

Add below criteria to select targeting recipients who had already received a particular delivery

InMo_1-1593085324340.png

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

see below screen print  (marked in yellow)

InMo_0-1593137395345.png

 

 

Hope it helps

 

 

Regards

Answers (0)