Excluding non engaged subscribers from email delivery | Community
Skip to main content
E
elisag19795522
Level 2
November 21, 2019
Solved

Excluding non engaged subscribers from email delivery

  • November 21, 2019
  • 6 replies
  • 4229 views

Hello,

I want to send a delivery excluding everyone who has not opened an email in the last 180 days. When adding into a query the delivery, it only allows me to select deliveries one by one, I cannot select all, nor I can select a date range.

What is the easiest way to achieve this?

Thanks,

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by elisag19795522

    I've tried this and it looks like it worked:

    6 replies

    SatheeskannaK
    Community Advisor
    SatheeskannaKCommunity Advisor
    Community Advisor
    November 21, 2019

    Hi,

    Can you try like this,

    Thanks!

    Thanks, Sathees
      E
      elisag19795522Author
      Level 2
      November 21, 2019

      Hi,

      When doing that, I get the following errors:

      21/11/2019 16:37:44

      query1

      WDB-200001 SQL statement 'INSERT INTO wkf61230670_1_1 (iId) SELECT DISTINCT N0.iRecipientId FROM NmsRecipient N0 WHERE ( EXISTS (SELECT 1 FROM NmsBroadLogAppSubRcp N1 WHERE (N1.iProfileId = N0.iRecipientId) AND ((((N1.iStatus = 1) AND (N1.tsEvent >= DaysAgo(180) AND N1.tsEvent < GetDate())) AND ))) OR EXISTS (SELECT 1 FROM NmsBroadLogRcp N1 WHERE (N1.iProfileId = N0.iRecipientId) AND ((((N1.iStatus = 1) AND (N1.tsEvent >= DaysAgo(180) AND N1.tsEvent < GetDate())) AND ))) ) AND ((N0.iRecipientId > 0 OR N0.iRecipientId < 0))' could not be executed.

      21/11/2019 16:37:44

      query1

      PGS-220000 PostgreSQL error: ERROR: syntax error at or near ")" LINE 1: ... >= DaysAgo(180) AND N1.tsEvent < GetDate())) AND ))) OR EXI... ^

      SatheeskannaK
      Community Advisor
      SatheeskannaKCommunity Advisor
      Community Advisor
      November 21, 2019

      I just did it again and got the 3results. When i did query against delivery logs status sent and event date corresponds to last 180days gave me 10 results and after adding tracking logs doesn't exists condition brought down the count to 3. Verified the profiles and they didn't open any emails received. Also hope you have set the target and filtering dimension as profile.

      You may try adjust the event date from 180days to something else and see how that works.

      Thanks!

      Thanks, Sathees
        E
        elisag19795522Author
        Level 2
        November 22, 2019

        I tried again narrowing the query, like below:

        And still got the following error:

        Do you know what the error means?

        Thanks

        SatheeskannaK
        Community Advisor
        SatheeskannaKCommunity Advisor
        Community Advisor
        November 22, 2019

        Do you have any deliveries that are in sent state between the dates you choosen? and If you have any delivery then try to choose one specific delivery (change the criteria from event date to delivery label) and see whether you're getting some count without any error. Just to see if that works.

        Thanks, Sathees
          E
          elisag19795522AuthorAccepted solution
          Level 2
          November 27, 2019

          I've tried this and it looks like it worked:

            Terms & ConditionsAccessibility statement

            Loading footer...