Managing households in LGL
In this article:
- One for two: “Couple” records
- Two for one: Tracking the household
- Using contact type to keep your mailing list clean
- Setting up the “Primary” record for mailings
- What if I want to send mail to just John, rather than to the household?
- Gift entry for households: Soft-crediting the spouse for each donation
We're often asked if it is possible to track households in LGL. The short answer is to this question is, “Yes!” However, there are a couple different ways you can do it in LGL, and in this article we’ll talk through each of them.
One for two: “Couple” records
Let’s say you receive a check from a married couple. The check is in both of their names, and you want to add them to the database so you can enter their gift. In such a case, it's common to create a single record representing the couple. The data in this record may depend a bit on your own conventions, and also on the donor’s preferences for how they want to be addressed, but it might look like this:
Here we have added a first name with both names in it: John & Jane. And we have two pairs of addressee/label names and salutations, one of which is formal and the other, which is more informal. Keeping with your style for the names you include in letters and labels, you can set these up in whatever way is most appropriate. Some clients and donors prefer the more formal approach, and others prefer an informal one.
The advantage to tracking a couple as one record is that it simplifies donation tracking and mailings. You never have to worry about sending them the same letter twice, and soft-credits are unnecessary.
Two for one: Tracking the household
While tracking a couple in a single record is convenient, there are many cases when it just doesn’t cut it. Here are some common reasons to track the individuals in the couple in two separate constituent records:
- Both couples are involved with your organization in different ways—perhaps one is a volunteer and the other is a member of the board. Or they both volunteer, and you want to track their hours separately.
- They have different emails and you want to send email marketing messages to both of them, taking advantage of LGL’s integration with MailChimp or Constant Contact. This would force a split because only one email per constituent can be sync’d with MailChimp or Constant Contact.
- They both donate independently, with different names on the checks.
- You want to be able to track gender, birthday, and education information accurately.
- You have to split some constituents because of the reasons above, and you want to be consistent across the board.
Whatever the reason, this is where LGL’s householding features can help you save some time. Here’s what a “household” in LGL might look like:
In the database, they’d show up like this in a regular search:
On the surface, these two records look like two separate records. However, they have been tied together with a constituent relationship, which helps make managing address, phone, and gift entry a bit easier.
Learn more about how to set up relationships with address/phone sharing.
Using contact type to keep your mailing list clean
This is great for regular searching, but when it comes to preparing a mailing you probably don’t want both of these records in your list. That's where the contact type comes in. In the example above, we have the head of household, John Doe, coded as the “Primary” contact type. This is the default contact type for all constituents (unless you’ve changed things around); Jane Doe is coded with a “Spouse/Partner” contact type.
So, looking at this limited example, we can just add a “Contact Type = Primary” restriction to our query, and things will look good:
Setting up the “Primary” record for mailings
Using this strategy, the primary record is a bit special in that it serves to represent the household in a mailing, but the individual in all other capacities. To accomplish this, you can set it up so that the first name is the first name of the primary constituent, and then use the addressee/mailing label field in a broader sense. For example,
- Mr. & Mrs. John Doe
- John & Jane Doe
- The Doe Family
What if I want to send mail to just John, rather than to the household?
In cases where you want to maintain the ability to send mail to the Doe Family and John Doe individually, you can do that by using the “Alt. Addressee” and “Alt. Salutation” fields:
Traditionally, the [[addressee]] and [[salutation]] fields are used in the LGL mail merge process or in exports, but in both cases (mail merge and export) you can also use the [[alt_addressee]] and [[alt_salutation]] instead. When you do that, the system will look for those values if present, and then fall back to addressee and salutation if they are not. This gives you the ability to treat the head of household records in two different ways for any given mailing.
Gift entry for households: Soft-crediting the spouse for each donation
In addition to sharing contact information between primary constituents and their related spouses, it is also common practice to create soft credits for donations to related spouse records. So, if we get a check from John Doe for $100, it is a great idea to add a soft credit to Jane Doe’s record.
In LGL, you can do this very easily while entering the initial gift for John Doe using Related Gifts: