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

Avatar

Avatar
Validate 1
Level 2
dipendu_g
Level 2

Likes

5 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
dipendu_g
Level 2

Likes

5 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
dipendu_g
Level 2

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)

Avatar

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

258 likes

Total Posts

372 posts

Correct reply

152 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

258 likes

Total Posts

372 posts

Correct reply

152 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile
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)

Avatar

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

258 likes

Total Posts

372 posts

Correct reply

152 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

258 likes

Total Posts

372 posts

Correct reply

152 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile
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

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

270 likes

Total Posts

397 posts

Correct reply

198 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

270 likes

Total Posts

397 posts

Correct reply

198 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
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.