Views
List Cleaner
Upload Files
Upload files with detailed subscriber information in a correctly formatted Comma-Separated Values
text document or spreadsheet.
List 1 – Adds Subscribers
The detailed subscriber data in this file is important. This subscriber data will appear in the cleaned file.
List 2 – Removes Subscribers
The only column that is read is the "email" column. The subscriber data in this file is ignored.
Each email address in the "email" column in List 2 is compared against the "email" column in List 1. If a match is found, the row (subscriber) in List 1 is removed.
Process
This button uploads List 1 and List 2 to our servers and returns a CSV file named "cleaned_list.csv" for you to save or open.
Upload a CSV file to Add, Update or Clean Subscribers?
To upload a file with detailed information, the file must be saved as either .txt or .csv format.
- Add Subscribers – if you want existing subscribers to be ignored and only new subscribers are added. For example, if you are uploading an older list, you may not want to overwrite more recent contact information.
- Update Subscribers – if you want existing subscribers to be changed and new subscribers ignored. If you have previously uploaded a file with errors, you can correct the file and use Upload Subscribers to make corrections.
- Update Subscribers + Add Subscribers – if you want existing subscribers to be changed and new subscribers added, upload the same file using both Update Subscribers and Add Subscribers.
- List Cleaner – if you want to remove subscribers from one file using a second file.
What is CSV?
It’s an abbreviation for Comma Separate Values, a text format in which each block of information, or field, is separated by a comma. Documents with this format are usually saved with a .csv file extention. Each new record – in our case, each new subscriber – is listed on a separate line ending with a carraige return. Fields containing commas or carriage returns must be surrounded by straight double quotemarks. For example, hello, example becomes "hello, example" so that hello and example are put into the same field. Straight double quotes that are part of the subscriber information must be doubled to distinguish from straight double quotes indicating the beginning or end of a field. For example, William "Bill" Clinton becomes "William ""Bill"" Clinton".
Setting up your CSV file
The best and easiest place to edit your upload file is in a spreadsheet program such as Microsoft Excel or Google Spreadsheets, where the file formatting is handled transparently, so you don’t have to worry about extra commas or straight double quotes. You’ll see each subscriber on a single row with each subscriber field in its own column. Just remember to Save or Export your edited spreadsheet document in .csv format.
Requirements
- Each column must have a label in the first row (first line) of the file.
- One column must be labeled "email".
- Every subscriber must have an email address in the "email" column.
- Subscribers without email addresses in the "email" column will be ignored.
- Column labels must be all lowercase.
- Column labels may be any or all of the following: email, first_name, middle_name, last_name, company_name, job_title, phone_work, phone_home, address_1, address_2, address_3, city, state, zip, country, custom_1, custom_2, custom_3, custom_4, custom_5, custom_6, custom_7, custom_8, custom_9, and custom_10.
- Click here to Download a CSV template file to use with the Upload Detailed feature.
With detailed subscriber information, you can create professional email marketing solutions using personalized content based on subscriber data.
Using Detailed Subscriber Data
You can retrieve and email-merge Detailed Subscriber Data into your email content using Subscriber Tokens.
Click this button in the Content Editor toolbar to insert Tokens using a convenient drop-down menu.
Subscriber Tokens
See My Subscribers > Categories – to search, edit, manage, upload, and download Subscriber data.
See My Account > Settings > Subscription Preferences – to allow subscribers to manage their own data.
- #subscriber_id#
- #email#
- #first_name#
- #middle_name#
- #last_name#
- #full_name#
- #address_1#
- #address_2#
- #address_3#
- #city#
- #state#
- #zip#
- #country#
- #company_name#
- #job_title#
- #phone_work#
- #phone_home#
- #custom_1#
- #custom_2#
- #custom_3#
- #custom_4#
- #custom_5#
- #custom_6#
- #custom_7#
- #custom_8#
- #custom_9#
- #custom_10#