How to find if an Email Delivery was Opened, in Adobe Campaign Standard

[dipendu_g]

Hi All,

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

Dear @pablo_rosero1 @DavidKangni , Need your help

Thanks

[DavidKangni · Accepted solution]

Hi,

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.

Thanks

David

[dipendu_g]

Hi David,

Thanks for responding. I will surely implement the suggestions that you gave.

In my case, I would like to send the same email to all those who have not opened ( maybe after 3 days, as you suggested ).

So in that case will a single send email will work ?

Can you please let me know how to query the broadlog table? 

Because earlier I tried querying delivery attribute for open, but that requires I specifically mention the delivery email, which in my case will keep on changing at every execution

Request if you can point me too a article or some screenshot

[DavidKangni]

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.

Thanks

David

[dipendu_g]

Thanks David for answering my doubts and queries with screenshots. 

I understand the first part of your answer.

But for the second part

The issue is, in case of recurring mails the delivery id keeps on changing every time a new email is send. 

Then how do we find the number of opens for that specific delivery id (email)

Regards,

Dipendu

[ramon_bisswanger]

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.

[dipendu_g]

@ramon_bisswangerI tried getting the master instance, but unable too. Will you be able to help me via screenshot of the workflow.

Is there a way to get the deliverId of the Email delivery to next workflow task. I see that information in the Log and Task when I run the workflow.

If we get that value we can easily match it.