SOLVED

Re: Contact Report Opened Multiple Emails

Go to solution
ccolahan
Level 1

Contact Report Opened Multiple Emails

I'm trying to create a report (e.g. smart list) identifying all the individual contacts who opened ALL of 6 emails sent. I used the below formula:

 

Capture.JPG

It seems that this smart list is actually pulling contacts who opened ANY of the 6 emails we sent. 

1 ACCEPTED SOLUTION

Accepted Solutions
Chris_Wilcox
Level 9

Re: Contact Report Opened Multiple Emails

You just need to write 6 separate filters for "opened email" and put 1 in each filter. Then make sure your filter rules is set to "All." 

 

Basically, when you add multiple options inside a smartlist filter like that, they are always used as a "OR." If you want to force it to be all, you have to add a separate filter for each occurrence.

View solution in original post

1 REPLY 1
Chris_Wilcox
Level 9

Re: Contact Report Opened Multiple Emails

You just need to write 6 separate filters for "opened email" and put 1 in each filter. Then make sure your filter rules is set to "All." 

 

Basically, when you add multiple options inside a smartlist filter like that, they are always used as a "OR." If you want to force it to be all, you have to add a separate filter for each occurrence.