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

Thanks everyone. This is helpful

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.

Yes 1 workflow per delivery is clearest.

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

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

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.

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?

Thanks,

Jason

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.

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

Jason

Should be same. Use event date.