Live with your own API key

Mailchimp to Looker Studio

Looker Studio does not need its own Mailchimp connector here. Connect Mailchimp, send Date (send_time), Email (campaign_title), Sent (emails_sent), Opens (opens.unique_opens), Clicks (clicks.unique_clicks), Revenue (ecommerce.total_revenue) to Google Sheets, then in Looker choose that sheet. The charts follow the sheet.

Start free See every Mailchimp field

Columns in this handoff

• Date · send_time
• Email · campaign_title
• Sent · emails_sent
• Opens · opens.unique_opens
• Clicks · clicks.unique_clicks
• Revenue · ecommerce.total_revenue

Plan fit

Included on every plan. Looker reads the sheet. There is no separate Looker install. Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts.

FAQ

How does Mailchimp get to Looker Studio?

Looker Studio does not need its own Mailchimp connector here. Connect Mailchimp, send Date (send_time), Email (campaign_title), Sent (emails_sent), Opens (opens.unique_opens), Clicks (clicks.unique_clicks), Revenue (ecommerce.total_revenue) to Google Sheets, then in Looker choose that sheet. The charts follow the sheet.

Which plan do I need?

Included on every plan. Looker reads the sheet. There is no separate Looker install.

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 BigQuery · Mailchimp to AI and MCP · Mailchimp to the API · Mailchimp to Google Drive