MailChimp Query Builder?
I am trying to create useful MailChimp reports, however, after adding the MailChimp data source to my Supermetrics DataStudio, I'm noticing that a lot of the metrics I'd like to track are inaccurate.
For example, supermetrics is telling me the bounce rate over the last 28 days is 1% however when I checked in Mailchimp, our last five campaigns had bounce rates between 0.5-1%, so it should be lower than 1%
Another example, supermetircs is telling me that the open rate is 37%, however, when I checked in MailChimp I saw that we didn't have an open rate greater than 30% in the last 5 weeks, so it should be lower.
Another example, supermetrics is telling me that we've had 36 unsibscribers, however, I checked and we've actually only had 19 unsibscribers in the last 28 days.
It's already annoying enough to not be able to accurately track my weekly campaigns since supermetrics can only track the last 28 days, so for the data to be inaccurate on top of that is pretty brutal.
I was wondering if anyone knew how to fix this issue?
Thanks in advance