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

[#1]

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

[dipendu_g]

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.

trackinglog.JPG ‏121 KB

[dipendu_g]

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

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

[Adhiyan]

Hi Dipendu,

[Adhiyan]

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

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