Datapipe
Campaigns
A Mailchimp report of campaigns.
Live with your own API key
Mailchimp for agencies and in-house teams
Email marketers use Mailchimp in Datapipe to see sends, opens, clicks, and campaign revenue.
This page is not indexed yet. It does not have a reviewed integration record.
Connection
Live with your own API key
Live when you paste a Mailchimp API key. No app review.
Fields
Fields on the Mailchimp campaign report object. Source: https://mailchimp.com/developer/marketing/api/campaign-reports/. Read on 2026-10-27. 18 fields.
Synced today
- Date
send_time - Email
campaign_title - Sent
emails_sent - Opens
opens.unique_opens - Clicks
clicks.unique_clicks - Revenue
ecommerce.total_revenue
Advertising
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Total clicks | clicks.clicks_total | All clicks, including repeats. | metric · integer | Advertising | |
| Unique clicks · Synced today | clicks.unique_clicks | People who clicked at least once. | metric · integer | Advertising | |
| Click rate | clicks.click_rate | Unique clicks divided by emails sent. | metric · percent | Advertising |
Audience
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Hard bounces | bounces.hard_bounces | Addresses that permanently failed. | metric · integer | Audience | |
| Soft bounces | bounces.soft_bounces | Addresses that temporarily failed. | metric · integer | Audience |
Dimensions
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Type | type | The campaign type. | dimension · string | Dimensions | |
| Audience | list_name | The audience the campaign was sent to. | dimension · string | Dimensions | |
| Subject | subject_line | The email subject line. | dimension · string | Dimensions | |
| Send time · Synced today | send_time | When the campaign was sent. | dimension · date | Dimensions |
Ecommerce
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Orders | ecommerce.total_orders | Orders tracked from the campaign. | metric · integer | Ecommerce | |
| Revenue · Synced today | ecommerce.total_revenue | Revenue tracked from the campaign. | metric · number | Ecommerce | Revenue |
Engagement
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Emails sent · Synced today | emails_sent | How many emails were sent. | metric · integer | Engagement | |
| Unsubscribed | unsubscribed | How many people unsubscribed. | metric · integer | Engagement | |
| Total opens | opens.opens_total | All opens, including repeats. | metric · integer | Engagement | |
| Unique opens · Synced today | opens.unique_opens | People who opened at least once. | metric · integer | Engagement | |
| Open rate | opens.open_rate | Unique opens divided by emails sent. | metric · percent | Engagement |
Metrics
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Abuse reports | abuse_reports | How many people reported the email. | metric · integer | Metrics |
Traffic
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Campaign title · Synced today | campaign_title | The name of the campaign. | dimension · string | Traffic |
Cross-channel metrics
Spend, Impressions, Clicks, Conversions, and Revenue roll up on All channels when a field maps to them. ROAS is revenue divided by spend. CPA is spend divided by conversions. The Cross-channel column above shows the match.
Example reports
Destinations
Mailchimp to Google Sheets
A sheet you can open, share, and refresh.
Included on every plan.
Mailchimp to Looker Studio
Charts that read the Google Sheet this integration keeps up to date.
Included on every plan. Looker reads the sheet. There is no separate Looker install.
Mailchimp to BigQuery
A warehouse table for the same columns.
Pro and Agency plans.
Mailchimp to AI and MCP
Ask a question in plain English, or let another tool read the report through MCP.
Included on every plan. An AI key is optional.
Mailchimp to the API
Download the rows as CSV or JSON from the report.
Included on every plan.
Mailchimp to Google Drive
CSV, Excel, and an optional JSON file in a Drive folder you pick. Each client gets a Datapipe folder. The file can overwrite itself or keep the date in the name.
Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly.
How to connect
- Create a free account.
- Open Connections and find this source.
- Paste the key the page asks for. The steps next to the box say where to copy it.
- Open the sample report. It switches to your numbers after the key is accepted.
Refresh by plan
| Plan | Refresh | BigQuery | Price |
|---|---|---|---|
| Free | Daily | No | $0/mo |
| Starter | Daily | No | $15/mo |
| Pro | Hourly | Yes | $49/mo |
| Agency | 15 minutes | Yes | $149/mo |
FAQ
Is the Mailchimp connection live?
Live when you paste a Mailchimp API key. No app review.
Do I have to talk to sales?
No. Create an account, connect the source, and the first report is on Home. Sample numbers stay available when a key is missing.
How often do the numbers refresh?
Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts and hourly on the rest. We keep the history for you: 90 days on Free, and for as long as you subscribe on paid plans. No warehouse to set up.
Which fields are synced today?
The list marks Synced today on the fields the current connector pulls. The rest of the list is what the platform publishes, so you can see it before you sign up.