Answers.Body: <p>This should work. I've verified it against the Advanced Search method results... Noting the Advanced Search can be really inefficient and thus take a very long time on large mail lists so an SK approach is definitely good to have on hand.</p>
  <p><a href="https://i.sstatic.net/wVJqf.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/wVJqf.png" alt="enter image description here" /></a></p>
  <p>Ref Advanced Search approach:</p>
  <p><a href="https://i.sstatic.net/s2L6F.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/s2L6F.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-11-23T08:46:32.033Z
Answers.Text: Thanks for this, tested and works!
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-11-22T21:03:54.760Z
Answers.LastActivityDate: 2024-01-18T20:45:44.903Z
Answers.LastEditDate: 2024-01-18T20:45:44.903Z
Answers.UserDisplayName: Andy Burns
Answers.Body: <p>While Andy's solution might seem like a good one, it's important to know that this isn't really possible.  Here's an <a href="https://www.campaignmonitor.com/blog/email-marketing/the-future-of-open-rates/" rel="nofollow noreferrer">article from Campaign Monitor</a> that explains why.  The problem isn't unique to Campaign Monitor - it affects all mail tools, including CiviMail.</p>
  <p>In short - your mail tool doesn't actually know when email is opened, for privacy reasons.  What it <em>does</em> know is when remote images are loaded.  But a) many people don't load remote images (e.g. in Outlook it's the default not to). And b) to better protect privacy, in 2023 Apple changed all their products to load remote images even if the email isn't read.  GMail also has their own unique magic.</p>
  <p>So in short - you're going to get lots of false positives and false negatives, and shouldn't rely on the &quot;open rate&quot; for anything except as an aggregated value.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-01-19T16:38:12.140Z
Answers.LastActivityDate: 2024-01-19T16:38:12.140Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>On several occasions I've seen users who want to know who did <em><strong>not</strong></em> open a bulk mailing. While this can be figured out in various ways, it should be possible to produce such a report using Search Kit, which would save time.  So far, I've not succeeded.  It would help to know which table holds the mailing open counts?  Can anyone help?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-03-30T23:49:44.757Z
Comments.Text: civicrm_mailing_event_opened ?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-04-01T15:58:10.853Z
Comments.Text: Thanks, I'll let you know if I figure out a way to get a report of who did not open a mailing.  SK has this & related tables so it might be possible
Comments.UserDisplayName: Andy Clark
Tags: <civimail><searchkit>
Title: Report of who hasn't opened a mailing
ThreadText: # Report of who hasn't opened a mailing
  
  (Asked by: username_0 on 2023-03-30)
  
  On several occasions I've seen users who want to know who did ***not*** open a bulk mailing. While this can be figured out in various ways, it should be possible to produce such a report using Search Kit, which would save time. So far, I've not succeeded. It would help to know which table holds the mailing open counts? Can anyone help?
  
  **Tags:** civimail, searchkit
  
  > **Comments:**
  > **username_1**: civicrm_mailing_event_opened ?  
  > **username_0**: Thanks, I'll let you know if I figure out a way to get a report of who did not open a mailing.  SK has this & related tables so it might be possible  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2023-11-22. Score: 2
  
  This should work. I've verified it against the Advanced Search method results... Noting the Advanced Search can be really inefficient and thus take a very long time on large mail lists so an SK approach is definitely good to have on hand.
  
  [![enter image description here](https://i.sstatic.net/wVJqf.png)](https://i.sstatic.net/wVJqf.png)
  
  Ref Advanced Search approach:
  
  [![enter image description here](https://i.sstatic.net/s2L6F.png)](https://i.sstatic.net/s2L6F.png)
  
  > **Comments:**
  > **username_0**: Thanks for this, tested and works!  
  
  ---
  
  ### Answer by username_3 on 2024-01-19. Score: 0
  
  While username_0's solution might seem like a good one, it's important to know that this isn't really possible. Here's an [article from Campaign Monitor](https://www.campaignmonitor.com/blog/email-marketing/the-future-of-open-rates/) that explains why. The problem isn't unique to Campaign Monitor - it affects all mail tools, including CiviMail.
  
  In short - your mail tool doesn't actually know when email is opened, for privacy reasons. What it *does* know is when remote images are loaded. But a) many people don't load remote images (e.g. in Outlook it's the default not to). And b) to better protect privacy, in 2023 Apple changed all their products to load remote images even if the email isn't read. GMail also has their own unique magic.
  
  So in short - you're going to get lots of false positives and false negatives, and shouldn't rely on the "open rate" for anything except as an aggregated value.
  
  
  ---
  
  