-
Notifications
You must be signed in to change notification settings - Fork 1.4k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Send campaign to segment of list #250
Comments
Thanks @nickwynja. The problem with creating a sub list based on a query is that the results can include subscribers from multiple lists, in which case, it would not be possible to have a single parent list. |
I see. I think this could be managed by the segment being a sub-query just like is happening on `/subscribers/lists/<id>` page now. When you query on that page, it appears to only be querying against the list. Here I can search for names or attributes and results are only showing members of the current list.
… Thanks @nickwynja.
The problem with creating a sub list based on a query is that the results can include subscribers from multiple lists, in which case, it would not possible to have a single parent list.
|
Closing this as there's a longer discussion on the same matter here #250. |
@knadh In your comment, you referred to this (self) issue. Did you mean to refer to a different ticket or did you mean to comment and close a different ticket? |
Please re-open this issue (or link to whatever issue is actually tracking this). It is still a needed feature and the linked discussion issue is ... self referential. |
@nickwynja @alerque looks like I've lost track of the issue I really meant to reference, and now I'm unable to find it either. Re-opening this. |
Would it be possible to do something here to filter the list based on a query/segment Lines 635 to 637 in 3386de4
WHERE subscriber_lists.status != 'unsubscribed' AND
## Either grab a query saves in a segments table or get camps.query directly
## Not sure if it's possible to convert the string into a real WHERE condition though
(SELECT query from segments WHERE id = camps.segment) AND
id > (SELECT last_subscriber_id FROM camps) AND
id <= (SELECT max_subscriber_id FROM camps) Option would either be to store a new field This would allow us to create separate campaigns for different regions (based on a subscriber attributes) but using a global list. |
Yep, this is along the lines of the earlier discussions on using sub queries. Campaigns could have a |
I really hope segmentation will be added to Listmonk soon! |
Any eta on list segments? |
Our use case is the following: Our subscribers receive emails containing events based on their preferences by subscribing to a list. We have a job that runs everyday and populates each subscriber's "attribs" field with a list relevant events, but some days some subscribers may not have any events. Once the "attribs" field has been populated for all users , we create and start a new campaign. The problem we have is that we don't want subscribers to receive an email for a particular day if they don't have any events in their "attribs" property, and right now they are getting an email with no events. I believe having a "query" property for each campaign will help with something like this. Right? Do you have any other ideas as to how to implement this using listmonk? |
Any update here? Did you make some progress that could be engaged to contribute on code? It's a must and I suspect that could be a major change on Listmonk scalating steps :) |
Hi @satoshinotdead. Haven't started working on this yet. |
There is a query as workaround to export and import while it's developed? My skills are limited but I like to try and learn. And I chose to use open-source, all the way (moved from Mailerlite here). |
|
Thanks! I have readed before reply because it seems that specific query is not there. Please, can you give an example about how can we check open or clicks for Big kudos for Listmonk. |
I've seen this suggestion a few times now. What about managing a list of SQL snippets/filter? So you would define a filter once, eg. select all subscribers which do / do-not have a custom attribute "telephone". And, in a campaign, you can optionally select a single filter which is then applied before send. I am not sure if this will make implementing easier, but the snippets could be re-used throught the UI. |
Hi @knadh i think the difficult is that POST /api/subscribers/lists send the list of the ids of the subscribers returned by the query... as intro what do you think if we add the compoment of list seleccion and new button "dinamic list" (after test the query) This could be an easy iteration to add "dinamic list" without much overhead... to later consideration:
For future we can improve:
But, for the first step i think could be easy. What do you think... open a PR? :) |
Hi @josejuanmontiel. This indeed warrants a discussion, but it wouldn't be feasible until the next release, which has massive changes (multi-user support). We can pick up this discussion after the v4.0.0 release in a couple of months. |
This issue has been marked 'stale' after 90 days of inactivity. If there is no further activity, it will be closed in 7 days. |
This is still a desired feature, loose the bot. |
So that we're on the same page, this is about creating a campaign and specifying a SQL statement to filter the list the campaigns will be applied to further by their attributes? |
Hi!
If you ask to me... i don't understand what you said, sorry... my approach, as describe before, will be use the same query that actually return all the user that match (the query) ... to use it exactly before the campaign will launch, in this way it will be "dynamic"... later, could be interesting allow joins with other tables that could be generate in the system by other method for example like dungbeetle project. |
This feature would allow using queries to send to a segment of a list. This is a pretty standard approach in email service providers. This is somewhat related to #129. The problem I see with creating dynamic "query lists" is that when someone wants to unsubscribe, they might only be unsubscribed from that list and not the "master" list.
To avoid this, I'd like to send a campaign to a segment. For example, I'll add a customer to the master list when they register and include a custom attribute with the subscribe date. Then I could send a campaign to a sub-segment who have registered in, for example, the last 30 days based on a SQL query. The campaign send would still be considered a part of the master list so that an unsubscribe would be unsubscribed from the master list.
Thanks for making listmonk! I've been looking for something like it for a long time.
The text was updated successfully, but these errors were encountered: