Hi,
I'm trying to find an easier way to clean up one of our mailing lists. There are many bounces on it and they need to be investigated.
I want to tag users who have been bouncing for more than a certain amount of time, for example, one year. Then I will bulk delete them from our database.
Right now, we have only two choices:
- Go to each email send and look at the engagement history of each account one by one. This is tedious and LOOOOONG!
- Select everything and delete them. This is not a good idea either because it may be due to something else (e.g. changing email addresses). And since we have very close contact with the members of our list, we can almost always reach out to them manually.
What I would like is a way to query the database with something like "Find me all the accounts that have been bouncing weekly for more than 1 year." (Hmm, that's a good idea for an AI-backed database query system…) Then I would bulk-delete those only. And the rest I could investigate manually or restrict more so I have fewer to do manually.
Is this already possible? If so, how would I go about doing that?
Thanks,
L
