How to Export Subscribers to Mailchimp

Exporting your eType Services subscriber list to Mailchimp allows you to leverage your existing digital subscriber base for email marketing campaigns. This process creates a clean data export that can be imported directly into your Mailchimp audience for newsletters and promotional campaigns.

Use this feature when you want to expand your marketing reach beyond your e-Edition platform, create targeted email campaigns, or manage subscriber communications through Mailchimp's advanced email marketing tools.

Prerequisites:

• Active eType Services account with subscriber data

• Mailchimp account (free or paid)

• Microsoft Excel or compatible spreadsheet software

• Administrative access to your eType Services subscriber reports

What You'll Need:

• Your eType Services login credentials

• Access to download and edit Excel files

• Mailchimp account credentials for importing

1. Navigate to etypeservices.com

2. Log in using your standard credentials (same as you use for newspaper uploads)

1. Hover over the "Circulation" tab in the main navigation

2. Click "Subscriber Report" from the dropdown menu

1. Configure filters to show only active subscribers

2. Remove any inactive users from your export list

3. Click "Search" to apply your filters and display the filtered results

1. Locate the blue "Export Subscribers" button

2. Click the button to initiate the download

3. Save the Excel file to your computer when prompted

1. Open the downloaded Excel spreadsheet
   
   

   • Click "Yes" or "OK" to any security warnings that appear

   • These warnings are normal when opening downloaded files

2. Clean up the data columns:
   
   

   • Identify the essential columns: Email, First Name, and Last Name

   • Delete all other unnecessary columns by:

     • Right-clicking on the column letter (A, B, C, etc.)

     • Selecting "Delete" from the context menu

   • Repeat this process until only the three essential columns remain

3. Save the cleaned file in Excel format for Mailchimp import
   
   

1. Log into your Mailchimp account

2. Follow Mailchimp's official import guide: Import Contacts to Mailchimp

3. Use your cleaned Excel file as the import source

4. Map the columns (Email, First Name, Last Name) to the corresponding Mailchimp fields

5. Complete the import process according to Mailchimp's instructions

Q: What if I get security warnings when opening the Excel file?

A: This is normal for downloaded files. Click "Yes" or "OK" to proceed - these are standard Microsoft Excel security prompts for externally downloaded spreadsheets.

Q: Which columns should I keep in the spreadsheet?

A: Keep only Email, First Name, and Last Name. These are the essential fields that Mailchimp requires for a clean import. All other eType Services data fields can be deleted.

Q: Can I export inactive subscribers too?

A: While you can export inactive subscribers, it's recommended to focus on active subscribers for better email engagement rates. Inactive subscribers may hurt your Mailchimp deliverability.

Q: What if some subscribers don't have first or last names?

A: Mailchimp can handle missing name fields. The email address is the most critical field for the import. Empty name fields won't prevent a successful import.

Q: How often should I update my Mailchimp list with new eType subscribers?

A: This depends on your marketing needs. Monthly or quarterly exports are common, but you can export more frequently if you're running active campaigns.

Q: Will this export include subscriber preferences or subscription details?

A: The basic export includes contact information. Subscription details and preferences stay in your eType Services system and aren't needed for Mailchimp email marketing.

Q: What if the Mailchimp import fails?

A: Check that your Excel file only contains the three required columns, ensure email addresses are properly formatted, and verify there are no duplicate entries. Refer to Mailchimp's troubleshooting guide for specific error messages.