Pulling # of Households

For fundraising, events, and general "good to know numbers" - I would like to be able to pull the number of households we have in the school. Ex. 250 students, 160 households.

  • Susan Glah
  • Oct 21 2015
  • Implemented
  • Attach files
  • Admin
    Jessi Walters commented
    6 Apr, 2023 03:00pm

    The Households & addresses list in Core now meets this need, along with columns for each salutation type on the address that was marked a household!

  • Jason Whitaker commented
    16 Nov, 2021 03:44pm

    As of November 2021, there is now the ability to mark a household and enter a household salutation, but there is no way to pull that household field in a list or report. I've seen a couple of forum posts where users are generating a list and then manually grouping by address in Excel, but what is also needed here is simple way to pull households and the associated salutations for mailing purposes of one mailing per household.

  • Angela Addison commented
    20 Jul, 2021 05:41pm

    Hi folks! Doing a last call for schools that would like to participate in our Household EAP starting up. If you haven't already reached out to me and would like to get in on this please send me a direct message on the forum or to my email - angela.addison@blackbaud.com. Thanks! I will be finalizing the list and sending out instructions in the next week or so.

  • Angela Addison commented
    29 Mar, 2021 09:14pm

    Hello all, we are actively working on a household list feature and would love it if folks interested in household capabilities would take a short survey to help us hone in (and also at the end let us know if you'd like to participate in reviewing our in progress work and/or sign up to be part of an EAP!) https://app.handrailux.com/#/surveys/k9yyjk

  • Amy Hentschke commented
    27 Aug, 2020 02:47pm

    I would use household to mean an address where a custodial parent/grandparent/guardian lives. I'm not sure how best to determine that based on what we have available in contact cards. Maybe using the resides with check box? I would love to be able to pull a list of household addresses so we could send one mailing to each household.

  • Peggy McBean commented
    10 May, 2019 07:30pm

    I also use "household" or "family unit" for various metrics. My default terminology is "family unit" since a family can be composed of different households/addresses.   The definition I use consistently is based on the fact that a student can only belong to one.  The "family unit" may have more than one address and more than two parents/guardians.  I use this measure for assessing participation.  I do wish we had a a "family unit" (or some other name) designation/id per student so that we could quickly pull this group at the moment it is a bit of a work around to get the number. 

  • Claudia Gonzalez commented
    2 May, 2019 06:18pm

    Thank you Jeff and Charlie; we need to count households in the same way. That is, how many different parental households exist in our student body. Each household may have more than one child, in the case of siblings, AND the same household could be part of two separate family records, in the case of mixed families.

  • Guest commented
    2 May, 2019 02:11pm

    What would be useful to us is a count of the number of address records that are attached to a student's parent relationships. In most cases, this would be one, but there could be multiple households in case of divorce and/or remarriage. Hopefully I explained that clearly. Let me know if not. Thank you.

  • Guest commented
    2 May, 2019 02:09pm

    I would say a household is an address where at least one student either 1) shares an address or 2) has a 'parent' relationship with a resident that has the address. There could be filters for all of the parent qualifiers (signs contract/lives with student/list as parent/parental access).

  • Janet Wittenberg commented
    2 May, 2019 02:05pm

    Can you describe here how you would define a household? Based on shared addresses?  How many households can one student be a part of?

  • Guest commented
    2 May, 2019 01:43pm

    This seems like a really basic piece of information that a database should be able to provide.