Skip to content

MailChimp Export Documentation

Menu Location: Settings > Integrations > MailChimp Export

Access Level: Manager and above

Last Updated: 2026-03-01

Overview

The MailChimp Export tool creates formatted customer lists for import into MailChimp (now Mailchimp) for email marketing campaigns. Export customer data with proper formatting, segmentation tags, and merge fields ready for MailChimp import.

Primary Functions:

  • Export customer email lists to CSV for MailChimp
  • Include merge fields (first name, tags, custom fields)
  • Filter customers by subscription status, tags, or segments
  • Maintain email subscription preferences
  • Sync customer segments for targeted campaigns

Page Layout

Header Section

  • Page Title: "MailChimp Export"
  • Quick Export Buttons: Active Customers, All Customers, Tagged Customers
  • Filter Section: Advanced filtering options

Filter Options

  • Customer status (Active, Cancelled, All)
  • Customer tags
  • Subscription preferences
  • Date ranges
  • Custom segments

Export Preview

  • Shows count of customers to be exported
  • Preview of first 10 customers
  • Merge field selection checkboxes

Export Button

Click to download CSV formatted for MailChimp import

Export Options

Active Customers Only

Exports all currently subscribed, active customers.

Includes:

  • Email address (required)
  • First name
  • Last name
  • Subscription status
  • Customer tags
  • Signup date

Best For:

  • Newsletter campaigns
  • Product announcements
  • Active customer engagement

All Customers

Exports entire customer database including cancelled and paused accounts.

Use Cases:

  • Win-back campaigns for cancelled customers
  • Re-engagement campaigns
  • Comprehensive customer database sync

Tagged Customers

Export customers with specific tags.

Process:

  1. Select one or more tags
  2. Choose to include customers with ALL tags or ANY tag
  3. Export filtered list

Examples:

  • "VIP" tag for exclusive offers
  • "Interested in Organic" for organic product promotions
  • "First-time Buyer" for onboarding sequence

Custom Segment Export

Apply multiple filters to create targeted lists.

Available Filters:

  • Status
  • Tags
  • Signup date
  • Last order date
  • Lifetime value
  • Location (zip code, state)
  • Product preferences

MailChimp Merge Fields

Standard Merge Fields

Merge Field MailChimp Tag Description
Email EMAIL Customer email (required)
First Name FNAME Customer first name
Last Name LNAME Customer last name
Subscription Status STATUS Active, Paused, Cancelled
Signup Date SIGNUPDATE Account creation date
Tags TAGS Comma-separated customer tags

Optional Custom Merge Fields

Select additional fields to include:

Merge Field MailChimp Tag Purpose
Box Type BOXTYPE Subscription box type
Delivery Day DELIVDAY Customer's delivery day
Last Order Date LASTORDER Most recent order date
Lifetime Value LTV Total customer spend
Referral Source REFSOURCE How did you hear about us

Benefits:

  • Personalize email content
  • Segment within MailChimp
  • Trigger automated workflows
  • A/B test messaging

Using MailChimp Export

Basic Export Process

Steps:

  1. Navigate to Settings > Integrations > MailChimp Export
  2. Select customer filter (Active, All, or Tagged)
  3. (Optional) Apply additional filters
  4. Select merge fields to include
  5. Click "Preview Export" to verify count
  6. Click "Download MailChimp CSV"
  7. Save file to computer

File Format:

  • CSV (comma-separated values)
  • UTF-8 encoding
  • MailChimp-compatible headers
  • Properly escaped special characters

Importing into MailChimp

Steps:

  1. Log into MailChimp account
  2. Navigate to Audience
  3. Click "Manage Audience" > "Import contacts"
  4. Select "Import from CSV or TXT file"
  5. Upload downloaded export file
  6. Map columns to MailChimp fields
  7. Choose import options (update existing, add new)
  8. Review import summary
  9. Import contacts

Important Settings:

  • Update existing contacts: Yes (to sync changes)
  • Auto-subscribe: Only if appropriate (may need re-confirmation)
  • Tags: Import tags for segmentation

Common Use Cases

Use Case 1: Monthly Newsletter Campaign

Goal: Send monthly newsletter to active customers

Steps:

  1. Select "Active Customers Only"
  2. Include merge fields: FNAME, LNAME, BOXTYPE
  3. Download CSV
  4. Import into MailChimp "Active Customers" audience
  5. Create email campaign with personalization: "Hi {{FNAME}}"
  6. Segment by BOXTYPE for customized content
  7. Send campaign

Use Case 2: Win-Back Campaign for Cancelled Customers

Goal: Re-engage customers who cancelled in last 90 days

Steps:

  1. Select "All Customers"
  2. Filter by Status: Cancelled
  3. Filter by cancellation date: Last 90 days
  4. Include merge fields: FNAME, LNAME, LASTORDER
  5. Download export
  6. Create MailChimp segment: "Recent Cancellations"
  7. Build win-back email offering discount or improvements
  8. Send campaign

Email Tips:

  • Acknowledge they left
  • Highlight what's new/changed
  • Offer limited-time return incentive
  • Make re-subscription easy

Use Case 3: VIP Exclusive Promotion

Goal: Send exclusive offer to VIP customers

Steps:

  1. Select "Tagged Customers"
  2. Choose tag: "VIP"
  3. Include merge fields: FNAME, LTV
  4. Download export
  5. Import to MailChimp as "VIP Customers" segment
  6. Create exclusive offer email
  7. Track VIP engagement and conversions

Use Case 4: Geographic Targeting

Goal: Promote local pickup option to nearby customers

Steps:

  1. Select "Active Customers"
  2. Filter by zip code or state
  3. Include merge fields: FNAME, DELIVDAY
  4. Download export
  5. Create MailChimp segment by location
  6. Send geographically relevant promotion
  7. Track local engagement

Use Case 5: Product Interest Segmentation

Goal: Send meat promotion to meat enthusiasts

Steps:

  1. Select "Tagged Customers"
  2. Choose tag: "Loves Meat" or "Carnivore Box"
  3. Include merge fields: FNAME, BOXTYPE, LASTORDER
  4. Download export
  5. Import with tag "Meat Enthusiast"
  6. Create targeted meat product email
  7. Include meat-specific recipes and promotions

Filters & Options

Status Filters

  • Active: Currently subscribed
  • Paused: Temporarily stopped
  • Cancelled: Subscription ended
  • All: Every customer in database

Tag Filters

  • Has Tag: Customers with specific tag(s)
  • Doesn't Have Tag: Exclude certain tags
  • Any Tag: Customers with at least one of selected tags
  • All Tags: Customers with all selected tags

Date Filters

  • Signup Date: When customer created account
  • Last Order Date: Most recent order delivery
  • Cancellation Date: When subscription ended
  • Custom Date Range: Specific start and end dates

Engagement Filters

  • Email Subscribers Only: Opted in to emails
  • Unsubscribed: Opted out (for suppression list)
  • Has Ordered: Placed at least one order
  • Never Ordered: Signed up but no orders

Troubleshooting

MailChimp Rejects Import

Symptoms:

  • Import fails with error
  • Some contacts not imported
  • "Invalid email" errors

Solutions:

  1. Verify CSV file format (UTF-8 encoding)
  2. Check for invalid email addresses in export
  3. Remove duplicate emails before import
  4. Ensure column headers match MailChimp expectations
  5. Try importing smaller batches (1000 at a time)

Common Causes:

  • Duplicate email addresses
  • Invalid email format
  • Missing required EMAIL column
  • Special characters not escaped properly

Merge Fields Not Populating

Symptoms:

  • MailChimp shows merge fields but no data
  • {{FNAME}} appears in emails instead of names
  • Merge fields blank for some contacts

Check:

  1. Verify merge field column mapping during import
  2. Ensure field names match exactly
  3. Check that data exists in export CSV
  4. Confirm merge fields created in MailChimp audience
  5. Test with preview/test email

Solutions:

  • Re-import and carefully map columns
  • Create custom merge fields in MailChimp first
  • Verify data in CSV file before importing

Export Shows Wrong Customer Count

Symptoms:

  • Expected more/fewer customers
  • Known customers missing from export
  • Count doesn't match customer list

Check:

  1. Review applied filters
  2. Verify status filter includes desired customers
  3. Check tag spelling (case-sensitive)
  4. Confirm date range filters
  5. Verify customers have email addresses (required)

Common Causes:

  • Filters too restrictive
  • Customers missing email addresses
  • Wrong status selected
  • Tag filter excluding customers
  • Customer Export (dashboard?customer_export=1) - General customer data export
  • Weekly CSV Export (weekly-csv-export.php) - Weekly customer and order data
  • Customers Page (customers.php) - Search and filter customers
  • Email Templates - Create email campaigns

Typical Workflow:

  1. Segment customers in admin
  2. Export to MailChimp
  3. Import into MailChimp audience
  4. Create targeted email campaign
  5. Track results in MailChimp
  6. Update customer tags based on engagement

Permissions & Access

Required Access Level: Manager or higher

Access Level Capabilities:

  • Customer Service: No access (email marketing restricted)
  • Manager: Can export and import to MailChimp
  • Administrator: All export capabilities + MailChimp API integration
  • Kiva Admin: All features + export logs and debugging

Best Practices

Regular Export Schedule

  1. Weekly Active Customer Sync: Keep MailChimp audience current
  2. Monthly Full Sync: Update all customer data
  3. Campaign-Specific Exports: Create targeted lists as needed
  4. Quarterly Win-Back: Export recent cancellations

Data Quality

  1. Verify Filters: Double-check before exporting
  2. Preview Count: Ensure expected number of customers
  3. Test Import: Import 10-20 contacts first to verify mapping
  4. Update Tags: Keep customer tags current for accurate segmentation

Email Compliance

  1. Honor Unsubscribes: Never export customers who unsubscribed
  2. Suppression List: Maintain unsubscribe list in MailChimp
  3. Re-confirmation: Consider re-confirming old contacts
  4. GDPR Compliance: Only export necessary data

Campaign Effectiveness

  1. Segment Precisely: Smaller, targeted lists perform better
  2. Personalize: Use merge fields for personalization
  3. A/B Test: Test subject lines and content
  4. Track Results: Monitor open rates, clicks, conversions

Quick Reference Card

Task Action/Location
Export active customers Select "Active Customers Only" > Download
Export VIP customers Select "Tagged Customers" > Choose "VIP" tag
Win-back campaign export Filter: Cancelled + Last 90 days > Download
Newsletter subscriber list Filter: Active + Email Subscribed > Download
Add merge fields Check boxes for FNAME, LNAME, etc. before export
Preview export count Click "Preview Export" before downloading
Import to MailChimp Audience > Import > Upload CSV > Map fields
Update existing contacts During import, select "Update existing" option

FAQs

Can I export to other email platforms besides MailChimp?

Yes, the CSV format works with most email platforms including Constant Contact, ActiveCampaign, SendGrid, and others. Column headers may need adjustment.

How often should I sync customer data to MailChimp?

Weekly syncs keep your audience current. Monthly full syncs ensure all data is up-to-date.

What if customers have unsubscribed in MailChimp?

MailChimp maintains its own unsubscribe list. Re-importing won't override unsubscribes. Keep suppression list current.

Can I schedule automatic exports?

Not currently available. You'll need to manually export as needed. Set calendar reminders for regular sync schedule.

Why are some customers missing from my export?

Common reasons: no email address on file, filtered out by status/tags, or unsubscribed from emails in your system.

How do I handle duplicate accounts?

Identify duplicates in Customers page first, merge accounts, then export. MailChimp will also detect duplicate emails.

Can I export customer phone numbers?

Yes, add the phone number merge field during export. Useful for SMS campaigns if MailChimp supports it.

What's the maximum number of customers I can export at once?

No limit in the export, but MailChimp may have import limits. Consider batching imports of 5,000-10,000 at a time for large lists.

Change Log

2026-03-01

  • Initial documentation created
  • Documented export options and merge fields
  • Added MailChimp import process
  • Created use cases for common campaigns
  • Added troubleshooting guide

End of Documentation

For additional help, contact your system administrator or Kiva Logic support.