Clubs frequently want to send emails to specific groups of members — all unpaid accounts, for example, or a group of Wait List accounts who are being offered membership. Mailchimp allows you to create segments of your list based on various criteria. The segments can be auto-updating so that something like a segment based on payment status will change in real time as your members make payments.


Before we explain how to create segments we offer one piece of advice: Do not try to overly target your emails! Many of our clubs have lots of account types and variations thereof. 


Examples: They might have Equity members; Equity members who still owe a balance on a bond; Equity members who have opted to be inactive for the summer; etc. 


The more specific and complicated you make your segments the greater chance there is of it not getting to the people you intend. Our strong advice is to keep the segments fairly broad and put a note at the start of the email indicating that the following email may not apply to you. 

As an example, here at Member Splash we get an email statement from our electric company every month that begins “If you have already paid your account this month please disregard this notice.”


Create a Segment

  • Login to Mailchimp
  • Go to Audience/All Contacts
  • Click the Manage Contacts drop down and select Segments


Click on Create Segment to start defining the filters for it. Mailchimp gives you the option to filter contacts based on those contacts meeting ALL of the specified conditions or ANY of the specified conditions. This is an important restriction because it means you can’t readily filter by members who belong to Account Type One OR Account Type Two AND are unpaid. Depending on the number of account types you have you can frequently work around this by choosing ALL as the matching logic and then looking for members who are unpaid and are not account type X and are not account type Y.

Mailchimp supports up to five filter conditions which may not be enough to achieve as fine-grained a segment as you intended. For example, if you have 10 account types and you wish to send a message to all unpaid members belonging to two of those account types you aren’t going to be able to use the method above. 

  • One option is to create two segments, one for each of the account types, and then send the email twice (send to segment A, then duplicate and send to segment B). 
  • A second option would be to use the trick above filtering out account types that definitely shouldn’t get the email — like Wait List — and then noting at the start of the email which account types it does apply to. 

Again, this is much simpler to manage on your end and ensures that all members who are supposed to get the email do and those it doesn’t apply to understand that and aren’t confused.


Find the Member Splash Account Type ID

Account Types are stored in Mailchimp using the Member Splash Account Type ID number instead of the Account Type Name because Mailchimp restricts the length of the custom values you can synchronize and this way if you change an account type name at some point your segment will still function correctly. Let's find the Account Type ID:

  • Login to your website Admin dashboard

  • Go to Membership/Accounts



  • Click Settings Button



  • Click Manage Account Types tab to see each of the Account Type IDs.
  • Go back to Mailchimp Segments

Once you have selected the various filters for your segment hit the Preview Segment button. It will show you how many members match the criteria as well as a list of each member and their details. If everything looks correct you can save the segment or hit edit to make further changes.