Skip to main content

Understanding MemberSplash Segments in Mailchimp

Send an email to just part of your club, like unpaid accounts or your waitlist. Member Splash syncs your account info to Mailchimp, so you can filter your members right there.

Email a group of members with Mailchimp segments

Send an email to just part of your club, like unpaid accounts or your waitlist. Member Splash syncs your account info to Mailchimp, so you can filter your members right there.

Create a segment

  1. Click Audience, then Segments.

  2. Click Create new segment.

  3. Use the Select or search a filter dropdown to choose your first condition. See “Pick the right Member Splash field” below.

  4. To add more conditions, click Add filter.

  5. Click Review segment, give your segment a name, and check that the number of contacts looks right.

  6. Click Use segment to save it.

Your segment is saved, and Mailchimp keeps it up to date as your members’ info changes.

Pick the right Member Splash field

  • Account type name (ACCT_NAME): The account type as a word, like Family or Waitlist. This is the easiest one to use. To turn it on, go to Communications > Mailchimp > Sync Settings in Member Splash, toggle it on, and click Sync Now.

  • Account type ID (ACCT_TYPE): The account type as a number.

  • Member type ID: Each member’s role as a number, like Adult or Child. To find your account type and member type numbers, see How to find the Account Type ID and Member Type ID.

  • Account tags: Choose the tag, then set it to is yes (has the tag) or is no (doesn’t).

  • Billing contact: [verbiage pending test-site check]

  • Payment status: [verbiage pending test-site check]

Work around Mailchimp’s filter limits

On Mailchimp’s Free and Essentials plans, a segment can match all of your conditions or any of them, but not a mix. If you need something like “Family or Individual accounts and unpaid,” try one of these:

  1. Filter out instead of in. Choose all and exclude the account types you don’t want. For example: payment status is unpaid, account type is not Waitlist, and account type is not Senior.

  2. Send twice. Make one segment per account type, send your email to the first, then duplicate it and send to the second.

Clubs on Mailchimp’s Standard plan or higher can mix and and or in one segment.

💡 Tip: Keep your segments broad. Start your email by saying who it’s for, like “If you’ve already paid this month, please disregard this note.” That way nobody gets missed.

⚠️ Give it time to sync: After you change something in Member Splash, like marking an account paid or adding a tag, wait before you send. Mailchimp says new info can take up to 2 hours to show up in segments.

Did this answer your question?