How to get Mailchimp List Subscribers

Im trying to get subscribers by list and split by month in the column. I've tried several options and don't get the correct number or it says that the metrics/dimensions don't work.

I've tried member count (but that's all the members i have both subscribed and unsubscribed.)

I don't know what else to try.

1 person has this problem
  • Hi Ben,

    It's probably nothing you are doing wrong, but the unfortunate case that the MailChimp API is rather restrictive around some combinations, especially with dates. It cannot get historical data for some metrics (so some dates will work but only for the last 7 or 30 days), and some metrics cannot be split by date at all. Because it is on the API side, there's little we can do about it until MailChimp decides to change how that works.

    -Thank you

    Supermetrics Team

  • Hi, has this changed in the last few days? I previously could pull from MC into data studio and have lists display correctly. Now i'm pulling from MC into sheets, the figures don't add up. How is the member count metric calaculated?

  • Hi Sam,

    Nothing has changed with this connector recently, but these two products are using slightly different versions of the connector so they may not behave identically. The Sheets version doesn't have the query type setting and it also isn't affected by issues in DS that can cause discrepancies, like the filter issue.

    The only thing that should matter is does the Sheets value match MailChimp or not. The metric is a direct count gathered from MC for each list, so if it doesn't match MC then we can investigate it as as discrepancy. In which case, please submit a private ticket that includes the configuration/query ID for the Sheets query, and screenshots showing the difference between the results and the true value in MailChimp for that list.

    -Thank you

    Supermetrics Support

Login to post a comment