0

I have an SQL query in order to retrieve users who have not opened a specific email (with jobid), but i can not exclude Bounces. Do you have any ideas?

enter image description here

1
  • 2
    Please post the query as text, not as a screenshot and include information about exact errors/problems you have with the existing query
    – zuzannamj
    Commented Jan 25, 2023 at 15:58

1 Answer 1

1

The following query retrieves information about subscribers who have opened a specific email, as identified by the JobID, and who have not bounced:

SELECT
    SubscriberKey,
    EmailAddress
FROM
    _Subscribers
WHERE
    SubscriberKey NOT IN (
        SELECT
            SubscriberKey
        FROM
            _Open
        WHERE
            JobID = 'specific_email_job_id'
    )
    AND SubscriberKey NOT IN (
        SELECT
            SubscriberKey
        FROM
            _Bounce
        WHERE
            JobID = 'specific_email_job_id'
    )
2
  • Thnank you! However, i want subscribers who have NOT opened a specific email and who have not bounced Commented Jan 26, 2023 at 10:38
  • Woops, I missed that part. I've updated my answer to only include subscribers that did not open a specific email and did not bounce. Commented Feb 1, 2023 at 8:42

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .