I need to find out in an Workflow, if an email delivery (recurring) was opened by users, so that I can target non open users again. I need to send the same mail again to them.
In workflow, we have a query wherein using delivery shortcut we are able to determine email opened, but in that case we explicitly choose the delivery. But each time a delivery is run, it creates a new delivery id ?
In that case how can we trace whether the new deliveryEmail was opened by profiles/users
After Wait 5, I need to determine how many opened the email, if no move to send First Email again
This is a normal behaviour of a recurring delivery to create a new delivery for every run. I will recommend you to use a normal delivery in that case.
Also keep in mind that 5 min is too short to check the open and clicks.
I will recommend to wait at least one hour or eventually 3 days to avoid email fatigue.
To find users that opened or clicked, you'll to query the recipients broadlogs table.
You can query on the Recipient table with filtering condition like :" TrackingLogRcp does not Exist such as Url type=Open" AND "Date is on or after (current date-3). This should give you the recipients who have not opened emails in the last 3 days. Please find a screenshot for how the query should look like.
Inside the ID of delivery filter , you should use ID(name) . There is no internal name in ACS.
The created execution deliveries are having a link to the main delivery (master instance).
With that you could determine anyone who did not open any of the execution deliveries and could combine that with date checks, etc.