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

dipendu_g

30-03-2020

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

 

dipendu_g_0-1585586101750.png

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

 

Accepted Solutions (1)

Accepted Solutions (1)

DavidKangni

MVP

31-03-2020

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

Answers (2)

Answers (2)

DavidKangni

MVP

01-04-2020

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.

 

davidk23955130_2-1585756610752.png

Inside the ID of delivery filter , you should use ID(name) . There is no internal name in ACS.

davidk23955130_0-1585756724834.png

 

Thanks

David

ramon_bisswange

Employee

07-04-2020

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.