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

How to send email to the recipients of the previous delivery in a trigger workflow

Avatar

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
jasonw30638826
Level 3

01-08-2019

Hi,

I'd like to create a automate trigger that send out three series of emails to the same recipients. For instance. First email A send out today to 100 recipients. 7 days later, send email B with different content to the same recipients as the first email, then 7 days later, send email C to the same recipients of the second delivery. I am having difficulty to find a way to query the recipients of the previous delivery in the automated trigger. If anyone has built the similar workflow, can you please share.

Thanks,

Jason

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

01-08-2019

Hi,

Query nms:recipient, filtering on nms:broadLogRcp. For second email, this would be 'recipient exists in broadlog where delivery=first delivery and status=sent'.

Thanks,

-Jon

Answers (11)

Answers (11)

Avatar

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
jasonw30638826
Level 3

01-08-2019

Thanks everyone. This is helpful

Avatar

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct Reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct Reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
AbdulZa
Level 4

01-08-2019

Remember that batch campaign (adhoc or recurring) are stored in the BroadLogRcp table. RT triggers/messages are stored in different set of tables in Adobe ACC mart.

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

01-08-2019

Yes 1 workflow per delivery is clearest.

Avatar

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
jasonw30638826
Level 3

01-08-2019

I see.  Are you trying to do this all in one workflow?  Will it be easier to have one workflow for each deployment.

1st workflow will be used for 1st email sent to the new recipients who just joined. 2nd workflow will be used to send the 2nd email 7 days after the 1st email. 3rd workflow will be used to send the 3rd email 7 days after the 2nd email is sent?

Thanks,

Jason

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

01-08-2019

*Filtering dimension has to be nms:recipient to do this.

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

01-08-2019

It’s the same, and’ed to this query, though with ‘not exists’ instead of ‘exists’ and with the second delivery instead of the first. You don’t need to do it here if the workflow runs on a daily cadence, since it’s implied by the 7 day check on first delivery. Might come up later on a variant though.

Avatar

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
jasonw30638826
Level 3

01-08-2019

Hi Jon,

I am not quite sure about doing an inverse filter on itself for this delivery. Can you please take a look the query below and see what need to be changed?

1804289_pastedImage_1.png

Thanks,

Jason

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

01-08-2019

Forgot to mention, if this is automated the delivery should also do an inverse filter on itself- where recipient doesn‘t exist in broadlog for this delivery. Otherwise recipients will be spammed until the workflow stops.

Avatar

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
jasonw30638826
Level 3

01-08-2019

Great. Thanks for your help, Jon.  Much appreciated.

Jason

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

01-08-2019

Should be same. Use event date.

Avatar

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
jasonw30638826
Level 3

01-08-2019

Thanks Jon. This works.  I will also need to add delivery create date = 7 days ago which is the date the first email sent. 

Do you know what's the difference between delivery create date and event date under nms:broadLogRcp?

Thanks,

Jason