Loading...

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 yet
    This 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 campaigns
    The 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 report
    The 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 included
    This 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.