How to query the DIDN’T OPEN emails from last 3 days in adobe campaign management. | Community
Skip to main content
Adobe_campaign1
Adobe_campaign1
Level 2
May 9, 2017 10:25 AM UTC
Solved

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

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Adhiyan
    AdhiyanAccepted solution
    Employee
    May 9, 2017 11:23 AM UTC

    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 reply

    10 replies

    Adhiyan
    Adhiyan
    Employee
    Sep 19, 2017 11:53 AM UTC

    Hi Harish,

    You should use something like this in ACS.

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

    Hope this helps

    Regards,

    Adhiyan

    Translate
    TechaspectSolut
    New Participant
    Sep 19, 2017 11:35 AM UTC

    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

    Translate
    Adobe_campaign1
    Adobe_campaign1Author
    Level 2
    May 9, 2017 11:29 AM UTC

    Hello Adhiyan,

         Thank you so much for your valuable  information.

    Translate
    Adhiyan
    AdhiyanAccepted solution
    Employee
    May 9, 2017 11:23 AM UTC

    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.

    Translate
      Adobe_campaign1
      Adobe_campaign1Author
      Level 2
      May 9, 2017 11:05 AM UTC

      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

      Translate
      Adhiyan
      Adhiyan
      Employee
      May 9, 2017 10:43 AM UTC

      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.

      Translate
      dipendu_g
      Level 5
      Apr 2, 2020 7:25 AM UTC

      @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

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...