How can I find individuals who have had certain interesting moments and no others?

[Jonathan_Ng2]

Hi There,

Trying to find individuals in the database that have only had Opens Email Interesting Moments and no other Interesting Moments.  Is that possible?  I'm using a combination of Had Interesting Moment and Not Had Interesting Moments and the logic is having me running in circles.

Thanks!

Jonathan

[Elliott_Lowe1]

If you want to include leads that have only Opens Email Interesting Moments and no others you would use the following filters.

• Had Interesting Moment
  • Type is 'Email'
  • Description contains 'Opens Email'

• Not Had Interesting Moment
  • Type is 'Email'
  • Description not contains 'Opens Email'

• Not Had Interesting Moment
  • Type is 'Web'; 'Milestone'

[Jonathan_Ng2]

Thanks that did the trick!  How does the second bullet work?  Doesn't that contradict the first Had Interesting Moment?

[Elliott_Lowe1]

The Not Had Interesting Moment uses 'not contains' as the operator, which translates to don't select any leads that had an Interesting Moment whose Type is email and the Description contains something other than 'Opens Email'