Datapipe
Mailchimp

Live with your own API key

Mailchimp to the API

Download Date (send_time), Email (campaign_title), Sent (emails_sent), Opens (opens.unique_opens), Clicks (clicks.unique_clicks), Revenue (ecommerce.total_revenue) as CSV or JSON from the report page, or pull the preview from the API after you sign in. The file uses the same columns as the on-screen table.

Start free See every Mailchimp field

Columns in this handoff

Plan fit

Included on every plan. Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts.

FAQ

How does Mailchimp get to the API?

Download Date (send_time), Email (campaign_title), Sent (emails_sent), Opens (opens.unique_opens), Clicks (clicks.unique_clicks), Revenue (ecommerce.total_revenue) as CSV or JSON from the report page, or pull the preview from the API after you sign in. The file uses the same columns as the on-screen table.

Which plan do I need?

Included on every plan.

What if the source is not connected yet?

The report still opens with sample rows and a Sample data label. It switches to live rows after the credential is accepted.

Other ways out of Mailchimp

Mailchimp to Google Sheets · Mailchimp to Looker Studio · Mailchimp to BigQuery · Mailchimp to AI and MCP · Mailchimp to Google Drive