MaximilianKohler
commented
2 months ago The idea is to keep pruning lists by removing subscribers that have not opened emails for last x days (say 60 days).
Open-rate tracking in listmonk is not accurate https://github.com/knadh/listmonk/issues/1025. Open-rate tracking in general is not reliable as it depends if people choose to "load external images".
I searched for a way to query subscribers using the SQL expressions but could not.
https://gist.github.com/MaximilianKohler/e5158fcfe6de80a9069926a67afcae11#postgresql
knadh
We have been using Listmonk for some months and is working well for us! Thank you for the product!
Is your feature request related to a problem? Please describe. We are looking to remove inactive subscribers from our lists. The idea is to keep pruning lists by removing subscribers that have not opened emails for last x days (say 60 days). This helps in maintaining a reasonable open rate.
I searched for a way to query subscribers using the SQL expressions but could not.
Describe the solution you'd like Would you be able to explain how to query for subscribers who have not opened any email for last x days?
Or Please add this as an option under the maintenance section. It can have a simple option "Last opened since" and the option to mark as unsubscribe. This is a pretty standard feature of most of the newsletter tools.
Thank you!