How to determine if a contact has already been part of the Campaign

[dipendu_g]

Hello All,

We are running a campaign every day, where every ( Author + Book Name ) is picked up with the logic of (current  date - 15 days ) and passed through a campaign.

The issue with this is same ( Author + Book Name ) combination might also show up the next day too, when the campaign is run.

1. How can we ensure that (Author + Book Name ) is uniquely passed through the campaign once

2. Same Author with a different Book Name should be allowed though

Request if somebody can suggest the rule to filter this 

Regards,

Dipendu

[Denis_Bozonnet · Accepted solution]

Hi @dipendu_g 

So if an author + book content has been sent on day 1, it can't be used in day x which is understandable...

The way I would do is to store the author + book in the Delivery Logs and in the workflow bring the author + book from the past 15 days that have been already used and have an exclusion to the ones you currently selected.

To store information in the Delivery Logs, you would have to extend the Target Mapping using the Additional Fields section

Destination is the name of the field that you would have added in broadlogRcp while the Source is the name of the field you are adding in the Target Data in the workflow, this is all case sensitive and pay attention to the @ symbol...

That should do the trick

Hope this helps,

Thanks

Denis

[dipendu_g]

Hi @Denis_Bozonnet ,

Thanks a lot. I will try this option now.

Currently created a table and updating the data and including them in exclusions at the start.

Regards,

DG

[Marcel_Szimonisz]

Hello @dipendu_g ,

you can use also take a look at incremental query that only picks records that meet the condition once. No idea this fits your scenario.

Marcel

[Sukrity_Wadhwa]

Hi @dipendu_g,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!