Mailchimp Date Dimension Causes Null Data



I am trying to add the "Date" dimension to my MailChimp data table, using the Supermetrics data connector in Data Studio, to show when the emails were sent. However, every time I add the "Date" dimension it causes all of the metrics in my data table to become "null". The other dimension I am using is the "Campaign name". When I remove the "Date" dimension the metrics populate correctly.


The metrics I have are as follows:

- Emails delivered

- Total Opens

- Open Rate

- Total Clicks

- Click Rate (%)


The dimensions are:

- Campaign Name

- Date




  • Hi Jason,

    some metrics are only available as most recent figures instead of daily historic data in MailChimp. This restriction is on their API and unfortunately there's nothing that we can do about it.

    Best regards,

    -Supermetrics Team

Login to post a comment