Mailchimp
Stats for your Mailchimp email campaigns: sends, opens, clicks, bounces, ecommerce.
The Mailchimp connector brings your account's email campaign stats into the sheet: one row per campaign, with the metrics already calculated by Mailchimp (no aggregation on our side).
The connection does not use a Google login: you paste your Mailchimp API Key by hand, found under Profile > Extras > API keys in your Mailchimp account. The data center (the part after the dash in the key, e.g. "-us21") is derived automatically from the key itself, nothing else to enter.
Only already-sent campaigns are included (not drafts): regular, plain-text, A/B split, RSS and variate.
Available metrics
| Metric | Period | Aggregation | Note |
|---|---|---|---|
| Emails Sent | campaign | sum | |
| Abuse Reports | campaign | sum | |
| Unsubscribes | campaign | sum | |
| Total Opens | campaign | sum | |
| Unique Opens | campaign | sum | |
| Open Rate (%) | campaign | sum | In the totals row it is recalculated as Unique Opens / Emails Sent across the whole report, not a plain average of the per-row percentages. |
| Total Opens (Proxy Excluded) | campaign | sum | Opens after excluding those generated by automated email-scanning proxies (e.g. Apple Mail Privacy Protection), a closer estimate of real human opens. |
| Unique Opens (Proxy Excluded) | campaign | sum | |
| Open Rate (Proxy Excluded) (%) | campaign | sum | Same totals recalculation as the standard Open Rate, but on proxy-excluded opens. |
| Total Clicks | campaign | sum | |
| Unique Clicks | campaign | sum | |
| Unique Subscriber Clicks | campaign | sum | |
| Click Rate (%) | campaign | sum | In the totals row it is recalculated as Unique Clicks / Emails Sent across the whole report, not a plain average of the per-row percentages. |
| Hard Bounces | campaign | sum | |
| Soft Bounces | campaign | sum | |
| Address Syntax Errors | campaign | sum | |
| Forwards | campaign | sum | |
| Forward Opens | campaign | sum | |
| Facebook Likes | campaign | sum | Requires the Facebook integration linked in the Mailchimp account: empty/zero if not enabled. |
| Unique Facebook Likes | campaign | sum | |
| Facebook Likes from Recipients | campaign | sum | |
| Ecommerce Orders | campaign | sum | Requires a linked ecommerce integration (Shopify, WooCommerce, etc.) in the Mailchimp account: empty/zero if not enabled. |
| Ecommerce Revenue | campaign | sum | See the "Ecommerce Currency" dimension for this value's currency. |
| Ecommerce Spend | campaign | sum |
Available dimensions
| Dimension | Note |
|---|---|
| Date (Sent) | The campaign's send date, in your script's timezone. One row per campaign: this is not a daily series, filter/group the resulting rows if you need a day-by-day breakdown. |
| Send Time | Full send date and time, in your script's timezone. |
| Campaign ID | |
| Campaign Title | The campaign's internal name (only visible to you in Mailchimp), not the email subject line. |
| Email Subject Line | |
| Preview Text | |
| Campaign Type | regular, plaintext, absplit, rss or variate. |
| Delivery Status | Empty for accounts without detailed delivery tracking enabled (not available on every Mailchimp plan). |
| List/Audience ID | |
| List/Audience Name | |
| List Is Active | "true"/"false": whether the recipient list still exists and is active today, not whether it was at send time. |
| Ecommerce Currency | Currency used in that campaign's Ecommerce metrics. Empty if the campaign has no linked ecommerce data. |
Known limits
- No A/B split, list-level or hourly breakdown yetThis first version of the connector does not yet include: A/B split test variants (only the campaign's aggregated data), industry/list benchmark averages, the first-24-hours hourly breakdown, or the report's public share link. These will be added in a later version.
- Only already-sent campaignsThe report only includes already-sent campaigns (regular, plain-text, A/B split, RSS, variate): drafts that haven't been sent yet do not appear.
- Max 50,000 campaigns per reportThe connector downloads at most 50,000 campaigns per single report (50 pages of 1,000). For accounts with a very long sending history, narrow the report period if you need the full history.
- SMS campaigns are not includedThis report covers email campaigns only (regular, plain-text, A/B split, RSS, variate). This is not our choice: Mailchimp's API does not expose performance data for SMS campaigns (the reports endpoint only accepts email campaign types, and the dedicated SMS campaign endpoint only returns metadata such as status and recipient count, no send/delivery/click/reply metrics). If Mailchimp adds real SMS reporting in the future, it will be integrated.
Execution notes
The report period filters campaigns by actual send time (not creation time): a campaign created before the period but sent inside it is still included, one created inside the period but sent later is not.
Percentages (Open Rate, Click Rate, etc.) are expressed as a number from 0 to 100: Mailchimp returns them internally as a fraction from 0 to 1, the connector multiplies them by 100 for consistency with the other connectors.