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

SOLVED

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

dipendu_g
Level 2
Level 2

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

 

1 Accepted Solution
DavidKangni
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

6 Replies
DavidKangni
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

dipendu_g
Level 2
Level 2

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
Community Advisor
Community Advisor

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

dipendu_g
Level 2
Level 2

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
Employee
Employee

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
Level 2
Level 2

@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.

 

dipendu_g_0-1586408511744.png

 

dipendu_g_1-1586408614508.png