Expand my Community achievements bar.

SOLVED

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

Avatar

Level 5

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

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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

Denis_Bozonnet_0-1657700321953.png

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

View solution in original post

4 Replies

Avatar

Correct answer by
Employee Advisor

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

Denis_Bozonnet_0-1657700321953.png

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

Avatar

Level 5

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

Avatar

Community Advisor

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_Szimonisz_0-1657805099153.png

 

Marcel

 

Avatar

Administrator

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!



Sukrity Wadhwa