Support Center/Your Mailing List - Fans Tab/Managing your email list

Import Your Existing Mailing List

Topspin Artist Support
posted this on December 06, 2011 02:32 pm

Make sure fans have double-opted in to your list

Before uploading an existing list to your Topspin account, ensure that all names on that list have double opted-in. This means that fans clicked a link to confirm via email after signing up for your mailing list. It is very important to make sure that the fans on your list are real people, as messages sent to spam traps or non-legal addresses will jeopardize your account. If in doubt, you can create a new E4M to have your existing fans legally re-join your mailing list through Topspin. Real fans are more valuable than bots anyway.


Download our CSV Import Template to format your upload

1.jpg

1) In your Fans tab, click the blue Import Fans button at the top-right.

 

2.jpg

2) Click the Import via CSV button to get to the CSV upload page.

 

3.jpg 3) Download the Topspin CSV Template

 

Paste your list into the CSV while keeping the provided header

A CSV (Comma Separated Value Document) is a spreadsheet format supported by most email software applications. You will be able to open and edit the document in a standard spreadsheet editor such as Excel or Numbers. Once you have documented this template, open it and paste your email addresses into the correct column. Make sure not to alter the header row (Row 1) in the downloadable template, as this will prevent a proper import. Save your new document as a .csv as this is the format that must be uploaded to your Fans tab.

 

4.jpg

 

 

Importing existing geographic information


If your current mailing list contains geographic data for individual fans, you can also import this data into Topspin along with your fans' email addresses.

1. The "Geo" columns in the Topspin CSV template are 'export-only' columns (they aren't used for importing info, just exporting it)

2. To associate your fan email addresses with specific cities and countries, apply your city/province/country data to either "Billing" or "Shipping" columns: (Billing City, Billing State/Province, Billing Country) and/or (Shipping City, Shipping State/Province, Shipping Country)

3. Remember to use proper ISO codes for "Country" info. For instance, when you enter country information, don't type 'United States'. Make sure you use the standard, two-digit ISO code for the country. In the case of the United States, this would be "US". A comprehensive list of official ISO codes can be found in the 'Import Fans'>'Import via CSV' section of your fans tab.

Screen_Shot_2011-12-12_at_1.24.00_PM.png

4. About 24 hours after your import, you should be able to search and filter by geographic location in your Fans tab.

 
Topic is closed for comments