Common Lists

Created on:
Updated on:

If you want to set up some common lists to give you experience in creating a list, or if you want to know which lists you might need, follow the steps to create some of our most commonly requested lists.

In addition to these lists, you can create list based on information in Check-Ins, Giving, and Groups, as long as you have access to those products.

Personal Information

Birthdays

If you want to view birthdays for people in your account, create a list looking for birthdays from the Personal tab.

When you set the month to Current, you can view this list at any time and see who has a birthday in the month you're currently in.

birthdays_current.png

If you send birthday cards every Monday, use in the next week. Every time you refresh the list, you'll see anyone that has a birthday in the next seven calendar days.

birthdays_in_the_past_week.png

Follow the same logic to populate the list with people based on when you send birthday cards and add any additional conditions to filter whose birthdays you can see.

Once you run the list, use the Birthday Report to get a printout of their name, birthday, and address sorted by birthday.

From the Results tab, click the print icon.

print_list_arrow.jpeg

Select Birthday Report and choose to print a pdf or view it as a webpage.

birthday_report_arrow.jpeg

You could also send them an email or print mailing labels to send them a birthday card!

Blocked Email Address

If you want to make sure the email addresses in your database are able to receive emails, use a list to find out which ones are blocked.

blocked_email_address.png

Once you find the ones that are blocked, you can follow the steps to unblock them.

Check School Grades

Some Check-Ins locations are filtered by grades, but not all students have their grades on their profile. Make sure students have their grade on their profile by creating a list.

check_school_grades.png

Make sure the schools are set up in your database, so you can choose which school to assign them to.

Contact a Child's Parent

You can contact parents by sending an email right from a list or by creating a report of the parent's information.

Create a list searching for kids in your database.

all_children_numbered.jpeg
  1. Set the first condition to Child.

  2. In case you haven't set that field on everyone yet, add an extra condition to look for people ages 17 or younger.

  3. To see people that meet either of these conditions, set the rule to return people matching any condition.

Tip

To gather a list of parents, choose household adults or primary contacts from the My list should include dropdown. Your results will then be adults, and you can send an email to them.

Once you submit the list, click the print icon from the Results tab to create a report with parents and children.

print_list_arrow.jpeg

Select the Primary Contact Information list from the dropdown, and then click Generate.

modal_primary_contact.png

The report will list the child in the first column, and all additional columns are about the primary contact of their household. In order for this report to return data, each child must belong to a household, and the household must have a primary contact with contact details.

report_contact_info.png

If a child is in two households, they will show two rows, each showing the primary contact of the household; children with no households have blank rows.

List of Parents and Children

If you're looking for the parents and children of a specific grade level, you'll need to create a couple of lists.

The first list finds the children of that grade level.

parents_and_children_1.png

The second list finds the parents of the children in the first list.

parents_and_children_2.png

The third list is a mixture of both in order to get a list of both parents and children.

parents_and_children_3.png

Caution

Do not set this list to auto-refresh.

When lists are dependent on each other, they need to be refreshed in the order they were created. You can't refresh the list of lists until the others have been refreshed.

Mailing Labels for a Household

You may want to send a letter to entire households, so set up your list and include household adults.

household_adults_arrow.png

From the Results tab, click the print icon.

print_list_arrow.jpeg

To print labels for the household, select the Avery labels with the Household Name.

address_labels.png

Your labels will export with the household name and their addresses.

report_household_label.jpeg

Tip

If you want to address the two oldest household adults instead of individuals or the whole household, use the Couples option. The report looks for the married male and puts him first, and then the married female. So, in order for the report to work correctly, please ensure the following:

  1. Make sure households only have two Adults, the legal guardians of the household.

  2. Make sure those two Adults are also set to Married.

  3. Make sure those two Adults have Male or Female assigned.

  4. Make sure the Primary Contact for the household is one of the two adults.

  5. If you have Adults that are children, separate them into their own household.

    If a person can legally sign a document, they should be in their own household.

The report searches through the Adults in the household. If there are three or more Adults in the household, the report will show "The [Household Name]" instead of individual names.

Married but Missing Anniversary

Make sure your married couples have their anniversary on their profile, so you can celebrate it!

married_but_missing_anniversary.png

Once you have their anniversary, run a report to see all anniversaries.

anniversary_report.png

People Grouped by Households

To show a list of people grouped by their household, create a list and click the print icon from the Results tab.

print_list_arrow.jpeg

Select the Household Report.

household_report_arrow.png

When you run the report, you'll have sections of people based on their household with their contact information and birthday listed.

report_household_directory.png

Tip

If you want the Household Report to print out alphabetically, make these changes:

  • From the Rules tab, choose to include the Primary Contact Only

  • From the Results tab, sort the list by Last Name before printing.

People Who Live on the Same Street

If you want to see all the people who live on the same street, you can create a list to show anyone who lives on the same street.

people_who_live_on_the_same_street.png

Once you have this list of people, you can send them an email or add them to a group.

Profile Cleanup

Once of the most difficult parts of maintaining a database of people is keeping their information clean and up to date. To quickly see if you need to input data on a person, create multiple auto-refresh lists and put them in a Profile Cleanup category.

Set the rule to exclude the information, so the rule searches profiles missing the listed information.

exclude.png

From your list, click a name to go to their profile.

Update the missing information on their profile, and then click Next to be taken to the next profile on this list.

playlist_add_phone_number.gif

Put the list in the Profile Cleanup category, and set to auto-refresh, so it updates with any people every night.

auto-refresh_arrow.png

As you create lists and assign them to the Profile Cleanup category, you can filter to that category and see if you need to take any action on people in those lists.

profile_cleanup_category.png

Activity

No Recent Activity

Many churches want to know the last time someone participated in a part of their church. The type of list you set up depends on which products you're using and how you're using them.

For example, if you're using Check-Ins but don't physically check in adults because you use Headcounts instead, you'll need to use a different product to find out who has been missing.

Find people who haven't attended, given, or served by setting up your list like this:

no_recent_activity.png

Set up the filters and timeframes based on the specific information you want to capture, based on attendance at events, giving, or serving.

Once you run the list, set it to refresh every night and create an automation to send them to a workflow where you can quickly follow up.

Missed Services

If a person attends and starts missing services, you know it's time to follow up with them! Create a list showing you who has attended before but has missed a couple of weeks in a row.

missed_services.png

Send these people an email or add them to a workflow to assign others to follow up with them. Set it to auto-refresh so you have the most accurate information!

Active People

If you want to find people in your account whose profiles are set to Active, set up a list using the rule below.

active_people.png

This list is helpful when trying to create a directory of all of the active people in your database.

Search Workflows

View a list of people in a workflow based on the criteria of their cards in the workflow.

Once you've selected People from the first dropdown, choose a workflow from the list of workflows in the second dropdown.

search_workflows.jpeg

Select the criteria for which cards you'd like to see in the list, and then create anautomation, send an email, or export the list.

Authorized Application (like Church Center!)

If you've given access to Planning Center mobile apps or allowed other applications to access the Planning Center API, you can see which people have been using those applications.

authorized_application.png

You could even change include to exclude if you want to see those who are not using the application.

If you're looking for information about a group of people, and you have access to Check-Ins or Giving, check out their Common Lists.

If you know of a list that should be included among these Common Lists, email us! And if you want to create some more processes to make your job easier, check out our Common Workflows!

Was this article helpful?
9 out of 15 found this helpful