How do I clean up subscriber list?

Hi,

I need help!

Because of a form error, we have about 400+ subscribers with the name field as zero ("0").

We want to make the name field blank - what is the best way to do this?

Right now, I'm doing it manually, one by one.

Cheers.

roshodgekiss roshodgekiss, 4 years ago

Hi Spitfire, welcome to the forums! Your best bet is to export the list as a .CSV file, wipe all the names in Excel (or similar), then re-import the list into the app. Names should be then overwritten. Let us know how you go :)


Get in touch with us on Twitter: http://twitter.com/campaignmonitor
We're also on Facebook: http://facebook.com/campaignmonitor
spitfire, 4 years ago

Hi, I'm currently working with one of your team, Tash Sallie.


We've done as you described, but it didn't work. (Exported as CSV, edited in excel, imported back as CSV.) I think your import tool does not overwrite the db field if the source field is blank.

roshodgekiss roshodgekiss, 4 years ago

Hi there, I'm so sorry for giving you a bum steer there - spaces work, but not blanks. It looks like Paul and Tash over here have sorted out the zeros issue, but let us know if there's anything else we can help out with on our end. Sorry again for being a dunce!


Get in touch with us on Twitter: http://twitter.com/campaignmonitor
We're also on Facebook: http://facebook.com/campaignmonitor

Join 200,000 companies around the world that use Campaign Monitor to run email marketing campaigns that deliver results for their business.

Get started for free
1-888-533-8098