Mailchimp
→
Google Data Studio
Connect your Mailchimp data to Google Data Studio (formerly Looker Studio) for free. Analyse Emails sent, Campaign open rate, Campaign click rate, and Unique opens, with +204 fields, proactive troubleshooting for A/B test data gaps, transparent free-tier pricing, and native data blending with GA4, Shopify, and WooCommerce without ETL middleware, and every Mailchimp list field.
Free forever plan · No credit card
Browse pre-built Mailchimp dashboard templates to get started faster. Each template is designed for your email marketing reporting in Data Studio.
Most teams waste hours exporting Mailchimp CSVs daily or stitching together multiple connections to get complete Mailchimp campaign and audience data. Porter replaces that with a direct, no-code connector so you can build dashboards in minutes.
| Feature | Porter No-code marketing data warehouse | Others Connectors & ETL |
|---|---|---|
| Storage | Cloud-native storage with automatic backups and no file management | Data lives in spreadsheets or local files |
| Data syncing | Scheduled automatic refresh with live sync options | Manual CSV exports or one-time API pulls |
| Attribution | Native e-commerce and campaign attribution inside Data Studio | Disconnected campaign and revenue data |
| Data blending | Built-in data blending with GA4, Shopify, and WooCommerce without ETL middleware | Requires ETL middleware or custom scripts to combine GA4, Shopify, or WooCommerce |
| Destinations | Send to Data Studio, Google Sheets, Claude, and BigQuery in one subscription | Locked into one dashboard tool |
That is what makes the Porter Metrics Data Studio connector for Mailchimp better.
Access 73 dimensions and 131 metrics including campaign performance, list health, A/B testing, automation, and e-commerce data.
Proactive troubleshooting for A/B test data gaps ensures your split-test results appear correctly in Data Studio reports.
Blend Mailchimp email data with GA4, Shopify, and WooCommerce natively without ETL middleware.
Monitor bounce rates, unsubscribe trends, list growth, and abuse reports alongside campaign opens and clicks.
Secure, token-based authentication with Mailchimp. No API keys to copy, store, or rotate manually.
Set refresh intervals from real-time to daily so your Data Studio dashboards stay current without manual updates.
Connect multiple Mailchimp accounts and audiences to a single Data Studio report for consolidated reporting.
Start free with clear limits. Upgrade only when your list volume or refresh frequency grows.
Create a free Porter account in seconds. No credit card required.
Connect your Mailchimp account with OAuth. Grant access to your lists and campaigns securely.
Choose from 204 fields across 10 categories. Set your reporting period and filters.
Open Data Studio, add the Porter Mailchimp connector, and authenticate with your Google account.
Drag and drop Mailchimp fields into charts. Save and share your email marketing dashboard.
Porter exposes 204 Mailchimp fields across 10 categories so you can build any email marketing report in Data Studio.
Access every field available in Mailchimp—over 204 in total—plus calculated metrics for campaign performance and list health.
We name fields exactly as in Mailchimp, so campaign and audience data is familiar to marketers. At the same time, we standardize them for blending with GA4, Shopify, and WooCommerce.
Segment data by campaign, list, audience, location, device, date, hour, week, month, year, and every other breakdown supported by Mailchimp.
Access dedicated A/B Testing category fields including Bounces A, Opens A, Unique opens A, Clicks A, and winner criteria for split-test analysis.
Track list growth, average subscriptions, target growth rate, total members, cleaned members, and unsubscribed members over time.
Connect e-commerce revenue and order data alongside automation workflow status, type, and creation dates.
Porter supports 15+ data sources and 10+ destinations. Mix and match in one subscription, no extra seats or hidden per-destination fees.
Most setups work on the first try. If they don’t, here are the six issues we see most often.
| Issue | Solution |
|---|---|
| A/B test data not showing in Data Studio | Mailchimp does not return Multivariate Campaign data through standard API endpoints. Use Porter’s A/B Testing category fields (Bounces A, Opens A, Unique opens A, etc.) which are mapped specifically for standard A/B campaigns. Ensure your campaign type is ab_split, not variate. |
| Date range filters not responding | This usually happens when the Date dimension is not set as a filter control in Data Studio. Add the Date dimension to a filter control and set the data type to Date. Verify your Porter connector date range matches your report date range. |
| Multiple Mailchimp accounts or audiences required | Porter supports multi-account connections. Add each Mailchimp account as a separate data source in the same Data Studio report, then blend them using Data Studio’s native data blending or Porter’s built-in cross-account aggregation. |
| Campaign names missing from reports | Check that the Campaign name dimension is selected in your Porter connector configuration. If campaigns were created after the initial sync, refresh the field list in Data Studio or trigger a manual data refresh from Porter. |
| Data not refreshing automatically | Verify your refresh schedule is configured in Porter (not just in Data Studio). Data Studio cache can also delay updates. For real-time needs, set Porter to the shortest refresh interval and disable Data Studio cache for that data source. |
| List growth metrics appear outdated | List Health & Growth metrics like List total members and List average subscriptions per month are calculated by Mailchimp and may not update instantly. Allow 24 hours after list changes for these calculated metrics to reflect in Data Studio. |
Mailchimp lists
Billed annually · $12.5/account
Unlimited 14-day free trial + Free forever plan
Join 1,600+ marketers and agencies reporting Mailchimp in Data Studio with Porter.
