Creating A List With Mailchimp

24 September 2009



In this video we’re going to run through mailchimp.com, which is the email service we recommend.  They’ve got a free option here, which you’ll see you can have up to five hundred subscribers and you can send emails up to 3,000 times a month, so 6 each.  If we go to here where it says try it for free, you can sign up online straightaway.

Just filling out the account details.  Just to run through some of the features, and why we like mailchimp so much, basically it tracks all the clicks and the open rates of the emails you send to your customers or visitors.  And then there’s loads of stats that you can take a look at.  You can see whereabouts in the world people actually opened your emails.  And various other stats.  Also it gives you the ability to create some fantastic looking emails in HTML without having a lot of experience.

Also you can create subscribe forms straightaway without needing to be some coding expert.  So we highly recommend it.  We’ve gone ahead and signed up for a free account. And I’ll just log in there, and I’ll tell you how you can create your first list.

So the first thing you’ll see when you get your account is this screen here.  You’ve got this button that says create a list.  There’s a video there on the right.  And a video to help you with each of these different things.  If we create a list here, we call the list Net Sales Demo Customers.  And then the default from name would be your store name usually. And then whichever email address you want to use.

Just put in a default subject, which you’ll probably end up changing each time you send an email.  And then put in a line here that reminds people of how they actually got onto your list so that they don’t report it as spam.

Then the next thing you need to is just choose whether or not you want to be notified when people subscribe to your list or unsubscribe.  And there’s another box here that allows you to let your customers choose whether they want it in HTML or plain-text.  So once you’ve done that, just click save.  And then that’s it.  You now have an email list setup.  We’ve set this up for customers of the store rather than for people who just fill in the name and email on the front of the site to opt in.

So once you’ve got your list, you need to import your customers from Magento. And you can do that by just clicking the main button there.  And if we go to this section here, where it says upload file, the first thing we need to do is just go over to Magento and we go to customers and then manage customers, which gives you this screen here.  Select all your customers, and export.

That’ll just take a second.  You can save the file.  And that should only take literally a second.  So once you’re over here, you can just go to browse, find the file.  Which’ll be customers.csv.  And then click import list.

So straightaway, you can see that you’ve got the different columns that are in your customer’s csv.  You won’t need to import all of them.  So you just need to allocate which of these columns is for what.  So the first one you’re not going to need.  That’s the customer ID.  The second one you’ll see, that’s their name.  So yes that should be the first name.  And the second one, email address.  We won’t need this one or this one or their post code or where they’re from.  So we can just delete all of these.

And then that’s it.  Just click all done.  And now all of those people are just being imported.  You can see at the top right, we’ve got naught rows completed.  So it’s giving you information as to how the emails are going in okay.

And that’s how we import all of our customers from Magento into Mailchimp.  And in the next video, we’re going to run through how you create a nice looking email and then send an email to all of the people.

Useful Links

- MailChimp

Comments are closed.