Supermetrics brings all your Mailchimp data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift and Azure

Mailchimp Metrics and Dimensions