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 query the DIDN’T OPEN emails from last 3 days in adobe campaign management.

Adobe_campaign1
Level 2
Level 2

How to query the DIDN’T OPEN emails from last 3 days in adobe campaign management.

1 Accepted Solution
Adhiyan
Correct answer by
Employee
Employee

Hello Jameel,

You can just add the internal name of the delivery on the same filtering criteria. I have updated the screenshot with the details again.

View solution in original post

10 Replies
Adhiyan
Employee
Employee

Hello ,

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.

dipendu_g
Level 2
Level 2

@Adhiyan Sorry for asking the question here so late, but I have a similar requirement, but if the case is that the email is set to recurring

For recurring emails we can't fix the internal name for the delivery as each time the mail is send we get a new internal name.

 

Considering this scenario how can we get to know how many are non-openers for a particular delivery

 

Regards,

Dipendu

dipendu_g
Level 2
Level 2
@Adhiyan any direction from you, will help me in understanding and resolving the similar issue, that I have
Adhiyan
Employee
Employee

Hi Dipendu, Sorry for the late reply. For recurring deliveries you can use the foreign key link : recurringDelivery-id from nms:delivery

recurring.JPG

This will stay constant for all deliveries created from a parent recurring delivery

Adobe_campaign1
Level 2
Level 2

Hello Adhiyan,

    Thank you so much for yor valuable  information i would like to  know how to query the recipients didn't open specific email from last 3 days .

 

 

Thanks & Regards

jameel.sk

Adhiyan
Correct answer by
Employee
Employee

Hello Jameel,

You can just add the internal name of the delivery on the same filtering criteria. I have updated the screenshot with the details again.

View solution in original post

Adobe_campaign1
Level 2
Level 2

Hello Adhiyan,

     Thank you so much for your valuable  information.

TechaspectSolut
Level 1
Level 1

Hello Adhiyan,

I am using ASC and I am trying to create the same flow but I didn't find any option "internal name of the delivery" in segmentation. Please suggest.

Thanks in advance

Harish

Adhiyan
Employee
Employee

Hi Harish,

You should use something like this in ACS.

1301904_pastedImage_0.png

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

1301905_pastedImage_1.png

Hope this helps

Regards,

Adhiyan