Filtering on email activity older than retention period
Hi Community
I've inherited an instance that unfortunately has a large portion of the database marked as unsubscribed when they shouldn't be. Going back to 2017 there are Leads that have never received an email from us and I'm trying to differentiate these from the ones that have legitimately unsubscribed from an email.
Using the 'Not Was Sent Email', 'Not Opened Email', etc. filters the results are returning Leads that have received and unsubscribed from an email which I can see in their activity logs. I suspect they are showing in the results because of the data retention policy for email activity?
Is there a way I can accurately segment this database to identify those that have never received an email from us vs those that have unsubscribed?