Mailchimp06:00
Written to 
fs_campaign_results
Mailchimp to BigQuery
Every campaign's sends, opens, clicks, bounces and unsubscribes, in your own dataset. Your subscribers' names and email addresses are never read.
30 days of Plus, free, no card. Then one report keeps refreshing weekly.
MailchimpMailchimp06:01
Written to fs_monthly_sends
Mailchimp06:02
Written to fs_audience_engagement
What lands in BigQuery
- One row per campaign, with send date, subject line, audience and type.
- Include Send date and history builds up as campaigns go out.
- Days follow your Mailchimp account's time zone.
- Up to 1,000 campaigns in a report's date range.
Google lists a Mailchimp connector in preview in its BigQuery Data Transfer Service, free while it's in preview.
Create an API key in Mailchimp and paste it on the Sources page of your Fresh Sheets account.
Which plans send to BigQuery
Pro and Max, and the free 30 days. Sending to BigQuery uses no extra refreshes: one run counts once, wherever it lands.
FAQ
Questions
Can the key do more than read?
Yes. That's Mailchimp's design, not ours: its keys can't be limited to reading. Our code only ever makes two named reads with it.
Are subscriber details included?
No. Reports are one row per campaign. Nothing about individual subscribers is read.
Other sources to BigQuery
Analytics
Advertising
Send your Mailchimp reports to BigQuery
BigQuery is included in the free 30 days, then on Pro and Max.