This isn’t a problem with phpList per se, but a problem with my strategy using it. I didn’t see a more relevant category than Support. This is sort of long and involved/detailed so I will thank in advance any who take the time to read and respond!
I’m a writer and I have two public lists that I maintain for my main pen name (i.e., my real name). One is a general newsletter that I send whenever I want (but usually only once or twice a month, just not on any kind of schedule). The other is a new-releases-only list. Both of these lists are open to anyone to subscribe.
In addition to the public lists, I use one-time private lists to follow up with people who have downloaded a free book. The way this works is that I offer a book for free using BookFunnel and people who download a copy can opt-in at that time to my general newsletter list. This is usually done during date-limited promotions (“bundles”) with other books from other writers. At the end of the promotion, I download a CSV file from BookFunnel that lists everyone who requested a book copy and opted-in to my list. I import that CSV into phpList and send a one-time message to thank people for downloading the book, ask for a review, and prompt them regarding their subscription on my newsletter.
When I first did this, I only imported the CSV into a private list and, in that one-time mail to that list, I provided a link to go and subscribe to my general newsletter or new-releases-only list. Not many did, but those who did were clearly very engaged and good people to have on my list. But this is asking people who have already opted in and confirmed their opt-in to opt-in again… not a very good experience for them and a way for me to throw away a lot of subscribers.
The most recent time I did this, I made a mess of things that I definitely don’t want to repeat. I imported the CSV into a private list for a one-time followup, like before, but I also imported those addresses to my general newsletter list with the plan to prompt people to unsubscribe if they didn’t actually want to be on the list. (Originally I thought to use the Segmentation plugin as part of this, but ended up not doing so.) As usual with these imports, some people were already in my database, either on one of my two public lists or already blacklisted. (Some people apparently grab any free book they can from BookFunnel bundles even if it means “opting in” to lists they’ve already opted out of.) I only wanted to send the “thanks, and you can unsub” follow-up to people who weren’t already on one of my public lists, but that’s where things got really messy, and I ended up using PhpMyAdmin and other things to try to eliminate prior subscribers from the new private one-time list. Bleah…
Taking the first opt-in as authoritative instead of asking people to opt in again resulted in a much larger increase in my subscribers, of course. I want to continue with that overall approach, but with better data handling, and (of course) whatever I do data-wise I want to minimize or eliminate annoyance to my subscribers.
My tentative plan for the next time is still messy but probably more reliable and less work (I think):
- Import the CSV to a private one-time list only. This list would be temporary and not used for a campaign.
- Use SQL in PhpMyAdmin to identify people who are on that new list as well as either of my public lists.
- Eliminate those existing subscribers from the CSV file. For those who remain, add a column to populate the preferred-genre attribute, based on the book they downloaded.
- Delete the temporary one-time list from phpList.
- Import the edited CSV to a private one-time list and my general newsletter list.
- Send a “thanks, and you can unsub if you want” follow-up to the newly-imported private list.
All of that screams “there must be a better way.” I could presumably change step 1 to import the CSV to a temporary table via PhpMyAdmin which would avoid other effects in phpList, so maybe I’ll do that.
But it’s still not a very clean process, so I figured I would throw this out to the phpList community for input. Maybe I was right in my original inclination to use the Segmentation plugin? Part of the problem is that preferred-genre attribute. If an existing subscriber has that set (whether I set it or they did), I don’t want to overwrite the old data, but a new subscriber should have it set based on the genre of the book they downloaded.
If you managed to read this far, thanks! (And if you want a free book, just ask, ha ha…)