I'm trying to split mailchimp data by member. I would like to see how many emails a subscribers receive, opened and clicked. I see the list members dimensions but I'm not able to run the query. It always gives me errors like "Query failed: Incompatible fields: IllegalDimensionMetricCombinationException".
I follow the advice "You shouldn't include any metrics when fetching Email" but it doesn't work the same.
Any solution for exporting my subscribers activity?
these restrictions are coming from MailChimp API and there's unfortunately nothing that we can do about them. Very recently we updated the MailChimp connector and all the latest possible query options that they offer are currently present in Supermetrics. Sorry to hear that they won't allow you to do a query that you'd need.