Is this a good way to see how many leads have not opened an email between 6 and 12 months? Something's not right about this Smart List.

Hi @julian_grecu1 

To filter who have NOT opened between 6 and 12 months, I would suggest:

1) Create a smart list with filter to see who opened in last 6 months

2) Create another smart list to see NOT opened in last 12 months and exclude Smartlist 1(who opened in last 6 months), so that it shows only between 6 to 12 months

Hope this helps. Also I find below link useful in understanding date field operators:

https://experienceleague.adobe.com/docs/marketo/using/product-docs/core-marketo-concepts/smart-lists-and-static-lists/creating-a-smart-list/smart-list-filter-operators-glossary.html?lang=en

Regards,

Serene

What's missing in your screenshot is what your smart list logic is, is it set to ALL, ANY or Advanced? If it is the Default ALL, this will give you all people who opened an email between 6 and 12 months ago, but not in the past 6 months. From the title of this thread I am assuming you are looking for the opposite, right?

If this is something you would like to monitor on a structural basis, I would suggest to create a date field that you stamp with the current date and time everytime the person opens an email.