Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Delivery logs outside of the recipient table

Avatar

Avatar
Validate 1
Level 2
andysayers909
Level 2

Likes

12 likes

Total Posts

29 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
andysayers909
Level 2

Likes

12 likes

Total Posts

29 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
andysayers909
Level 2

13-11-2019

Hi there,

We're looking at sending to an imported list on a daily basis, and we want to ensure that should recipients appear on that list on consecutive days, that they do not receive multiples of the same email.

This send will not be reconciled with our main recipient table, so our usual 'filters' that stop this from happening for other deliveries will not work.

We can see that the recipient data from previous ad-hoc list load sends is stored in Adobe Campaign, we're looking for guidance on how we can configure a new query to look at list-load delivery recipients, and use the delivery code for these deliveries to hold out those who have received already for a set amount of time.

Thanks,

Andy

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
Adhiyan
Employee

13-11-2019

Hi Andy,

I think creating a dedicated typology for this list based email delivery would work for you.

In that typology , we can create a typology rule based on delivery logs for a delivery / campaign and see if a email was sent the day before and filter them out from the next days's email.

Regards,

Adhiyan

Answers (3)

Answers (3)

Avatar

Avatar
Give Back 5
Level 4
prasannakumarmarru
Level 4

Likes

50 likes

Total Posts

59 posts

Correct Reply

17 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 50
View profile

Avatar
Give Back 5
Level 4
prasannakumarmarru
Level 4

Likes

50 likes

Total Posts

59 posts

Correct Reply

17 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 50
View profile
prasannakumarmarru
Level 4

13-11-2019

Sggesting this, not sure if this works in your case-

1855188_pastedImage_0.png

We should not join the fork back to exclusion when running for the very first time or use js code to ignore when running for the first time. Thanks!

Avatar

Avatar
Validate 1
Level 4
somasundaramhal
Level 4

Likes

73 likes

Total Posts

71 posts

Correct Reply

12 solutions
Top badges earned
Validate 1
Shape 1
Boost 50
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 4
somasundaramhal
Level 4

Likes

73 likes

Total Posts

71 posts

Correct Reply

12 solutions
Top badges earned
Validate 1
Shape 1
Boost 50
Boost 5
Boost 3
View profile
somasundaramhal
Level 4

13-11-2019

Hi,

Considering that a list of recipients  are stored already in a list via ad-hoc workflow.

In new workflow:

Read list activity -> choose the list

Split activity -> Do not exist such as 'Delivery name' (hoping that the broadLogRcp table linked with the list upload data schema)

Hope this helps you.

Avatar

Avatar
Validate 1
Level 2
andysayers909
Level 2

Likes

12 likes

Total Posts

29 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
andysayers909
Level 2

Likes

12 likes

Total Posts

29 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
andysayers909
Level 2

18-11-2019

Thankyou Adhiyan,

I think this is the best way to progress.

I don't suppose you could provide some sample code that would do this function?

We have further clarity on what we would like to perform on the delivery - What we want to happen is:

If a customer has received a set delivery code in the last 5 days, then remove from that delivery.

Thanks,

Andy