I'm looking at PHPList and wondering how I can use it to send geo-specific newsletters to my users?
These are just tests, but I have a database with 1 million geo-tagged locations. I also have 1-million test users, each with different addresses! The idea is to combine users into groups based on their zip-code, and then calculate all geo-tagged entries with, say, 100 miles of that zip code - then somehow configure PHPList to send a unique newsletter to each zip-code group.
I'm worried about scale and I've never approached a challenge like this - so does anyone have any wisdom about how best to do this? Perhaps something better than PHPList?
Just to close out this question, the best way to do this, in the end, was to skip using PHPList and write a custom controller instead.
It was a lot of work, but using PHPList for this was too awkward and also a lot of work, so it's better to write a custom code + controllers.