Learn about our newest features and enhancements!
Contacts: Relationships & Connections
Authored by: Megan Gill
on 4/24/2024 2:44:00 PM

Introduction

Managing and awareness of relationships and connections among people are important for non-profits as they cultivate donor engagement. Within the CharityEngine CRM, we make it easy to create, manage, and view connections and relationships. Managing these connections with in CharityEngine can reflect simple connections such as personal (children of parents, familial relationships), social (member of a specific social group). These reflect individual connections between people or with a person's interaction with an organization. In addition to connections, CharityEngine also supports relationships in which people are connected, but are also part of a similar giving group - these most frequently include spouses who are part of a household or employees who are connected to a organization. In these relationships, CharityEngine offers summary giving information to easily see household giving totals across all household member - or easily viewing total organization giving including employee giving.



Prerequisites

Understanding the usage and functionality of relationships vs. connections is an important element of consideration for your organization. Please familiarize yourself with the reporting structure, how connections and relationships are presented in contacts and downstream reporting.

Connections:

  • Connections are defined as a connection between two people, a person to organization, or organization to organization.
    • System connections include:
      • Parent and child
      • Sibling
      • Spouse (without a household connection)
      • Friend
    • Connections are designed to connect people together for greater visibility of how connections may interact with your organization
    • Connection's financial giving are not connected in the way that is reflected with Households and Organizations with Employees (aka members of a household or members of an organization)

Relationships (or Members of Household/Organization):

  • Relationships are defined also as connections between people, person to organization, or organization to organization. However, through the following relationship types, individuals or organizations are considered members and their collective financial giving totals will be reflected individually but also collectively under the household record or the organization record.
    • System relationships (i.e. member of...) include:
      • Head of Household as a member of a household record
      • Spouse as a member of a household contact record
      • Employee as an employee of an organization
      • Subsidiary of an organization
    • Relationships (i.e. member of...) are designed to connect people while also reflecting the total giving values of those members
    • Relationship's (i.e. member of...) financial giving are connected and are reflect within Household and Organization giving totals
Because of the financial giving connections within relationships, it is import to carefully consider your organization's usage of connections vs. relationships (i.e. members of...).

Instructions - Creating a Connection

Step 1: Navigate to the Connections App > Organizations & People > Contacts > locate your contact > use the Eye icon or ACTIONS: Manage to manage the record

Step 2: Click on Add in the top right corner > click Connection

Step 3: In the pop-up box, click Assign Contact and complete look up to locate your connection

Step 4: From the Relationship drop down, select the connection's relationship type. Optional - select start/end date. Click CREATE to secure your changes.

Step 5: The contact's connection will now appear within the Connections panel.

Please note, a contact can many connections.

Sample view of the reciprocal contact record:


Instructions - Creating a Household and Relationship (i.e. members of...)

Please see our article Contacts: How to Create and Manage Household Contact Records for a comprehensive view and understanding of household management and gift reporting.


Instructions - Relationship Reporting

You can also review, filter, report, and export relationships through our listing screen.

Step 1: Navigate to the Contacts App > Relationships > Go

Step 2: Use the Quick Filters and/or Advanced Filter to narrow filtering results

Step 3: Use the Export (4 square icon) or use the Report Builder (graph icon) to create and schedule/distribute reporting


Please note, from this listing screen, a user can select one or more relationship and navigate to the drop down in the listing screen to bulk Delete relationships.


Instructions - Relationship Reporting via Queries

For advanced reporting needs, relationships can also be used within queries.  Navigate to the Automation & Workflow App > General > Queries > Create New > using Filter: Contacts > Select: Relationship (scroll down).

Use Case - Locating all people connected to an organization

Outcome: Locate all 'related contacts' (or connections) with a primary organization


Step 1: Navigate to the Automation & Workflow App > General > Queries > Create New > Filter: Contacts > Select: Relationships

Step 2: Add required fields for the report by dragging into the SELECT section

Step 3: Add (Primary Contact) Full Name to the FILTER section

Step 4: Click RUN to return results

Note: In this use case, if the outcome is to locate members and exclude employees, Type Id = 13876 could be add as an ADD filter.

Note: To obtain the total giving for this year, last year, or 2 years ago, or lift time giving totals of the person, this query can be used as a subquery leveraging the "Related Contact ID" (as a 'is located in' = this query)


Instructions - Locating & Managing Relationship Types through Configuration

For advanced management of the organization's connections, users can customize through the Configuration App.

Step 1: Navigate to the Configuration App > Relationships > Relationship Types

Step 2: In the Quick Filter, select System to see out of the box connections and relationships.

Step 3: To create a custom relationship structure click Create New

Step 4: Create a Name, select Group, select Class, Create Opposite Type name, select Opposite Type Class

Step 5: Click SAVE to secure the change

Note: Certain relationships will not require the use of an "Opposite Type". For example - relationships such as "Friend" or "Cousin" are a 1:1 relationship type. Whereas a "Child" has an opposite relationship type of "Parent".

Outcome:


FAQs & Additional Information

Q. Can I bulk import/append relationships to existing contact records?
A. Yes - learn more here at Importing Relationships



Related Articles

Powered by Powered By CharityEngine