I would like to have the unsubscribes in there and marked to avoid them ending back on the list due to another import. The client uses spreadsheets for a lot so things get a bit tricky
Hey, sorry but there's only 'Mass delete' function and no 'Mass unsubscribe' function. You may want to try marking the unsubscribers manually. Is your unsubscriber list huge?
UPDATE. There was about 900 with the cleaned list For anyone else interested. I ended up importing in three steps. I exported my mailchimp list in the three parts subscribed, unsubscribed and cleaned. I then... 1. Import unsubscribes 2. Update subscribers SET unsubscribed = '1' WHERE unsubscribed = '0'; 3. Import cleaned 4. Update subscribers SET bounced = '1' WHERE unsubscribed = '0'; 5. Import members list
Comments
There was about 900 with the cleaned list
For anyone else interested. I ended up importing in three steps. I exported my mailchimp list in the three parts subscribed, unsubscribed and cleaned. I then...
1. Import unsubscribes
2. Update subscribers SET unsubscribed = '1' WHERE unsubscribed = '0';
3. Import cleaned
4. Update subscribers SET bounced = '1' WHERE unsubscribed = '0';
5. Import members list