Mailchimp: Illegal Combination of List metrics/dimensions and Date
I am getting a Query failed: Incompatible fields: IllegalDimensionMetricCombinationException error when combining any of the list metrics/dimensions with a date dimension. The moment I remove the date, it works fine.
After investigating, I believe the problem occurs because:
-The list metrics/dimensions (e.g. members/list name) are not available via the [reports] API method which is normally used for reporting: https://developer.mailchimp.com/documentation/mailchimp/reference/reports/
-Instead, the list metrics/dimensions are only available as part of the [lists] API method: https://developer.mailchimp.com/documentation/mailchimp/reference/lists/
-Unfortunately, the [lists] method doesn't provide time range request parameters for Supermetrics to handle time-based dimensions (unlike the [reports] method which offers the [before_send_time] and the [since_send_time] parameters to do so)
Can you confirm whether that is the problem, and if not, investigate why list metrics and time dimensions cannot be combined?
2 people have this problem