Like others on this forum in the past, I would like to ask about cleaning up my list, which I’ve been running on phplist for about 12 years (!).
I have 100K users in my database, 70K of whom are subscribed to 2 mailing lists.
I have lots of attributes for them such as language they wish to receive the newsletter in, whether they want to be notified of new posts, which freebie they signed up to receive.
My open rates for my general monthly newsletter are not very good (~25%) and I suspect it’s because some subscribers have changed email addresses or are just no longer interested.
I would like to clean out my list by remove all subscribers who have not opened a newsletter in 2 years. This feels pretty conservative.
I don’t want to do the Invite thing. If they haven’t opened the newsletter in 2 years, they’re out. Since I offer freebies and content upgrades on my blog all the time, they can just sign up again if they’re actually engaged.
I have read that Anna has done this using spreadsheets and exclude lists, but this seems pretty fiddly, and I just want a clean simple purge. (Also, I don’t want to deal with spreadsheets of 100K rows.)
Is there currently a simple way to do this via the interface? I feel like it would make sense to have it among the “Reconcile Users” options.
Or is this something I’ll have to write a query for and run directly in the database?
Thanks so much in advance!