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

Avatar

Avatar

Adobe_campaign1

Avatar

Adobe_campaign1

Adobe_campaign1

09-05-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Adhiyan

Employee

Avatar

Adhiyan

Employee

Adhiyan
Employee

09-05-2017

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.

Answers (5)

Answers (5)

Avatar

Avatar

Adhiyan

Employee

Avatar

Adhiyan

Employee

Adhiyan
Employee

19-09-2017

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

Avatar

Avatar

TechaspectSolut

Avatar

TechaspectSolut

TechaspectSolut

19-09-2017

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

Avatar

Avatar

Adobe_campaign1

Avatar

Adobe_campaign1

Adobe_campaign1

09-05-2017

Hello Adhiyan,

     Thank you so much for your valuable  information.

Avatar

Avatar

Adobe_campaign1

Avatar

Adobe_campaign1

Adobe_campaign1

09-05-2017

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

Avatar

Avatar

Adhiyan

Employee

Avatar

Adhiyan

Employee

Adhiyan
Employee

09-05-2017

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.