Supermetrics Support Forum

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?


Thanks.

error.png
(18.7 KB)

1 person has this problem
Login to post a comment