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
    April 06, 2023 15:00

    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
    November 16, 2021 15:44

    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
    July 20, 2021 17:41

    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
    March 29, 2021 21:14

    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
    August 27, 2020 14:47

    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
    May 10, 2019 19:30

    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
    May 02, 2019 18:18

    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
    May 02, 2019 14:11

    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
    May 02, 2019 14:09

    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
    May 02, 2019 14:05

    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
    May 02, 2019 13:43

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