We're a uni sporting club looking to use MailChimp for regular newsletter updates to our club members.
As part of this, we require the following additions to our Ruby-on-rails web-app which we use to manage members, trips, and a range of other related information.
MailChimp will have new members added to it automatically, along with updating the interests of existing members.
Any un-subscribe requests to MailChimp should be preserved when adding/updating subscriptions (eg. if someone re-joins some time later after their membership had expired and had previously unsubscribed, they should remain unsubscribed).
The interests of members will be based on the Activities (MemberTrip -> Trip -> Activity (a trip can be associated with multiple activities)) someone has attended in the last 12 months.
This change should not remove previous members which have since expired (Member.membership_expired = true), but should still update information (point...