How to Export CSV Data from Mailchimp and Import It into clariBI

Mailchimp is one of the most popular email marketing platforms for businesses of all sizes. Exporting your Mailchimp data into clariBI allows you to use AI to analyze subscriber growth, campaign performance, audience engagement patterns, and the ROI of your email marketing efforts.

What You Can Export from Mailchimp

• Audience (subscriber) lists with contact details
• Campaign performance reports (opens, clicks, bounces)
• Subscriber activity and engagement data
• Audience growth trends
• E-commerce tracking data (if integrated)
• Tag and segment membership
• Unsubscribe and bounce records
• A/B test results

Export CSV Data from Mailchimp

Method 1: Export Your Audience (Subscriber List)

1. Log in to your Mailchimp account at mailchimp.com
2. Click Audience in the left-hand navigation sidebar
3. Select All contacts from the Audience dashboard (or select a specific audience if you have more than one)
4. You should see your full contact list displayed
5. Click the Manage Audience dropdown at the top of the contact list, then select Export Audience
6. Mailchimp will prepare a CSV file containing all contacts with their email addresses, names, tags, subscription status, and other profile information
7. Once the export is ready, click Export as CSV to download the file to your computer

Method 2: Export a Specific Segment or Tag

1. Navigate to Audience > All contacts
2. Click the Tags or Segments tab
3. Select the specific tag or segment you want to export
4. Once the filtered list is displayed, click the Export Segment or Export button
5. Choose CSV as the format
6. Download the file when it is ready

Method 3: Export Campaign Reports

1. Click Reports in the left sidebar, or open a specific campaign from Campaigns and click Report
2. Click on the campaign report you want to export data from
3. You will see the campaign report with open rates, click rates, and other metrics
4. Click the Export or Download button, usually found near the top-right of the report
5. Mailchimp may offer several options: "Export as CSV" for summary data, or you can export specific data like "Clicked", "Opened", or "Bounced" subscriber lists
6. Select the export you want and download the CSV file

Method 4: Export Campaign Comparison Data

1. Navigate to Reports in the left sidebar, then click the Comparative tab
2. Select multiple campaigns using the checkboxes
3. Click Compare Campaigns
4. In the comparison view, click Export to download the comparison data as a CSV

Note: Only users with Owner or Admin roles in Mailchimp can export audience data.

Tips for Clean Exports

• Mailchimp audience exports include all subscriber profile fields, tags, and merge fields — this gives you rich segmentation data to analyze in clariBI
• When exporting campaign reports, export the "All Subscribers" activity data rather than just the summary to get per-subscriber engagement metrics
• If you want to analyze trends over time, export multiple campaign reports and import them together into clariBI for cross-campaign analysis

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "Mailchimp - Audience Export Feb 2025")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "What is my average email open rate across all campaigns?"
- "Show me subscriber growth trend over the past 12 months"
- "Which campaigns had the highest click-through rate?"

clariBI's AI will automatically analyze your data and suggest relevant insights.