You might encounter this error when pulling data from Mailchimp in Supermetrics with either Google Sheets or Looker Studio (formerly Data Studio):
- Script error message: DS_USER: Incompatible fields: IllegalDimensionMetricCombinationException (Supermetrics request ID: xxxxxx). Script error cause: USER Script error stacktrace: getData:119
This happens when a query pulls fields that aren’t compatible with each other.
In Mailchimp, the date range, the campaign/list type, and the combination of metrics (both directly selected for your report data and those used in filters) can all have conflicting effects. These can lead to the “llegalDimensionMetricCombinationException” error.
Instructions
Google Sheets
If you’re seeing this error, try other list types for your query to see if they work. Some fields only work with campaigns; some only work with lists, or automations. If you use the wrong type selected or a combination of types, it can break the query.
"No data" errors can also result if you are pulling a date range that is too long for some fields — some only work for current date, some won't work with the current date, some are only last 7 days or last 30 days.
We aren’t currently able to provide a list of which fields work together. If the error persists after retrying combinations, contact our support team and we’ll work with you to get the right results.
Looker Studio
In Looker Studio, make sure your query type matches the type of campaigns/lists you've selected. If your query type is for automations but you're pulling lists, that could cause issues. For example, this causes llegalDimensionMetricCombinationException errors for some fields meant for automations.
As soon as the Select campaigns/lists setting is changed to only All automations, the error clears.
Start with one selected list/campaign/automation, and add one metric or dimension at a time to figure out which one doesn't work with the list type you selected. We aren't currently able to provide a list of which fields work together. If the error persists after retrying combinations, contact our support team and we’ll work with you to get the right results.