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
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
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
Views
Replies
Total Likes
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
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!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies