In this Guide: Email Campaigns - Exporting Customers
Summary
For online businesses in need of a more powerful newsletter campaign software solution, MonsterCommerce is proud to provide partnerships and integrations with popular newsletter software companies. With this new initiative, the MC software now offers the ability to export your customer's first name, last name, and email address into the standard format accepted across the industry.
Export Subscription Email List
Select this option, found within your Customers >> Export Subscription Email List. You will see a dropdown menu containing the following options:
- Generate all Registered Customers
- Generate all Registered Customers Signed up for Newsletter
- Generate all Guest Customers
- Generate all Guests Signed up for Newsletter
- Generate all Non-Customers Signed up for Newsletter
Export Options Defined
- Generate all Registered Customers
- Creates a list of all the visitors to your site who have gone through the checkout process and created an account with your store, thus adding all of their customer information to your database
- Generate all Registered Customers Signed up for Newsletter
- Creates a list of all the visitors to your site who have gone through the checkout process, created an account with your store, AND signed up for the newsletter through the frontend mail form or the “add me to the newsletter” checkbox within the checkout process
- Generate all Guest Customers
- Creates a list of all your the visitors to your site who have gone through the checkout process who have not created an account, the only information avaialble will be the email address on file
- Generate all Guest Customers Signed up for Newsletter
- Creates a list of all the visitors to your site who have gone through the checkout process who have not created an accout, YET have signed up for the newsletter through the frontend mail form or the “add me to the newsletter” checkbox within the checkout process
- Generate all Non-Customers Signed up for Newsletter
- Creates a list of all your visitors who have only signed up for your newsletter through the frontend mail form
Creating the Export
- Select export option
- Click “Create File”
The page will automatically refresh with a new text link...
Downloading the Customer Information
Now that you have created your file, simply click on the new link entitled “Download File”.
Saving the Customer Information File
You will be prompted with a dialogue box similar to the one below. Click “Save” and browse to the directory on your hard drive wherein you want the file located and hit “OK”.
Note: The file generated is a CSV file. It may prompt a warning (as seen above). Please disregard - there is nothing within this file that will harm your computer.
File Name and Type
File Name and Save as type can be left the same.
File Format Defined
Your file is in CSV format. This is the most efficient format for exporting and importing a large volume of data. It can be easily manipulated using programs such as MicroSoft Excel.
Upload Compatibility Tips
The only area that may require modification is the very top line of your new file. The MC software titles, or labels, the three columns by First Name, Last Name, and Email Address. Each newsletter software company has their own column labels used to identify data being uploaded.
To change this information, in correspondence to your selected Newsletter Software, simply highlight the text and type the appropriate format.
Popular Newsletter Software Labels:
- IntelliContact
- First Name: [fname]
- Last Name: [lname]
- Email: [email]
- GotMarketing
- First Name: FirstName
- Last Name: LastName
- Email: Email