It looks like you're new here. If you want to get involved, click one of these buttons!
I posted in another thread on my early concept on creating filtered lists based on your custom fields. I got a bit ahead of myself and ended up completing most of it over the weekend. I'm posting here to see how much interest there would be for this feature and hopefully convince the Sendy folk to implement something like this :)
The basic concept is to use an existing list to generate a new list based on filters you specify on each of the custom fields.
I am sure there is a much more efficient way to handle this but I only had a weekend to come up with a solution but maybe this solution would be ideal for many people. I would love to see something like this in the official release, my code is almost done (just some clean up needed) and I will make this available to whoever wants to use it, as long as that is allowed of course.
yes, yes, yes, yes, yes...
Is this only idea that you would like to have in sendy or you have custom code / sendy that can do this kond of filtering?
This is fully working code, I'm still actively working on it but fully functional in its current state.
This means it probably would be ideal to share it as an entire package, instead of just sharing a single pages source code. I am not sure what the rules are regarding the Sendy source code and how it may be distributed and I'm pretty sure I can't just share it all willy-nilly.
Maybe Ben can clarify what the rules are regarding this.
Another issue is that this is not a solution for everybody and is not recommended for anybody with a huge subscriber database just due to the way the custom fields are stored in the database. This is my next goal, I am trying to figure out how to optimise this so filtering becomes almost instantaneous - this will most likely require quite a big change to the database.
Hmmm... you are right.
Ben is quite for some time (I'm wondering if he is working on version 2.0 of sendy) and he should give final thought about it :)
I'm in. This is exactly what I am looking for in Sendy. The ability to do list segmentation to avoid multiple lists is a must have in my books.
Would be great to see this as native in Sendy or as a package.
Will await to hear back on next steps and timing.
Hi @DrJohnZoidberg. Thanks for sharing this. You can share your build with fellow users via PM if they want it.
Please note that should filtered list come to Sendy, it'll only be developed on my side to prevent issues arising in future that I have no clue about. Thanks once again.
I've just run some initial tests on a new database design for the custom fields to improve performance when searching. So far it looks very promising :)
For a filter that would have probably taken 20 seconds via the old method, this is a direct MySQL query I ran now:
Query took 0.0886 sec
If anybody in interested in the source code, please pm me. Although note that I am working on improving the filtering speeds as I have noted before, so if you have 300k subscribers+ I would recommend you wait until I have hopefully completed the new code.
Updated the filter screen so I have more control over soft bounce and complaints limits when generating new filtered lists. I had previously just hard coded values, they are now selectable.
https://dl.dropboxusercontent.com/u/14569277/Screenshot 2013-11-28 23.29.22.png
Filtered lists will never include hard bounce or unsubscribed emails.