Householding is the process of grouping people who live in the same house or apartment. Households are primarily important for direct mail. It also helps you understand the relationships between people more concretely, allowing door-to-door canvassing and making phone calls more effective.
- Turn on householding
- Understand household rules
- Export filter by households
- View past household filter exports
- View households on a list
- Split list by households
- Export list by households
- Related HOWTOs
- Issues & suggestions on our radar
Turn on householding
To turn householding on in your nation, go to Settings > Defaults > Basics. Check the box next to "Enable householding" and click the button to save your changes. There is no charge for this feature.
Understand household rules
- Your database finds households based on a person's primary address.
- If more than twenty people have the same address, they will be listed separately. We assume this is an apartment building or other locations with people who would need their mail addressed separately.
- A person's address must have a street number, street name, and postal code in order for a household to be generated.
- When you export by household, the name field will be determined by the number of people in the household and their last names.
- Two people with same last name - first names sorted alphabetically, e.g. "Bob and Sally Giraffe"
- Three or more people with the same last name - The Last Name Family, e.g. "The Giraffe Family"
- Two or three people with different last names - list names, sort alphabetically by first name, e.g. "Sally Giraffe and Thomas Chan"
- More than three people with different last names - "Residents"
Export filter by households
You can use a filter to export households. When you are ready to start filtering from the People section, click on the "Household view" icon.
Click the "filter" icon and add the criteria. Before you filter, check the number of residents you want matched to your filter criteria.
When you're ready to export, click on the "Actions" drop-down menu in the top right-hand corner, and select "Export."
You'll be redirected to People > Exports where you'll find your exported file. You will know when the export is complete once a link to the file is created in the "File" column and you see a timestamp of when the job completed in the "Finished" column. The "Finished" column will indicate the percentage and number of households processed out of the total count until completion. If this is a larger file, the job can take longer to complete.
View past household filter exports
You can view past household filter exports from People > More > Exports. The household exports are indicated by the household icon. The word "household" will also be included in the file name.
View households on a list
In the People section, click on "Lists" and a drop-down will appear of all existing lists. Click on a list and select "Households."
At the top of the screen you'll see how many households are on your list. You also have the option of adding people to the list who live in the same household as a list member. The yellow button will give you the option to "Add X in households to list," where "X" is the number of people who will be added. If you add them to the list, the yellow button will then grey out and you'll have the option to "Remove X in households from list." This will only remove the people who were not originally on the list. If both buttons are greyed out, your list contains all members of households on the list.
The households in your list are displayed. Some, perhaps most, households on your list will have only one resident. Here is how a household with four residents appears on my list:
On the left side, you can see how the household name appears - in this example, because four people with different last names have the same primary address, the name given is "Residents." On the right, you'll see a list of people who live at the address. You can click on a person's name to go to that person's profile. Within a profile, the "Relationships" section lists all the people who live in the same household and gives you the option of saving a new relationship between household members.
Split a list by households
You can split a list by household to keep all household members together.
Select the "Households" option in the "Split by" section to keep households together. Then, decide whether to split the list in equal parts or by percentage. Percentages are written without percentage signs and are separated by a comma (e.g. 10, 40, 50).
Export a list by households
When exporting a list, you can choose to export people or households. A household export will contain one line per household and a person export contains one line per person. Previous exports will be displayed here - the house icon indicates a household export. "Household" will also appear in the file name of household exports.
Please note: people without a mailable primary address will be excluded from a household export. This means that the number of people included in a household export may be less than the total number of people on the list. If a person's address is formatted incorrectly or is not complete, that person will not be included in a household export.
Issues & suggestions on our radar
There are some issues related to householding that have come to our attention. We are monitoring their importance to the community on the product issues and suggestions page. You can follow each of the below issues to keep updated on their status.