What's the easiest way to get (Unique) Open Rates for a group of single email campaigns?

The issue here is that many spam filters like ProofPoint or Barracuda "clicks" on links to check them. This is then counted as an open or click and skews stats greatly.

I agree that those types of services skew data significantly and make initial reports you get from Sugar Market less valuable for measuring engagement. We've coached our customers on ways to filter out bot activity. The most common way to filter it is that all of the links in an email will be clicked within seconds of each other. As long as you have multiple links in the sent email, you can reasonably identify this behavior to weed out a good chunk of bot activity (albeit entirely manual).

This is good advice in general, but not in-line with the way I see the issue I'm having. I do plenty of other work to account for these biases, whereever they present inconsistency in bias.

My issue is that I need a unique count of opens via custom or standard reports so that I can get an open rate based on uniques. Dashboards for Single Emails in Market do this for the open rates, for example. For some reason the Campaign Summary report doesn't report an Open Rate and also only provides the Total Opens, rather than a unique count.

This is good advice in general, but not in-line with the way I see the issue I'm having. I do plenty of other work to account for these biases, whereever they present inconsistency in bias.

My issue is that I need a unique count of opens via custom or standard reports so that I can get an open rate based on uniques. Dashboards for Single Emails in Market do this for the open rates, for example. For some reason the Campaign Summary report doesn't report an Open Rate and also only provides the Total Opens, rather than a unique count.