Williams Syndrome Update Mar '23

WSA Membership - Sample Page

Suggestions for Member Management

  • Create a Flow that automatically expires members when their end date is passed.
  • Update the workflows to automatically send 30- and 10-day email reminders to renew to members.
  • With so many members -- and the fact that we no longer have tiers of members, it may be more efficient to have an annual renewal drive every year, asking members to update their information through a link in an email.
  • Delete the Update this Record field. Unless there is a frequent and ongoing updating process, these checkboxes are not relevant.

Contact Report: All Members, all fields

  • Excluded the deceased Members
  • 8,214 Members
  • Members with End Dates before Today: 3565 (only three marked as Expired)
  • Members with End Dates after Today: 5200
  • Contacts not empty - all
  • Emails Missing: 1,598 (6 have emails on the contact record but not Membership)

Anonymous Households Issue

Jessica Burr is not in the household, but there is a donation that is...

Teresa Rouillard Donation 2017.09.07 2017 New England Walk for Williams | Salesforce

How did this get to Jessica Burr's old household? It's a mystery!
All the contact

Putting Contacts into Households...

Looks like a couple with a son...but which one is correct?

And the Duplicates!

GoTo

Add the missing household members next.

Luckily, they all have the same address, so it's easy to place them. This is not always the case.

March 9, 2023 - Spreadsheet from Beginning to Record number 2078 - Time 2hr45 mins--- at this rate, we have 25 more hours of work on this.

Total number of records (not all of these are a problem) 18,810

Total contact records in the system: over 76,000