Mailchimp Mailchimp

Mailchimp

Source

Use Dataddo's MailChimp connector to explore any data available via Mailchimp's official API. Access dozens of metrics and attributes—from the most basic, like CTR and open rate, to the most advanced, like specific member lists and email campaign performance stats. Build and blend custom datasets directly in Dataddo, then send them anywhere.

DATA FIELDS

Explore Data You Can Extract from Mailchimp

Data Category

Need fields you don't see?

Let us know and we'll add them to the connector. Just send a request here..

Available Attributes (271)

Attribute
campaign_id

Campaign ID

string
list_id

List ID

string
list_is_active

List Is Active

integer
contact_status

Contact Status

string
email_id

Email ID

string
email_address sensitive

Email Address

string
merge_fields_property1

Merge Field Property 1

string
merge_fields_property2

Merge Fields Property 2

string
vip

Vip

integer
opens_count

Opens Count

integer
opens_timestamp

Opens Timestamp

datetime
campaign_title

Campaign Title

string
id

Id

string
campaign_title

Campaign Title

string
type

Type

string
list_id

List Id

string
list_name

List Name

string
subject_line

Subject Line

string
emails_sent

Emails Sent

float
abuse_reports

Abuse Reports

float
unsubscribed

Unsubscribed

float
send_time

Send Time

datetime
bounces_hard_bounces

Bounces Hard Bounces

float
bounces_soft_bounces

Bounces Soft Bounces

float
bounces_syntax_errors

Bounces Syntax Errors

float
opens_opens_total

Opens Opens Total

integer
opens_unique_opens

Opens Unique Opens

integer
opens_open_rate

Opens Open Rate

float
opens_last_open

Opens Last Open

datetime
clicks_clicks_total

Clicks Clicks Total

integer
clicks_unique_clicks

Clicks Unique Clicks

integer
clicks_unique_subscriber_clicks

Clicks Unique Subscriber Clicks

integer
clicks_click_rate

Clicks Click Rate

float
clicks_last_click

Clicks Last Click

string
facebook_likes

Facebook Likes

integer
facebook_unique_likes

Facebook Unique Likes

integer
facebook_recipient_likes

Facebook Recipient Likes

integer
industry_stats_type

Industry Stats Type

string
industry_stats_bounce_rate

Industry Stats Bounce Rate

string
industry_stats_open_rate

Industry Stats Open Rate

string
industry_stats_click_rate

Industry Stats Click Rate

string
industry_stats_unopen_rate

Industry Stats Unopen Rate

string
industry_stats_unsub_rate

Industry Stats Unsub Rate

string
industry_stats_abuse_rate

Industry Stats Abuse Rate

string
list_stats_sub_rate

List Stats Sub Rate

float
list_stats_unsub_rate

List Stats Unsub Rate

float
list_stats_open_rate

List Stats Open Rate

float
list_stats_click_rate

List Stats Click Rate

float
delivery_status_enabled

Delivery Status Enabled

string
delivery_status_can_cancel

Delivery Status Can Cancel

string
delivery_status

Delivery Status

string
delivery_status_emails_sent

Delivery Status Emails Sent

string
delivery_status_emails_canceled

Delivery Status Emails Canceled

string
country_code

Country Code

string
region

Region

string
region_name

Region Name

string
opens

Opens

integer
campaign_id

Campaign ID

string
campaign_title

Campaign Title

string
_id

Link ID

string
campaign_id

Campaign ID

string
total_clicks

Total clicks

integer
unique_click_percentage

Unique click percentage

float
unique_clicks

Unique clicks

integer
click_percentage

Click percentage

float
last_click

Last click

datetime
url

URL

string
campaign_title

Campaign Title

string
long_archive_url

Long Archive URL

string
send_time

Send Time

datetime
campaign_id

Campaign ID

string
status

Status

string
emails_sent

Emails sent

integer
emails_canceled

Emails canceled

integer
content_type

Content type

string
recipients_list_id

Recipients list ID

string
recipients_list_name

Recipients list name

string
recipient_count

Recipient count

integer
click_rate

Click rate

float
clicks

Clicks

integer
ecommerce_total_orders

Ecommerce total orders

integer
ecommerce_total_revenue sensitive

Ecommerce total revenue

float
ecommerce_total_spent sensitive

Ecommerce total spent

float
open_rate

Open rate

float
opens

Opens

integer
subscriber_clicks

Subscriber clicks

integer
unique_opens

Unique opens

integer
create_time

Create time

datetime
from_name

From name

string
preview_text

Preview text

string
reply_to

Reply to

string
subject_line

Subject line

string
title

Title

string
type

Type

string
send_time

Send time

datetime
long_archive_url

Long Archive URL

string
campaign_id

Campaign Id

string
content_description

Content Description

string
from_name

From Name

string
variate_settings_id

Variate Settings Id

string
recipients

Recipients

string
reply_to

Reply To

string
send_time

Send Time

datetime
subject_line

Subject Line

string
interest_id

Interest ID

string
list_id

List ID

string
name

Name

string
subscriber_count

Subscriber count

integer
category_id

Category ID

string
category_title

Category title

string
category_type

Category type

string
member_id

Member Id

string
email_address sensitive

Email Address

string
interest_4ec98a8a28

Interest 4Ec98A8A28

integer
interest_6016142832

Interest 6016142832

integer
interest_78572f4d05

Interest 78572F4D05

integer
interest_78bfaf3e9b

Interest 78Bfaf3E9B

integer
interest_89cd1ae729

Interest 89Cd1Ae729

integer
interest_a033893783

Interest A033893783

integer
interest_abb5f62924

Interest Abb5F62924

integer
interest_ba7eb763a4

Interest Ba7Eb763A4

integer
interest_dd51bed592

Interest Dd51Bed592

integer
language

Language

string
last_changed

Last Changed

datetime
list_id

List Id

string
member_rating

Member Rating

float
ABTEST sensitive

Abtest

string
ADDRESS sensitive

Address

string
CITY sensitive

City

string
COMPANY sensitive

Company

string
COMP_SIZE sensitive

Comp Size

string
COUNTRY sensitive

Country

string
EBOOKSHIST sensitive

Ebookshist

string
EBOOKTITLE sensitive

Ebooktitle

string
FNAME sensitive

Fname

string
FULLNAME sensitive

Fullname

string
IMPORTED sensitive

Imported

string
INDUSTRY sensitive

Industry

string
JOBTITLE

Jobtitle

string
LINKID

Linkid

string
LNAME sensitive

Lname

string
MMERGE18 sensitive

Mmerge18

string
POSTALCODE sensitive

Postalcode

string
REFCODE sensitive

Refcode

string
REFERRER sensitive

Referrer

string
STATE sensitive

State

string
TODAYCHECK sensitive

Todaycheck

string
WSOURCE sensitive

Wsource

string
source

Source

string
stats_avg_click_rate

Stats Avg Click Rate

float
stats_avg_open_rate

Stats Avg Open Rate

float
status

Status

string
timestamp_opt

Timestamp Opt

datetime
timestamp_signup

Timestamp Signup

datetime
vip

Vip

float
unsubscribe_reason

Unsubscribe Reason

string
_id

Link ID

string
name

Name

string
date_created

Date created

datetime
list_rating

List rating

float
beamer_address

Beamer address

string
member_count

Member count

integer
total_contacts

Total contacts

integer
unsubscribe_count

Unsubscribe count

integer
cleaned_count

Cleaned count

integer
member_count_since_send

Member count since send

integer
unsubscribe_count_since_send

Unsubscribe count since send

integer
cleaned_count_since_send

Cleaned count since send

integer
campaign_count

Campaign count

integer
campaign_last_sent

Campaign last sent

datetime
merge_field_count

Merge field count

integer
avg_sub_rate

Average subscription rate

float
avg_unsub_rate

Average unsubscription rate

float
target_sub_rate

Target subscription rate

float
open_rate

Open rate

float
click_rate

Click rate

float
last_sub_date

Last subscription date

datetime
last_unsub_date

Last unsubscription date

datetime
_id

List ID

string
cleaned

Cleaned

integer
deleted

Deleted

integer
existing

Existing

integer
imports

Imports

integer
optins

Optins

integer
pending

Pending

integer
reconfirm

Reconfirm

integer
subscribed

Subscribed

integer
transactional

Transactional

integer
unsubscribed

Unsubscribed

integer
date

Date

datetime
merge_id

Merge Id

float
default_value

Default Value

string
display_order

Display Order

float
list_id

List Id

string
name

Name

string
options_size

Options Size

string
public

Public

integer
required

Required

integer
tag

Tag

string
type

Type

string
id

Id

float
created_at

Created At

datetime
member_count

Member Count

integer
updated_at

Updated At

datetime
list_id

List Id

string
name

Name

string
type

Type

string
id

Id

string
email_address sensitive

Email Address

string
email_client

Email Client

string
email_type

Email Type

string
interests_0000681922

Interests 0000681922

integer
interests_ff46e0d6a4

Interests Ff46E0D6A4

integer
location_ip_opt

Location Ip Opt

string
location_ip_signup

Location Ip Signup

string
location_language

Location Language

string
location_last_changed

Location Last Changed

datetime
location_country_code

Location Country Code

string
location_dstoff

Location Dstoff

float
location_gmtoff

Location Gmtoff

float
location_latitude sensitive

Location Latitude

float
location_longitude sensitive

Location Longitude

float
location_timezone

Location Timezone

string
member_rating

Member Rating

float
merge_fields_ADDRESS_1 sensitive

Merge Fields Address 1

string
merge_fields_ADDRESS_2 sensitive

Merge Fields Address 2

string
merge_fields_ADDRESS_city

Merge Fields Address City

string
merge_fields_ADDRESS_country

Merge Fields Address Country

string
merge_fields_ADDRESS_state

Merge Fields Address State

string
merge_fields_ADDRESS_zip sensitive

Merge Fields ADDRESS zip

string
merge_fields_COMPANY

Merge Fields Company

string
merge_fields_FNAME sensitive

Merge Fields Fname

string
merge_fields_LNAME sensitive

Merge Fields Lname

string
merge_fields_DATESOLD

Merge Fields Datesold

string
merge_fields_GENDER sensitive

Merge Fields Gender

string
merge_fields_LANGUAGE

Merge Fields Language

string
merge_fields_PRODSKU

Merge Fields Prodsku

string
merge_fields_PRODSOLD

Merge Fields Prodsold

string
merge_fields_PRODTYPE

Merge Fields Prodtype

string
merge_fields_SIGNUP

Merge Fields Signup

string
merge_fields_TAGS

Merge Fields Tags

string
avg_click_rate

Avg Click Rate

float
avg_open_rate

Avg Open Rate

float
timestamp_opt

Timestamp Opt

datetime
status

Status

string
timestamp_signup

Timestamp Signup

datetime
unique_email_id

Unique Email Id

string
vip

Vip

float
segments_id

Segments Id

string
email_id

Email ID

string
email_address sensitive

Email Address

string
FNAME sensitive

FNAME

string
LNAME sensitive

LNAME

string
COMPANY sensitive

Company

string
TITLE

Title

string
TELEPHONE sensitive

Telephone

string
REGION sensitive

Region

string
PAIS sensitive

Pais

string
vip sensitive

Vip

string
status

Status

string
open_count

Open Count

integer
last_open

Last Open

datetime
absplit_group

Absplit Group

string
gmt_offset

Gmt Offset

float
campaign_id

Campaign Id

string
list_id

List Id

string
list_is_active

List Is Active

string
campaign_title

Campaign Title

string
reason

Reason

string
campaign_id

Campaign ID

string
count

Count

integer

Pricing

See all Dataddo plans

Compare Dataddo's flow-based pricing tiers side by side and start your 14-day free trial.

View pricing
One Platform to Connect All Your Data

Why Dataddo?

One Ingestion Layer for SaaS, Databases, and Files

One Ingestion Layer for SaaS, Databases, and Files

Most teams use multiple tools and “spaghetti code” for ingestion, depending on the type of sources and loading patterns. Dataddo brings this under one control plane and one predictable pricing structure. 400+ connectors included.

Built for Cloud and On-Premise Environments

Built for Cloud and On-Premise Environments

Run Dataddo in both cloud and hybrid on-prem configurations. The control plane stays in the cloud; your data never leaves your perimeter. Supports segmented and private networks, and legacy systems including DB2, Informix, and Sybase.

Full API Control - No UI Required

Full API Control - No UI Required

Dataddo is built API-first. Use the UI when you want it; bypass it entirely when you don’t and orchestrate your pipelines programmatically.

Managed Ingestion Operations. We Own the Reliability.

Managed Ingestion Operations. We Own the Reliability.

Dataddo takes operational responsibility for your ingestion layer. We manage connector maintenance, handle API changes from source systems, monitor pipelines proactively, and execute backfills and recovery. Your engineering team doesn’t have to.

Full Visibility Into Every Data Flow

Full Visibility Into Every Data Flow

Dataddo gives you complete observability across your ingestion layer: pipeline logs, run histories, data lineage, and audit trails. Know what moved, when it moved, what changed, and why. Built for environments where explainability and accountability are not optional.

The Data Foundation Your AI Needs

The Data Foundation Your AI Needs

Enterprise AI depends on a governed, secure data layer. Dataddo consolidates SaaS, database, and file data into a unified managed pipeline, delivering to vector databases, feature stores, and data lakes, with native sensitive data hashing.

See All Platform Benefits
Testimonials

Our Customers Love Us

G2 Implementation Winter 2025

Amalia Bornstein

Global Social Content and Marketing Data Analyst

Uber Eats

“The data team at Uber Eats appreciates Dataddo's user-friendly interface that is designed for operation by non-technical team members in an order to minimalize the need for excessive training to support efficient project delivery.”

G2 Implementation Winter 2025

Andrew Hart

Chief Operations Officer

Sat 7

“Working with Dataddo has greatly simplified our reporting and given us access to trend data and insights that we were previously unable to generate.”

G2 Implementation Winter 2025

Vahan Petrosayan

Director of IT & Infrastructure

Search Engine Journal

“With Dataddo, all of my questions get answered faster …[and it's] fun to play with data now.”

G2 Implementation Winter 2025

Michael Guntenaar

CTO

ID&T Group

“Dataddo opens up gates and takes away the hurdles of working with data.”

G2 Implementation Winter 2025

Laurent Partouche

CPO

FoodChéri & Seazon

“We chose Dataddo for its user-friendliness, automatic transformations, clear pricing policy, and the quality of the human relationship that was established from our first exchanges.”

G2 Implementation Winter 2025

Natheer Maloon

Technology Solutions Manager

Boldr

“Dataddo support proved immensely valuable throughout the implementation phase. 9.5 out of 10.”

G2 Implementation Winter 2025

Zdeněk Hejnak

Data Development Team Leader

Livesport

“We save about 70% of the time it would otherwise take to ingest all our data, or 3-4 full-time equivalents, and spend this much more time on data analytics and activation. We only have one full-time data engineer, who does more than just collect data, while our BI team consists of 11 members.”

G2 Implementation Winter 2025

Greg Senior

Business Operations Manager

Farm Focus

“Appreciate all the help and support for us. A refreshing level of service from a tech company! Thank you!”

G2 Implementation Winter 2025 G2 Performer Winter 2025 Google Cloud Partner Tableau Technology Partner AWS Partner Network Gartner Cool Vendor