Salesforce Nonprofit-Cloud-Consultant - Salesforce Certified Nonprofit Cloud Consultant (SP25)

After migrating to a Nonprofit Success Pack (NPSP) Salesforce org, it's essential to ensure that all migrated Accounts are consistent with the chosen account model. The Data Quality Analysis Dashboard is a vital tool for this purpose.

Data Quality Analysis Dashboard:

This dashboard provides comprehensive insights into data quality across the org.

It helps identify inconsistencies, missing data, and discrepancies in Account records.

Steps to Ensure Consistency:

Run the Data Quality Analysis Dashboard:

Navigate to NPSP Settings and select the Data Quality Analysis Dashboard.

Review the results to identify any Accounts that do not conform to the expected account model.

Address Identified Issues:

Correct any identified discrepancies by updating the Account records to align with the chosen model (e.g., Household Account Model).

Regular Monitoring:

Schedule regular runs of the Data Quality Analysis Dashboard to maintain data integrity over time.

Benefits of Consistency:

Ensures accurate reporting and analytics.

Improves data integrity and usability across the organization.

Facilitates better donor and constituent management.

Complementary Tools:

While the Data Quality Analysis Dashboard is primary, tools like the NPSP Health Check Tool and Salesforce Optimizer can provide additional insights into overall org health and performance.

To address the VP of development's needs:

Review Existing Dashboard: Start by reviewing the existing components on the NPSP Development Forecasting dashboard. This provides a high-level view of the current giving pipeline.

Create Additional Reports: Develop new reports to track program metrics and compare them to donor histories. These new reports should capture the necessary program data.

Edit Dashboard: Modify the existing dashboard to include the new components that reflect the additional program data and metrics.

This approach leverages the existing infrastructure and enhances it to meet the organization's specific needs.

The correct order for importing data into Salesforce, considering multiple mailing addresses for donors, is:

Account: Import accounts first to establish the primary records.

Address: Import address records to link them to the appropriate accounts.

Contact: Import contacts next to associate them with the correct accounts and addresses.

Campaign: Import campaign records to track the event (gala) details.

Opportunity: Finally, import opportunities to record the donations linked to the appropriate contacts and campaigns.

This order ensures data integrity and correct relationships between the imported objects.

To categorize donors into Gold, Silver, and Bronze based on the total gift amount for the year, the NPSP Levels feature should be utilized. This feature allows the organization to automatically categorize donors based on specified criteria.

Define Levels in NPSP:

Navigate to NPSP Settings > Levels.

Create three new Levels: Gold, Silver, and Bronze.

For each Level, specify the range of the total gift amount for the year. For example:

Gold: $10,000 and above

Silver: $5,000 to $9,999

Bronze: $1,000 to $4,999

Configure Level Criteria:

Set the criteria for each Level to be based on the "Total Gifts This Year" field.

Ensure the system is tracking the total gifts correctly by verifying the Customizable Rollups settings.

Assign Levels to Donors:

The system will automatically evaluate donors and assign them to the appropriate Level based on their total giving for the year.

This categorization can be used in reports, dashboards, and donor segmentation for targeted communication and recognition.

When implementing a Salesforce marketing automation solution, it is crucial to understand the nonprofit’s overall marketing objectives and strategy first. This foundational question will guide the consultant in aligning the marketing automation tools with the nonprofit's goals and ensuring the solution supports their broader mission. Knowing the marketing objectives and strategy will also help in tailoring the solution to effectively target the right audience, measure success, and adjust tactics as needed.

To meet the requirement of sharing client assessments, notes, and alerts among staff within the nonprofit using Nonprofit Cloud Case Management, the following approaches are recommended:

Create a Public Group:

Create a Public Group that includes all staff members who need access to the client information.

This group will be used to grant shared access to the relevant records.

Steps to Create a Public Group:

Go to Setup.

Enter "Public Groups" in the Quick Find box and select it.

Click "New Group" and add the necessary staff members.

Create Sharing Rules:

Set up sharing rules for the Assessments, Client Notes, and Client Alerts objects to share these records with the Public Group.

This ensures that any updates or new records created within these objects are automatically shared with the staff group.

Steps to Create Sharing Rules:

Go to Setup.

Enter "Sharing Settings" in the Quick Find box and select it.

Select the relevant object (e.g., Assessments).

Click "New" under Sharing Rules and define the criteria and target group (Public Group created earlier).

These steps ensure that relevant client information is shared with the appropriate staff, enhancing collaboration and service delivery.

Customizable Rollups in NPSP provide a flexible way to manage rollup calculations for donations and other records. However, once Customizable Rollups are enabled, the action is irreversible. This means you cannot revert to the standard rollup settings after enabling Customizable Rollups.

Steps to Enable:

Enable Customizable Rollups:

Navigate to NPSP Settings -> Donations -> Customizable Rollups.

Enable the Customizable Rollups feature.

Configure Rollups:

Set up the necessary rollup rules and configurations to match the nonprofit's data tracking and reporting needs.

To ensure that a deceased donor no longer appears on any mailing lists, the nonprofit organization should select the "Deceased" field on the donor's contact record. Here’s how to do it:

Navigate to the Contact Record:

Go to the Contacts tab in Salesforce.

Search for and open the donor’s contact record.

Select the Deceased Field:

Locate the "Deceased" checkbox on the contact record.

Check the box to mark the contact as deceased.

Verify Exclusion from Mailing Lists:

Ensure that automated workflows and processes exclude contacts marked as deceased from email and mailing lists.

Review and update any relevant segments or mailing lists to remove the deceased donor.

This action preserves the donor’s history in Salesforce while ensuring they are no longer included in future communications.

For a nonprofit offering courses that grant teachers credit toward maintaining their teaching certification, the Program Management Module (PMM) is the best solution to track course completions and credits awarded. PMM allows the nonprofit to manage program enrollments, track progress, and report on outcomes effectively.

Steps:

Set up the Program Management Module to include the specific courses offered and the credits awarded for each course.

Create Program Engagement records for each teacher enrolling in the annual cohort, linking them to the relevant course modules.

Track the completion of course modules and update the credits awarded to each teacher within their Program Engagement records.

Use custom reports and dashboards to monitor progress, track completions, and generate reports on credits awarded to teachers.

When a corporate matching gift is received and the original donation was not marked to be matched, you should use the "Find Matched Gifts" functionality:

Navigate to Find Matched Gifts:

Go to the donation record in Salesforce.

Select "Find Matched Gifts" from the related options.

Find More Gifts:

Click on the "Find More Gifts" button to search for the original donation that matches the corporate gift.

This tool helps to locate and link the matching gift to the original donation, ensuring both donations are accurately recorded and associated.