search

knadh / listmonk

High performance, self-hosted, newsletter and mailing list manager with a modern dashboard. Single binary app.
https://listmonk.app
GNU Affero General Public License v3.0
14.46k stars 1.32k forks source link

Resend campaign to unopens #1337

Open elronalds opened 1 year ago

elronalds commented 1 year ago

It doesn't appear to be possible to re-send a campaign to unopens. It was discussed within #1107 regarding pruning these subscribers that haven't opened in x days. When using other mailing list software we have been able to re-send to those that haven't opened the email and this would improve engagment for those.

It might useful to have an option to re-send the campaign to such subscribers.

MaximilianKohler commented 1 year ago

This is definitely a very useful feature if it could be implemented. Important to note that the accuracy would be quite limited due to inaccurate open tracking #1025,

benstaf commented 2 months ago

I would like to send campaign to opens, can subscribers be segmented in this way?

MaximilianKohler commented 2 months ago

Yes: https://github.com/knadh/listmonk/issues/1458#issuecomment-2034720098

1000i100 commented 2 months ago

This query catch unopened, isn't it ?

NOT EXISTS(
  SELECT 1 FROM campaign_views
  WHERE campaign_views.subscriber_id=subscribers.id
  AND campaign_views.campaign_id={put_id_of_campaign}
)

Inspired by : https://github.com/knadh/listmonk/issues/1458#issuecomment-2034720098