Thanks for the precious help.
1 answer
From my understanding of MailChimp, a Rating is given to each Subscriber based on their list and therefore one lead or contact could have multiple Ratings since they could be on multiple lists within Mailchimp. Looking at one subscriber in my test Account, I can see that a Subscriber has 2 stars based on one list and 4 stars on the other list.
In addition, the MC Subscriber object which is installed with the MailChimp application has no connection to a Lead or a Contact actually. The only connection is the email address which is what the MailChimp app uses to display the Visualforce page on the Lead or Contact record for the MailChimp subscriber records.
Unless your Leads are only ever on one list, you would have to determine which Rating wins (i.e. the highest, the lowest, the one with the most recent activity?) in order to update the Lead Rating however standard workflow would not work in this case. You would definitely need Apex in order to accomplish this requirement or possibly leverage the MailChimp API in order to get the desired outcome.
