Nonprofit-Cloud-Consultant Salesforce Certified Nonprofit Cloud Consultant (NPC) NP-Con-102 Questions and Answers

When the consultant encounters API call limit errors after switching the integration from a sandbox to a production environment, the likely explanation is:

Different API Call Limits for Sandbox and Production Environments:

Salesforce environments have different API call limits based on the type of environment and the organization's Salesforce edition. Sandbox environments often have higher API call limits for testing purposes, while production environments have stricter limits to ensure performance and reliability.

To track specific funds associated with gifts from individuals and organizations in NPSP, the consultant should create General Accounting Unit (GAU) records for each of the funds and associate them with the Opportunity by GAU Allocation record amounts.

Steps:

Log in to Salesforce: Access the Salesforce org with NPSP installed.

Create GAU Records:

Navigate to the App Launcher and search for "General Accounting Units".

Click "New" to create a new GAU record for each fund.

Fill in the necessary details such as GAU Name, Description, and any other relevant information.

Save the GAU records.

Associate GAUs with Opportunities:

Navigate to the Opportunity related to the donation.

In the Opportunity record, find the "GAU Allocations" related list.

Click "New" to create a new GAU Allocation.

Select the appropriate GAU record from the lookup field.

Enter the allocation amount and any other necessary details.

Save the GAU Allocation record.

Reporting: Use standard or custom reports to track and report on GAU Allocations for reconciliation with the finance system.

A Salesforce-recommended governance structure for nonprofit organizations ensures the implementation runs smoothly and effectively. It typically includes the following elements:

Release Management: This ensures that changes are systematically planned, tested, and deployed. It involves managing how new features and updates are rolled out to avoid disruption and ensure smooth transitions.

Rules of Engagement: These define how different stakeholders will interact with the system and with each other. It includes protocols and guidelines for communication, decision-making, and responsibilities.

Center of Excellence (CoE): This is a dedicated team or a hub of experts that provides leadership, best practices, research, support, and training. A CoE helps ensure that the organization is leveraging Salesforce effectively and efficiently.

To configure NPSP to send Apex error messages to a specific system admin, you should follow these steps:

Navigate to NPSP Settings:

Go to the App Launcher in Salesforce.

Type "NPSP Settings" in the search bar and select it.

Access System Tools:

In the NPSP Settings, locate the "System Tools" section in the left-hand sidebar.

Configure Error Notifications:

Under System Tools, select "Error Notifications."

Here, you will find options to configure who receives error notifications.

Set the Specific Admin:

Find the field where you can specify the user to receive error notifications.

Enter the username or search for the specific admin user you want to receive these notifications.

Save the settings.

By following these steps, you ensure that all Apex error messages are sent only to the specified system admin, effectively managing error notifications within NPSP.

To create a report showing how much each board member has raised, you should:

Use the Opportunities report type: This allows you to capture all gift data.

Add a cross filter for Contacts with Board Member = TRUE: This filters the report to include only those contacts who are board members.

Summarize the Total Gifts this Year and Soft Credits this Year fields: This provides the total amounts for direct gifts and influenced gifts.

This method ensures that both direct contributions and soft credits (gifts influenced by board members) are included in the report.

Creating a Campaign hierarchy is the most effective way to track funding for projects and monitor year-over-year goals in Salesforce. Campaign hierarchies allow for organizing campaigns in a structured manner, making it easy to roll up data and track progress across different levels. Here’s how to set this up:

Create Parent Campaigns for Years:

For each year, create a parent campaign. For example, "2023 Projects" and "2024 Projects".

Create Sub-Campaigns for Projects:

Under each yearly parent campaign, create sub-campaigns for each project. For instance, "2023 Projects" can have sub-campaigns like "Project A", "Project B", etc.

Link Sub-Campaigns to Parent Campaigns:

Use the Parent Campaign lookup field to link each project campaign to its respective year campaign. This establishes the hierarchy.

Track Goals and Progress:

Use Campaign fields to set goals and track actual amounts. Fields like "Campaign Member Status", "Amount Raised", and custom fields can be used to track the funding and progress.

Use roll-up summary fields to aggregate data from sub-campaigns to parent campaigns.

Reporting and Dashboards:

Create reports and dashboards to monitor the progress of each project and year-over-year comparisons. Use the Campaign Hierarchy feature in reports to show aggregated data.

By setting up a Campaign hierarchy, the foundation can easily track the funding, manage goals, and compare progress year-over-year.

"Campaign Hierarchies" from Salesforce Help: Campaign Hierarchies

"Managing Campaigns in NPSP" from Salesforce.org: Managing Campaigns

When encountering an error at run time indicating that a record couldn't be updated during a Customizable Rollup operation, it is often due to validation rules on the target field that prevent the update.

Check the Target Field for Validation Rules:

Navigate to Setup > Object Manager.

Select the object that contains the target field.

Go to Fields & Relationships and find the target field.

Review any validation rules associated with this field to ensure they are not causing the update to fail.

Modify or Disable Validation Rules:

If a validation rule is causing the issue, consider modifying it to allow updates during the rollup operation.

Alternatively, temporarily disable the validation rule, perform the rollup operation, and then re-enable the validation rule.

Test the Rollup Operation:

After addressing any validation rules, rerun the Customizable Rollup operation to ensure that the error is resolved.

Monitor the operation to confirm that the updates are processed correctly without triggering validation errors.

By ensuring that validation rules on the target field do not interfere with the rollup operation, the consultant can resolve the error and ensure smooth data processing.

To handle frequent imports of membership renewal and donation data, where each import needs a different configuration to update existing Contacts and create Opportunities, the NPSP Data Importer should be recommended:

NPSP Data Importer:

The NPSP Data Importer is specifically designed for nonprofits and supports complex data import needs, including updating existing records and creating new ones.

It allows you to map fields from your import file to Salesforce fields, ensuring data is correctly placed.

Set Up the Import:

Prepare your data in a CSV format.

Go to the NPSP Data Importer app in Salesforce.

Create separate templates for membership renewals and donations to handle different configurations.

Map Fields:

Use the mapping feature to map fields from your import file to the corresponding Salesforce fields.

Ensure that you map fields for Contacts, Opportunities, and any custom fields needed for memberships and donations.

Run the Import:

Upload your data file and run the import process.

Monitor the import progress and check for any errors or discrepancies.

Verify Data:

After the import is complete, verify that the data has been correctly updated and new records have been created as expected.

Check the updated Contacts and newly created Opportunities to ensure data integrity.

Salesforce recommends using V2MOM (Vision, Values, Methods, Obstacles, and Measures) with customers in the requirements-gathering phase of a project to achieve organizational alignment. Here’s how V2MOM helps:

Vision:

Define what you want to achieve. This provides a clear direction for the project.

Values:

Identify what is important about the vision and why it matters. This aligns the project goals with the organization's core values.

Methods:

Outline the steps to achieve the vision. This ensures everyone understands the approach and processes to be followed.

Obstacles:

Recognize potential challenges and how to address them. This prepares the team to handle issues proactively.

Measures:

Determine how success will be measured. This provides clear criteria for evaluating progress and outcomes.

Using V2MOM ensures that all stakeholders are aligned with the project’s goals, values, methods, challenges, and success metrics, fostering a unified approach to project execution.

Salesforce V2MOM Framework: Marc Benioff’s V2MOM

Salesforce Trailhead: Define Your Vision with V2MOM

If the Check/Reference Number field is not visible in the report builder, the consultant should check if there is a custom field named "Check/Reference Number" on the Payments object. Here’s how to proceed:

Verify Custom Fields on Payments Object:

Navigate to Setup.

In the Object Manager, select "Payment".

Click on "Fields & Relationships".

Look for a custom field named "Check/Reference Number".

Ensure Field is Included in Report Type:

Go to the Report Builder.

Verify that the report type being used includes the Payments object.

If the report type does not include Payments, create or use a report type that does.

Add Field to Report Layout:

In the Report Builder, ensure the "Check/Reference Number" field is added to the report layout.

Drag and drop the field into the columns of your report.

By ensuring that the custom field is present on the Payments object and included in the report type, the development associate can successfully add the Check/Reference Number to their report.

Salesforce Documentation: Custom Fields

Salesforce Trailhead: Create Reports with the Report Builder

The Program Management Module (PMM) in Salesforce is designed to help nonprofits manage their programs and services, including tracking participation in courses and training. PMM provides the necessary tools and features to capture and report on the various activities and outcomes associated with the programs run by the nonprofit.

Key Features:

Service Delivery Tracking: PMM allows for detailed tracking of services provided, including courses and training sessions.

Customizable Program Management: Nonprofits can configure PMM to meet their specific needs for managing programs and tracking participant engagement.

Steps to Implement PMM:

Install PMM:

Go to the Salesforce AppExchange and install the Program Management Module.

Set Up Programs and Services:

Define programs and related services within PMM to reflect the courses and training offerings.

Track Participation:

Use the PMM features to log and manage participant data, track attendance, and monitor outcomes.

For a large nonprofit that functions like a for-profit corporation and tracks funding exclusively from corporations, the Standard Account Model without NPSP is the most suitable choice. This model allows the nonprofit to manage Leads and track its Opportunity pipeline effectively, focusing on corporate accounts.

Benefits of the Standard Account Model:

Simplicity: The Standard Account Model is straightforward and designed for organizations that do not need the additional features provided by NPSP.

Corporate Focus: It is well-suited for managing corporate accounts and opportunities without the additional complexities of individual or household account models.

Steps to Implement:

Set Up Standard Account Model:

Use the default Salesforce setup for Accounts, Contacts, Leads, and Opportunities.

Customize as Needed:

Customize the standard objects and fields to align with the nonprofit’s specific requirements for tracking corporate funding.

For tracking funds received and allocated for grants, the Outbound Funds Module is the best solution. Here’s how to configure it:

Install the Outbound Funds Module:

Go to the AppExchange and search for the "Outbound Funds Module."

Click "Get It Now" and follow the installation instructions to add the module to your Salesforce org.

Configure Funding Programs and Grants:

Navigate to the "Funding Programs" tab to set up different programs that receive funds.

Create "Funding Requests" for organizations applying for grants and track the status and details of each request.

Track Funds:

Use "Funding Allocations" to track how funds are distributed to various grants. Each allocation record should specify the amount, date, and purpose of the funds.

Reporting:

Use standard and custom reports to track the inflow and outflow of funds, ensuring transparency and accountability in grant management.

To ensure full compliance with Salesforce best practices for data security, the consultant should use Salesforce Health Check. Here’s why:

Salesforce Health Check:

This tool provides a comprehensive security assessment of your Salesforce org by measuring its settings against the Salesforce recommended baseline.

It evaluates critical security settings such as password policies, session settings, and other security configurations.

Health Check provides a score and recommendations to improve the overall security posture of the org, making it a crucial tool for maintaining data security compliance.

Salesforce Health Check Documentation

Salesforce Security Best Practices Guide

Salesforce.org major releases are typically scheduled to follow Salesforce.com releases by about one month. This staggered release schedule allows nonprofits to prepare for updates and ensures that they can address any potential conflicts with their internal release schedules. The Salesforce.org release schedule is available on the SFDO Major Release Announcements group, which provides detailed information on upcoming releases and related resources.

Steps:

Inform the system admin that Salesforce.org releases follow Salesforce.com releases by approximately one month.

Direct the system admin to the SFDO Major Release Announcements group for the latest release schedule information.

Encourage the admin to plan internal releases accordingly to avoid conflicts with major Salesforce updates.

Stay informed about upcoming releases and leverage available resources to ensure smooth transitions.

Defining goals is crucial for any project, including Salesforce implementations. Goals help ensure that the project has a clear direction and measurable outcomes. Here are the reasons:

Measure and Prove Results (B):

Setting clear goals allows the project team to measure progress and success. It provides a benchmark against which results can be compared, helping to demonstrate the project's impact and value.

Define a Clear Purpose (C):

Goals help articulate the purpose of the project, providing clarity and focus. This ensures that all team members understand the objectives and work towards a common aim, reducing confusion and aligning efforts.

Enhanced Recurring Donations in NPSP allows nonprofits to manage recurring donations more flexibly, including making one-time adjustments to the donation amounts. This feature provides a robust way to handle scenarios where donors want to change their regular giving amounts temporarily.

Steps to Implement:

Enable Enhanced Recurring Donations:

Navigate to NPSP Settings -> Donations -> Recurring Donations.

Enable Enhanced Recurring Donations.

Set Up Recurring Donations:

Create a Recurring Donation record for the donor, specifying the regular donation amount and schedule.

Use the Enhanced Recurring Donations feature to adjust the schedule and amounts as needed.

Install NPSP:

Ensure that NPSP is installed in your Salesforce instance. You can download it from the AppExchange or install it directly from the NPSP Installer page​​.

Configure Acknowledgement Settings:

Navigate to NPSP Settings.

Under “Donations,” find the “Acknowledgements” settings.

Configure the settings to define when and how acknowledgements should be sent.

Set Up Email Templates:

Go to Setup > Classic Email Templates.

Create a new email template or modify an existing one to suit your acknowledgment needs.

Ensure the template includes merge fields to personalize the emails with donor information.

Create Automation with Process Builder:

Use Process Builder to automate the sending of acknowledgment emails.

Create a new process on the Opportunity object.

Set criteria to trigger the process when a new donation is recorded.

Add an action to send an email using the previously created template.

Testing:

Test the process by creating a test donation record and verifying that the acknowledgment email is sent automatically.

Monitoring and Refinement:

Monitor the process to ensure it is working correctly.

Refine the email templates and automation rules based on feedback and evolving needs.

By utilizing the NPSP, nonprofits can streamline their donation acknowledgment process, ensuring timely and personalized communications with donors, ultimately enhancing donor satisfaction and retention.

https://powerofus.force.com/s/article/NPSP-Configure-Data-Importer-Options

When loading a large volume of historical data into Salesforce, especially data spanning several years, it is common to encounter performance issues like the "Apex CPU Time Limit Exceeded" error. This error occurs because Salesforce processes each record with all active triggers, which can consume a significant amount of processing time.

Steps to Resolve:

Disable Trigger Handlers:

Navigate to NPSP Settings -> Trigger Handlers.

Uncheck the Active checkbox for all Trigger Handlers. This will temporarily disable the triggers, allowing the data to load without the additional processing overhead.

Load Da

To reduce manual data entry and improve efficiency when entering donation data into both Salesforce and an external accounting system, the consultant should recommend using the Accounting Subledger:

Accounting Subledger:

The Accounting Subledger in NPSP provides a way to sync financial data between Salesforce and external accounting systems.

It ensures that donation data entered in Salesforce is automatically available for reconciliation and reporting in the accounting system.

Setting Up Accounting Subledger:

Install and configure the Accounting Subledger from the AppExchange.

Define the mapping between Salesforce donation records and the corresponding records in the accounting system.

Set up integration rules to automatically sync data based on predefined triggers and schedules.

Benefits:

Reduces manual data entry by automating the transfer of donation data.

Ensures data consistency and accuracy across systems.

Provides real-time visibility into financial data for better decision-making.

By using the Accounting Subledger, the nonprofit can streamline its data entry processes and improve overall efficiency.

To create a custom Apex class in the TDTM (Table Driven Trigger Management) framework, follow these steps:

Create the Apex Class:

In Salesforce, go to Setup.

Navigate to "Apex Classes" under "Custom Code".

Click "New" and create your custom Apex class.

Ensure the class implements the TDTM framework correctly.

Create the Test Class:

Create a corresponding test class to ensure your Apex class functions as expected.

This is essential for maintaining code coverage and passing Salesforce deployment requirements.

Create a Trigger Handler Record:

Go to the TDTM Trigger Handlers tab.

Create a new Trigger Handler record and link it to your custom Apex class.

Define the order of execution and the object the trigger applies to.

These steps ensure that your custom Apex class is correctly integrated into the TDTM framework, maintaining organized and manageable trigger logic.

Salesforce NPSP Documentation: TDTM Overview

Salesforce Trailhead: Apex Basics & Database

To pull a report showing all students in the program and their primary parent/guardian with the parent/guardian's cell phone and email, the consultant should use the "Contacts with or without Relationships" custom report type:

Custom Report Type:

Create a custom report type for "Contacts with or without Relationships."

This report type allows you to include related records, such as relationships between students (Contacts) and their primary parent/guardian.

Include Relevant Fields:

In the report, include fields for the student (Contact Name), their primary parent/guardian (related Contact), and the parent/guardian's cell phone and email.

Use the Relationships object to link students to their primary parent/guardian.

Filters and Sorting:

Apply necessary filters to ensure only relevant records are included.

Sort and group the data as needed to provide a clear view of students and their primary parent/guardian information.

When using the NPSP Data Importer to upload data that contains payments on existing opportunities, and matching donations to existing records, the following updates may occur:

A Payment Will Be Added to the Opportunity:

When a gift is successfully matched to an existing Opportunity, a Payment record is created and associated with the Opportunity.

This reflects the new donation and updates the financial records accordingly.

The Opportunity Amount Will Include the New Payment Amount:

The total amount on the Opportunity will be updated to reflect the sum of the original amount and the new payment amount.

This ensures that the Opportunity accurately represents the total donations received.

These updates help maintain accurate and up-to-date financial records within Salesforce, reflecting all contributions accurately.

Salesforce NPSP Documentation: NPSP Data Importer

Salesforce Trailhead: Manage Donations with NPSP

If the NPSP 00 - Error Processing job is accidentally deleted, you can recreate it using the NPSP settings. Here’s how:

Access NPSP Settings:

Navigate to the App Launcher and search for "NPSP Settings".

Go to Bulk Data Processes:

In the NPSP Settings, find the "Bulk Data Processes" section.

Batch Process Settings:

Click on "Batch Process Settings".

Here, you can find options to recreate various batch jobs, including the NPSP 00 - Error Processing job.

Recreate the Job:

Follow the prompts to recreate the NPSP 00 - Error Processing job.

Save your settings.

By using the NPSP Settings to recreate the job, you ensure that the necessary error processing is back in place without needing to manually configure or contact support.

Salesforce NPSP Documentation: Batch Process Settings

Salesforce Trailhead: Nonprofit Success Pack (NPSP) Basics

To ensure that case managers gather all required information when qualifying new beneficiaries, Salesforce Flow is the most effective automation tool:

Create a Flow:

In Salesforce Setup, navigate to "Flow Builder" and create a new Flow.

Choose a "Screen Flow" to guide users through the data entry process.

Design the Flow:

Add screens to the Flow that contain fields for all the required information. Use validation rules to ensure required fields are completed before proceeding to the next screen.

Use logic elements like decisions and assignments to handle conditional data collection based on previous inputs.

Deploy the Flow:

Embed the Flow on the Lightning Record Page for case managers to use when qualifying new beneficiaries.

Ensure the Flow is easily accessible and part of the standard workflow for case managers.

Training and Support:

Provide training for case managers on how to use the Flow.

Monitor usage and collect feedback to make any necessary adjustments.

Salesforce Flow provides a guided, interactive way to ensure all required information is collected consistently.

https://trailhead.salesforce.com/content/learn/modules/program-management-with-nonprofit-cloud/manage-nonprofit-programs-with-salesforce

To track each program and the status of youth enrolled in the program using the Program Management Module (PMM) in Salesforce, the consultant should use the "Programs" and "Program Engagements" objects.

Key Features:

Programs: This object represents the various programs offered by the nonprofit. Each program can have multiple engagements and activities associated with it.

Program Engagements: This object tracks the involvement of individuals (youth in this case) in specific programs. It allows the nonprofit to monitor the status and progress of each participant within the program.

Steps to Implement:

Set Up Programs:

Navigate to the Programs tab.

Create records for each after-school program offered by the nonprofit.

Track Engagements:

Navigate to the Program Engagements tab.

Create records for each youth enrolled in the programs, linking them to the appropriate program and tracking their status.

When loading a large volume of data, such as 5 million donation history records, into Salesforce, it is essential to temporarily disable TDTM (Trigger Handler Framework) to ensure the data load is successful. TDTM triggers can slow down or interrupt the data load process due to the large volume of records being processed.

Steps:

Go to Setup > Custom Metadata Types.

Select "Trigger Handlers."

For each trigger handler, uncheck the "Active" checkbox to temporarily disable it.

Perform the data load using Data Loader or another data import tool.

Once the data load is complete, re-enable the TDTM Trigger Handlers by checking the "Active" checkbox for each trigger handler.

To load 45,000 records into Salesforce from a single flat file:

Data Loader: This tool is designed for bulk data import and export, handling large volumes of records efficiently. It supports complex data mappings and transformations required for importing donor, donation, and payment processing records.

Large Volume Handling: Data Loader can process up to millions of records, making it suitable for the task at hand.

Using Data Loader ensures that the records are imported accurately and efficiently, with the ability to handle data transformations as needed.

If the nightly NPSP batch jobs are taking significantly longer to complete, the system admin should consider the following factors:

A New Standard Roll-Up Summary Field Was Added to an Object:

Adding new roll-up summary fields can increase the processing time for batch jobs.

These fields require calculations that aggregate data, which can slow down batch processing, especially if they are based on high-volume objects.

A New Customizable Rollup Was Added in NPSP Settings:

Customizable rollups allow for complex aggregations and summaries across various objects.

Adding new rollups increases the processing workload for nightly batch jobs, leading to longer completion times.

Review and optimize the rollup settings to balance performance with data aggregation needs.

By considering these factors, the system admin can identify and address the root causes of increased batch job processing times.

Salesforce NPSP Documentation: Customizable Rollups

Salesforce Documentation: Roll-Up Summary Fields

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 a system admin attempts to delete a Household Account record that has Contacts with Affiliations, Relationships, and Closed/Won donations associated with it, Salesforce will prevent the deletion and display an error message. Here’s why:

Closed/Won Donations:

Salesforce prevents the deletion of records that have important related records, such as Closed/Won donations, to maintain data integrity.

Closed/Won Opportunities represent actual donations that are crucial for reporting and financial tracking. Deleting the associated Household Account would disrupt this data integrity.

Error Message:

Salesforce will display an error message indicating that the record cannot be deleted because of its associated Closed/Won donations. This safeguard ensures that critical financial data is preserved.

Salesforce Documentation on Record Deletion and Related Records

Salesforce NPSP Data Integrity and Protection Guide

To correctly upload donors' employment information into the NPSP Affiliations object, the data should be imported in a specific order. Here’s how to do it:

Insert Organization Accounts:

Start by inserting records for the employers (Organization Accounts).

Ensure each employer has a unique Account ID.

Insert Contact Records:

Next, insert the Contact records for the donors.

Make sure each Contact record has a unique Contact ID and is associated with the correct Account (if applicable).

Insert Affiliation Records:

Finally, insert Affiliation records to link the Contacts to their respective Organization Accounts (employers).

Include fields like Contact ID, Account ID (employer), and other relevant details such as role and status.

By following this order, you ensure that all necessary data relationships are correctly established in Salesforce.

"Managing Affiliations in NPSP" from Salesforce Help: Affiliations

"Data Import Best Practices" from Salesforce.org: Data Import

When migrating a large volume of contacts, accounts, and address records into NPSP, the following considerations are important:

Managing Multiple Addresses:

NPSP allows for multiple addresses per contact or account, which can introduce additional complexity in managing and maintaining these records.

It is essential to have a clear strategy for handling primary, mailing, and other types of addresses to ensure data consistency and accuracy.

Data Storage Consumption:

Each address record consumes additional data storage in Salesforce.

Nonprofits should be aware of their data storage limits and plan accordingly to avoid running out of storage space.

Consider archiving old or inactive address records to manage storage usage efficiently.

These considerations help ensure a smooth data migration process and ongoing data management within NPSP.

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.

To configure Accounting Subledger so that only the appropriate records are created and available for export to finance, you need to set up Stage to State Mapping. This ensures that only donations at a certain stage are included in the ledger entries. Here are the steps:

Access Accounting Subledger Setup:

Navigate to the Accounting Subledger settings in Salesforce.

Configure Stage to State Mapping:

Define the mapping between Opportunity Stages and Accounting Subledger States.

For example, map the "Closed Won" stage to a state that signifies the donation is ready for ledger entry creation.

Update Opportunity Stages:

Ensure that your Opportunity Stages are correctly set up to reflect the different states of your donation process (e.g., "Pledged", "Received").

Create Ledger Entries:

Once an Opportunity reaches the specified stage (e.g., "Closed Won"), a ledger entry is automatically created.

Only these ledger entries are included in the export to finance.

By configuring the Stage to State Mapping, you ensure that only finalized donations (those that reach a specific stage) are included in the ledger entries, making the finance export process more efficient and accurate.

Salesforce Accounting Subledger Documentation: Stage to State Mapping.

To avoid manually entering information twice and ensure it appears on both the Opportunity record and the Payment record, follow these steps:

Create Payment Mappings in NPSP Settings:

Navigate to NPSP Settings.

Go to "Donations" and select "Payment Mappings".

Create mappings to ensure that relevant fields from the Opportunity record are automatically populated in the Payment record.

Create Custom Fields on the Payment Object:

Navigate to Setup.

In the Object Manager, select "Payment".

Click on "Fields & Relationships".

Create custom fields that correspond to the Opportunity fields you want to map.

Ensure the field types match those on the Opportunity object to facilitate accurate data transfer.

These steps automate the data transfer between Opportunities and Payments, reducing manual entry and ensuring consistency across records.

Salesforce NPSP Documentation: Payment Mappings

Salesforce Trailhead: Custom Fields

V2MOM (Vision, Values, Methods, Obstacles, and Measures) is a framework used by Salesforce to align teams and ensure successful project outcomes. The recommended elements for a V2MOM include:

Vision:

Defines what you want to achieve.

It sets the direction and purpose of the project or initiative.

Example: "To increase donor engagement by 20% over the next fiscal year."

Metrics (Measures):

Describes how you measure success.

Includes quantifiable indicators that help track progress toward the Vision.

Example: "Number of new donors acquired, donor retention rate, total funds raised."

Values:

Although not explicitly listed as an answer option, values are an integral part of the V2MOM framework. They define what is important and guide the behaviors needed to achieve the Vision.

Methods:

Specifies the actions and steps needed to achieve the Vision.

Example: "Implement a new donor management system, conduct quarterly donor engagement surveys."

Obstacles:

Identifies potential challenges and how to overcome them.

Example: "Limited staff resources, data migration issues."

Inclusion of Metrics and Vision:

Metrics and Vision are critical as they set the overall goal and how success will be measured, ensuring clarity and alignment across the team.

To manage incoming donations, provide a portal for constituents and staff members, and create a new web experience for constituents, a consultant should recommend:

NPSP with Experience Cloud:

Experience Cloud (formerly known as Community Cloud) enables nonprofits to build branded portals for their constituents and staff. It facilitates creating a self-service portal, donation management, and community engagement all in one platform.

check the entity relationship diagram

When evaluating whether to use Program Management Module (PMM) or Nonprofit Cloud Case Management, it is important to consider the specific requirements of the nonprofit. While PMM can track programs, services, and the impact of those services, Nonprofit Cloud Case Management offers additional functionality tailored to human services nonprofits. Case Management includes custom objects specifically designed to track client goals and action items, making it more suitable for organizations needing detailed goal tracking.

Steps:

Assess the specific requirements for tracking client goals and action items.

Compare the features of PMM and Case Management.

Highlight that Case Management has a custom object for tracking goals and action items.

Discuss the benefits and potential limitations of implementing Case Management, including the need for Experience Cloud licenses if applicable.

To delegate authority to specific users for processing gift entries, the consultant should add the following permissions to a permission set:

Grant visibility to the Gift Entry tab:

This permission ensures that users can access the Gift Entry tab where they can process and manage gift entries.

Grant create, edit, and delete access to all required objects and fields:

Users need full CRUD (Create, Read, Update, Delete) access to objects and fields related to gift processing such as Donations, Payments, and any custom fields or objects involved in the gift entry process.

This level of access is essential for users to accurately record, update, and manage gift entries.

Grant access to BDI_BatchOverride and BDI_DataImport Visualforce pages:

These Visualforce pages are part of the Batch Data Import (BDI) functionality in NPSP, which is used for batch processing of gift entries.

Access to these pages allows users to override batch data and perform data imports necessary for processing gifts.

Salesforce documentation on Gift Entry permissions: Gift Entry Permissions

To create a report that shows Opportunity and General Accounting Unit (GAU) custom field data for gifts to the "General Fund" GAU and adds filters to show only the gifts connected to the "Annual Campaign," the consultant should use the "GAU Allocations with Opportunity" report type. This report type allows for filtering on both Opportunity and GAU Allocation fields.

Steps to Create the Report:

Select Report Type:

Go to the Reports tab and create a new report using the "GAU Allocations with Opportunity" report type.

Add Filters:

Filter on the Opportunity object for the Primary Campaign Source = "Annual Campaign."

Filter on the GAU Allocation object for General Accounting Unit = "General Fund."

Customize Report:

Add the necessary fields from both the Opportunity and GAU Allocation objects to the report layout.

Save and run the report to view the desired data.

When receiving a System.DmlException notification, the detailed information about the error can be found in the Error Log.

Error Log Overview:

The Error Log captures detailed information about system errors, including DML exceptions.

It provides insights into what caused the error and helps in troubleshooting.

Accessing the Error Log:

Navigate to Setup in Salesforce.

Search for "Apex Jobs" or "Apex Exceptions" in the Quick Find box.

Review the entries to find the relevant System.DmlException details.

Using the Error Log for Troubleshooting:

Identify the Cause: The log provides specific error messages and stack traces that help identify the root cause of the issue.

Corrective Actions: Based on the error details, take corrective actions such as fixing data issues, adjusting code, or updating configurations.

Benefits of Using the Error Log:

Detailed Information: Offers comprehensive details about the error, making it easier to diagnose and resolve.

Efficiency: Reduces time spent on identifying and fixing issues by providing precise error information.

For a nonprofit organization seeking a multi-channel marketing tool that encompasses email, social media, and text messaging engagement, Salesforce Marketing Cloud is the recommended solution. Marketing Cloud provides comprehensive tools for creating, managing, and analyzing campaigns across multiple channels.

Email Marketing:

Design and send personalized emails to supporters.

Use Email Studio within Marketing Cloud for advanced email campaign management.

Social Media Engagement:

Utilize Social Studio to manage social media accounts, schedule posts, and analyze engagement.

Monitor social media conversations and engage with constituents.

Text Messaging:

Implement Mobile Studio for SMS and MMS campaigns.

Create and automate text messaging campaigns to reach supporters on their mobile devices.

Marketing Cloud's integration capabilities and robust analytics ensure that nonprofits can effectively track and optimize their multi-channel engagement efforts.

When encountering an issue while configuring Nonprofit Cloud Case Management, the consultant should first check Salesforce Help to see if it is a documented issue. Salesforce Help provides extensive documentation, release notes, and known issues, making it a reliable source for troubleshooting.

Steps to Check:

Salesforce Help:

Navigate to Salesforce Help & Training.

Search for the specific issue or error message.

Review any available documentation, known issues, and suggested resolutions.

Additional Resources:

If the issue is not documented in Salesforce Help, the consultant can also check the Trailblazer Community for discussions and solutions provided by other users.

https://powerofus.force.com/s/article/NPSP-Disable-Trigger-Handlers#ariaid-title3

When periodically importing a structured list of event registrations, it is crucial to ensure that the process is efficient and does not trigger unnecessary automation. Disabling TDTM (Table-Driven Trigger Management) for specific users is a recommended approach.

TDTM Overview:

TDTM allows for managing and controlling the execution of triggers in NPSP.

It provides flexibility to disable specific triggers or exclude certain users from trigger execution during bulk data imports.

Disabling TDTM for Specific Users:

By disabling TDTM for specific users, the import process can be streamlined without triggering unnecessary automation.

This approach ensures that data imports are efficient and reduces the risk of hitting system limits or performance issues.

Steps to Implement:

Navigate to NPSP Settings -> System Tools -> TDTM.

Add the usernames of the users who will be performing the imports to the "Usernames to Exclude" field.

Save the changes to ensure that TDTM triggers are disabled for these users during the import process.

Benefits:

Efficiency: Reduces the load on the system during bulk imports, ensuring faster and more reliable data processing.

Control: Maintains control over which triggers are executed, preventing unintended automation from affecting the imported data.

Additional Considerations:

Ensure that other necessary validations and processes are manually checked or re-enabled after the import if needed.

Monitor the data import process to ensure that it completes successfully without triggering unnecessary automation.

Understanding the trial experiences available on the Salesforce.org website is crucial for setting expectations and planning custom configuration work. Here’s detailed information about the trial options:

Available Trial Experiences:

Lightning Enterprise: This option provides a standard Salesforce Lightning Enterprise edition, suitable for exploring core CRM capabilities.

Lightning Enterprise + NPSP: This trial includes the Nonprofit Success Pack (NPSP) on top of the Lightning Enterprise edition, tailored specifically for nonprofit needs.

Free Trial Period:

The free trial period for Salesforce.org trials is 30 days. This provides enough time to explore features, gather requirements, and conduct initial custom configuration work.

Why Not Other Options:

Option A: While free licenses may be available for qualified customers, this is separate from the trial experience and not universally applicable.

Option D: The trial orgs provided by Salesforce.org are typically not Developer Edition orgs but are configured to showcase the Enterprise capabilities with or without NPSP.

By knowing that the trial choices include Lightning Enterprise or Lightning Enterprise + NPSP and that the free trial period is for 30 days, the consultant can effectively plan and execute the initial phases of the project.

Salesforce.org Trial Experiences Information

Salesforce Nonprofit Success Pack (NPSP) Documentation

When using Marketing Cloud Connect and enabling tracking, the type of data available for reporting using Salesforce reports includes Email Studio Send details. Here’s why:

Marketing Cloud Connect:

Marketing Cloud Connect integrates Marketing Cloud with Salesforce, enabling data synchronization and reporting.

This integration allows Salesforce to pull tracking data from various Marketing Cloud modules into Salesforce reports.

Email Studio Send Details:

Email Studio Send details include data such as email opens, clicks, bounces, and other email performance metrics.

This data is critical for understanding the engagement and effectiveness of email campaigns, and it is available for reporting within Salesforce.

Salesforce Marketing Cloud Connect Documentation

Salesforce Email Studio Reporting Guide

For entering a large number of contacts from a spreadsheet and creating related cases for each contact, the NPSP Data Importer is the best tool. It allows for configuring upserts (updates or inserts) for Contacts and linking them to related records such as Cases.

Steps:

Prepare the spreadsheet with the necessary data for Contacts and Cases, ensuring all required fields are included.

Open the NPSP Data Importer in Salesforce.

Map the fields in the spreadsheet to the appropriate Salesforce fields for Contacts and Cases.

Configure the importer to upsert Contacts and create related Cases based on the spreadsheet data.

Run the import process and verify the data in Salesforce to ensure all Contacts and Cases are correctly created and linked.

https://trailhead.salesforce.com/content/learn/modules/project-risk-management-for-partners/identify-assess-address-risk

In project management, the three elements impacted by change that cause risk are cost, quality, and time. These elements are often referred to as the project management triangle or triple constraint.

Elements Impacted by Change:

Cost: Changes can lead to increased project costs, affecting the budget and financial resources.

Quality: Changes can impact the quality of the project deliverables, potentially leading to rework or reduced standards.

Time: Changes can affect the project timeline, causing delays and extending the project schedule.

Steps for Risk Mitigation:

Identify Potential Risks:

Conduct a risk assessment to identify potential changes that could impact cost, quality, or time.

Develop Mitigation Strategies:

Create plans to mitigate identified risks, including contingency plans and resource allocations.

Monitor and Control:

Regularly monitor the project for changes and adjust plans as necessary to manage risks effectively.

https://powerofus.force.com/s/article/NPSP-Merging-Contacts

When using the NPSP Contact Merge functionality, any empty Household Accounts that do not have associated Contacts or Opportunities are automatically deleted. This is likely the cause of the reduction in the number of household accounts noticed by the system administrator.

Steps to Verify:

Check Merge Settings:

Review the settings and configuration of the NPSP Contact Merge process to understand its behavior regarding empty Household Accounts.

Review Audit Logs:

Check the Salesforce audit logs to see the details of the merge operations and confirm that empty Household Accounts were deleted.

Restore if Necessary:

If the deletion of empty Household Accounts was unintended, use data recovery options to restore any necessary records.

For a nonprofit organization providing case management and requiring automatic scoring of clients based on various factors like age, income, and health conditions, along with automating the creation and assignment of follow-up tasks, the best combination of functions is Engagement Plans and Levels.

Engagement Plans: These are used to automate the creation of tasks and follow-up activities based on predefined templates. This feature ensures that specific tasks are generated and assigned to relevant staff members as soon as certain criteria are met.

Steps to Set Up Engagement Plans:

Navigate to the "Engagement Plans" tab in NPSP.

Create a new Engagement Plan Template, defining the tasks and follow-ups that should be created.

Specify the conditions under which this Engagement Plan should be triggered (e.g., a new client intake).

Assign the Engagement Plan to the appropriate client records.

Levels: These are used to categorize clients (or any other records) based on numeric values or other criteria. In this case, Levels can be used to automatically assign a score to each client based on their age, income, and health conditions.

Steps to Set Up Levels:

Navigate to NPSP Settings > Levels.

Create a new Level, specifying the criteria for each level (e.g., age range, income bracket, number of health conditions).

Define the actions that should be triggered when a client reaches a specific level.

By using Engagement Plans and Levels, the nonprofit can automate both the scoring of clients and the creation of follow-up tasks, ensuring a streamlined case management process.

When setting up the process for importing lists of Contacts into Salesforce Campaigns using the NPSP Data Import tool, it is essential to consider how Campaign Members are created and matched.

Key Considerations:

Automatic Campaign Member Creation (A):

The NPSP Data Import tool will automatically create Campaign Member records for the imported Contacts with the default Member Status. This helps streamline the process of adding members to campaigns.

Exact Name Matching (D):

Existing Campaigns in Salesforce are matched by exact Name. This means that the names in the CSV files must match the names of the Campaigns in Salesforce exactly for the import process to associate Contacts with the correct Campaigns.

Steps to Set Up:

Prepare CSV Files:

Ensure that the Campaign names in the CSV files exactly match the names of the Campaigns in Salesforce.

Include all necessary fields to map Contacts to Campaign Members.

Configure NPSP Data Import:

Navigate to NPSP Settings -> Data Import.

Ensure the settings align with the import requirements, including handling duplicates and respecting duplicate matching rules if enabled.

Perform Dry Run:

Use the NPSP Data Import Dry Run feature to validate the import configuration and ensure that the Campaign Member Status and other settings are correctly applied.

Establishing a Center of Excellence (CoE) addresses the governance function of the application development lifecycle. A CoE provides leadership, best practices, and oversight to ensure consistent and effective use of Salesforce across the organization:

Governance: Ensures that there are clear policies, standards, and guidelines for managing and using Salesforce.

Best Practices: The CoE promotes best practices for development, deployment, and ongoing management of Salesforce applications.

By focusing on governance, a CoE helps maintain the integrity, quality, and strategic alignment of Salesforce initiatives within the nonprofit.

To track all donations that go to a designated fund, the consultant should create a GAU Allocation record for the designated fund. Here’s why:

GAU Allocation Record:

General Accounting Units (GAUs) are used in NPSP to allocate portions of donations to specific funds or purposes.

Creating a GAU Allocation record allows the nonprofit to specify the amount of each donation that should be allocated to the designated fund, ensuring accurate tracking and reporting.

Salesforce NPSP Documentation on General Accounting Units (GAUs)

Salesforce Nonprofit Success Pack GAU Allocation Guide

For a nonprofit that does a lot of mail appeals to donors and wants to ensure addresses are formatted correctly, the consultant should recommend:

NPSP Address Management:

NPSP Address Management helps ensure that addresses are standardized and formatted correctly. It includes tools and processes to manage and validate addresses, thus reducing errors in mailings and improving delivery rates.

https://trailhead.salesforce.com/en/content/learn/modules/search_solution_basics/search_solution_basics_optimizing

To improve search performance when migrating a large volume of donation data into the Nonprofit Success Pack (NPSP) for a nonprofit, the consultant should consider implementing Skinny Tables and Custom Index. Here is a detailed explanation:

Skinny Tables:

Skinny tables are a performance optimization technique in Salesforce used to improve the performance of read-only operations.

They are highly effective in environments with large volumes of data, such as the scenario described with 20 years of donation data and over 200,000 donations each year.

A skinny table contains frequently accessed fields and can significantly reduce query time.

Skinny tables are maintained by Salesforce and do not require changes to the custom object schema or existing queries.

They are particularly useful for scenarios involving complex reports and list views.

Custom Index:

Custom indexes enhance the performance of search queries in Salesforce.

Creating custom indexes on fields that are frequently used in search filters and conditions can drastically improve search performance.

Salesforce allows up to 25 custom indexes per object, which can be leveraged to optimize searches on key fields such as donor names, donation dates, and amounts.

Custom indexes should be applied to fields involved in frequently used WHERE clauses in SOQL queries.

Salesforce documentation on Skinny Tables: Skinny Tables

Salesforce documentation on Custom Index: Custom Index

For managing social media presence, listening to constituents, measuring impact, and managing activities from a mobile app, Salesforce's Social Studio is the recommended tool.

Social Studio Overview:

Social Studio is a powerful social media management tool within Salesforce.

It provides capabilities for social listening, publishing, engagement, and analytics across multiple social media platforms.

Features and Capabilities:

Social Listening:

Monitor social media channels for mentions, comments, and conversations about the organization.

Identify trends and sentiment to understand constituent engagement and feedback.

Publishing:

Schedule and publish content across multiple social media platforms.

Manage social media campaigns and track their performance.

Engagement:

Interact with constituents directly from the platform.

Manage responses and engage with the audience in real-time.

Analytics:

Measure the impact of social media activities.

Use dashboards and reports to gain insights into engagement, reach, and sentiment.

Mobile App Management:

Social Studio includes a mobile app that allows users to manage social media activities on the go.

This ensures that social media management is not limited to the desktop and can be handled efficiently from anywhere.

Implementation:

Set up Social Studio within the Salesforce environment.

Configure social media accounts and start tracking and managing social media activities.

To automatically generate an Opportunity whenever a Lead is converted in NPSP, the consultant should enable the "Create an Opportunity on Lead Convert" option in the NPSP Settings. This option ensures that an Opportunity is automatically created as part of the lead conversion process.

Navigate to NPSP Settings:

Go to the App Launcher, search for "NPSP Settings", and select it.

Enable Lead Conversion Setting:

In NPSP Settings, expand the "Leads" section.

Find the "Lead Conversion" settings.

Check the box for "Create an Opportunity on Lead Convert".

Save the settings.

This configuration streamlines the process, ensuring that Opportunities are consistently created during lead conversion, without requiring additional custom code or third-party applications.

To help a nonprofit run a large scholarship program using Salesforce for accepting external scholarship applications, reviewing processes, and tracking requirements, the following solutions are recommended:

Experience Cloud:

Experience Cloud allows the nonprofit to create a community or portal where external applicants can submit their scholarship applications.

It provides a user-friendly interface for applicants and reviewers to interact with the application process.

Steps to Implement Experience Cloud:

Set up an Experience Cloud site and customize it to match the nonprofit’s branding.

Create forms and pages for application submission.

Enable user roles and permissions to control access for applicants and reviewers.

Outbound Funds Module:

The Outbound Funds Module (OFM) is specifically designed to manage the distribution of funds, such as scholarships.

It allows for tracking applications, managing review processes, and ensuring compliance with scholarship requirements.

Steps to Implement Outbound Funds Module:

Install and configure the Outbound Funds Module from the AppExchange.

Set up funding programs, grant types, and application criteria.

Use OFM’s built-in features to manage the review and approval workflows.

These solutions provide a comprehensive and integrated approach to managing the scholarship program within Salesforce.

When using the NPSP Data Importer for Contacts, if some Account records are not being automatically created, the consultant should check:

Required Fields in the Import: Ensure that all required fields for creating an Account are included in the data import file. Missing required fields can prevent Account creation.

Required Fields on the Account: Verify that the Account object does not have custom required fields that are not being populated by the import process. Custom fields marked as required at the field level or in page layouts can block record creation if not provided.

Checking these factors ensures that the import process has all the necessary information to create Account records successfully.

To quickly deploy a solution that provides insights into corporate sponsorships, including pipeline value, number of opportunities, Pardot score, win/loss percentage, stage value, and a table of opportunities, the consultant should recommend B28 Marketing Analytics. Here’s why:

B28 Marketing Analytics:

This analytics solution is designed to provide deep insights into marketing performance, including detailed views of pipeline metrics and opportunity analysis.

It integrates with Salesforce and Pardot, offering out-of-the-box dashboards and reports that can be quickly deployed.

The tool enables the nonprofit to gain actionable insights into why certain sponsorships are closing or being lost, facilitating data-driven decision-making.

Salesforce B28 Marketing Analytics Documentation

Salesforce Pardot Integration Guide

To allow a fundraiser to easily track and update her gift asks for donation solicitations, using Path is a suitable solution in Salesforce. Here’s how to configure and use Path for this requirement:

Enable Path:

Navigate to Setup and type "Path" in the Quick Find box.

Click on Path Settings and enable Path if it is not already enabled.

Create a Path:

Click New Path and follow the steps to create a new Path.

Select the Opportunity object since you want to track donation solicitations.

Define the stages of your solicitation process (e.g., Identification, Cultivation, Solicitation, Stewardship).

Configure Key Fields and Guidance:

For each stage, specify key fields that the fundraiser should complete.

Add guidance for success to provide tips and best practices for each stage.

Assign the Path to a Record Type:

If using record types, ensure the Path is assigned to the correct record type for your donation solicitations.

Use Path:

On the Opportunity record page, the fundraiser can now see the Path at the top of the record.

She can track her progress, update fields, and follow the guidance provided at each stage.

Using Path helps the fundraiser to visualize the stages of the solicitation process, ensuring she can track and update gift asks effectively.

Salesforce Path Documentation: Path in Salesforce.

When a corporate matching gift is received and the original donor did not indicate that it was to be matched, the consultant should recommend using the "Find Matched Gifts" feature. This feature helps in identifying and linking the matching gift to the original donation:

Select Find Matched Gifts: This option is available within the Nonprofit Success Pack (NPSP) and is designed to help match donations.

Click on the Find More Gifts button: This button will allow the development associate to search for and match the original donation with the corporate matching gift.

This process ensures that all matched gifts are accurately recorded and credited appropriately.

When migrating a large volume of contacts, organizations, and address records into NPSP, it is essential to consider the following:

Complexity with the Address Object:

Using the Address object to track addresses can introduce complexity, especially if multiple addresses per contact or organization need to be managed. This complexity arises from the need to ensure all address records are correctly linked and maintained.

Impact on Data Storage:

Migrating all historical address information can significantly impact system data storage. Salesforce has storage limits, and large volumes of data can quickly consume available storage. It is important to plan for data storage needs and consider archiving or summarizing historical data to manage storage usage effectively.

Steps for Migration:

Data Preparation:

Clean and standardize the data before migration to ensure consistency.

Identify and remove duplicates to avoid data redundancy.

Data Mapping:

Map the fields from the legacy system to the corresponding fields in NPSP, including custom fields if necessary.

Data Import Tools:

Use Salesforce Data Loader or the NPSP Data Importer for the migration process.

Import data in batches, starting with Accounts, followed by Contacts, and then address information.

Testing and Validation:

Test the migration in a sandbox environment to identify and resolve any issues.

Validate the imported data to ensure accuracy and completeness.

"Data Import Strategies for Nonprofits" from Salesforce Help: Data Import Strategies

"Address Management in NPSP" from Salesforce.org: Address Management

A Salesforce-recommended V2MOM includes key components that guide an organization’s strategic planning and execution. The two sections that should be included are:

Vision:

This section defines what you want to achieve. It sets the overall direction and purpose of the plan. For example, "Increase donor engagement and retention by 20% over the next fiscal year."

Metrics:

This section includes the measures of success. Metrics help track progress and determine if the vision and goals are being met. For example, "Track the number of new donors, donor retention rate, and total donations received."

Including these sections ensures that the organization has a clear direction (Vision) and a way to measure success (Metrics), which are critical for strategic planning and execution.

"V2MOM: Vision, Values, Methods, Obstacles, and Measures" from Salesforce Blog: V2MOM Framework

To help the executive director understand the overall summary of individuals engaged with the organization across multiple channels, creating a Campaign Hierarchy is the most effective solution. Here’s how to do it:

Create Campaigns for Each Channel:

Navigate to the Campaigns tab.

Create separate Campaigns for donations, volunteer shifts, and event attendance.

Use meaningful names to easily identify the Campaigns.

Build the Campaign Hierarchy:

Within each Campaign, specify a parent Campaign if applicable to create a hierarchy.

For example, an overarching "Engagement 2024" Campaign can have child Campaigns for donations, volunteer shifts, and events.

Associate Campaign Members:

Add relevant individuals to each Campaign as Campaign Members.

Ensure that each Campaign Member record reflects the individual's engagement in that specific channel.

Reporting on Campaign Hierarchy:

Create reports to summarize engagement across the Campaign hierarchy.

Use filters and grouping to display the number of people associated with each type of engagement by channel.

This approach provides a clear and organized view of individual engagement across various activities, making it easy to track and report on overall engagement.

Salesforce NPSP Documentation: Campaign Management

Salesforce Trailhead: Nonprofit Success Pack (NPSP) Campaigns

To create a report that shows who the solicitor is for each donor using automated soft credits, the system admin should use the "Opportunities with Partial Soft Credits and Contacts" report type. This report type allows the inclusion of soft credits and the related contacts, making it possible to track the solicitor for each donation.

Steps to Create the Report:

Choose the Report Type:

Navigate to the Reports tab and click "New Report."

Select the "Opportunities with Partial Soft Credits and Contacts" report type.

Customize the Report:

Add the necessary fields to display the solicitor, donor, and relevant opportunity information.

Use filters to refine the data as needed.

Save and Run the Report:

Save the report with an appropriate name and run it to view the results.

For a data migration involving tens of millions of records to NPSP over a weekend, the Bulk API is recommended due to its ability to handle large volumes of data efficiently:

Prepare Data for Migration:

Ensure all data is cleaned and formatted correctly for import into Salesforce.

Segment the data into manageable batches to optimize the migration process.

Use Bulk API for Migration:

The Bulk API is designed for loading large data sets and operates asynchronously, allowing for high performance.

Create a Bulk API job to import the data.

Upload data batches and monitor the job status to ensure successful data import.

Minimize System Downtime:

Schedule the data migration to occur during a weekend to reduce the impact on users and minimize system downtime.

Inform stakeholders about the migration schedule and expected downtime.

Verify Data Integrity:

After the migration, run data integrity checks to ensure that all records have been accurately imported.

Compare source data with the imported data in Salesforce to verify completeness.

Using the Bulk API will ensure that the large volume of data is migrated efficiently within the limited timeframe, minimizing disruption to the organization’s operations.

For a nonprofit using direct mail extensively and needing to automate the search for duplicate contact records, the consultant should recommend implementing Duplicate Jobs. Here’s why:

Duplicate Jobs:

Duplicate Jobs allow organizations to run deduplication processes on a schedule, ensuring that the data remains clean and free from duplicates.

This feature can be configured to find and merge duplicate contacts based on predefined matching rules.

It helps maintain data quality by regularly identifying and managing duplicate records, which is essential for effective direct mail campaigns.

Salesforce Duplicate Management Documentation

Salesforce Nonprofit Success Pack Duplicate Management Guide

When considering the Individual ("Bucket") account model for a nonprofit organization migrating to an NPSP org:

Legacy Account Model: The Individual account model is considered a legacy option and is not recommended for new implementations due to limitations in scalability and flexibility.

Account Data Skew: With a large volume of contacts, using the Individual account model can lead to data skew issues, where too many contacts are associated with a single account, causing performance and reporting challenges.

It is advisable to consider other account models like the Household Account Model, which is more suitable for managing large volumes of contacts.

When an international nonprofit adds a translated Relationship picklist value but both Relationship records are displaying incorrectly, the likely cause is that the reciprocal relationship value is missing in the NPSP Settings tab.

Reciprocal Relationship Setup:

In NPSP (Nonprofit Success Pack), relationships between contacts often need to be reciprocal. For example, if Contact A is listed as "Parent" of Contact B, then Contact B should be automatically listed as "Child" of Contact A.

https://powerofus.force.com/s/article/PMM-Overview

https://trailhead.salesforce.com/en/content/learn/modules/program-management-with-nonprofit-cloud/manage-nonprofit-programs-with-salesforce?trail_id=manage-programs-with-nonprofit-cloud

To meet the reporting requirements of a new grant that expects services to be segmented according to location, the nonprofit should use the Program Cohort object. The Program Cohort object allows tracking and reporting of services provided in specific locations, making it possible to generate detailed reports that meet funder requirements.

Steps:

Configure the Program Management Module to include the necessary fields for tracking service locations within the Program Cohort object.

Ensure that all relevant data is accurately entered into the Program Cohort records, including location details.

Create custom reports and dashboards that segment services based on the location data stored in the Program Cohort object.

Regularly review and update the data to ensure accurate and up-to-date reporting for the funder.

In the Nonprofit Success Pack (NPSP), donations can be credited in two ways: hard credits and soft credits. Hard credits reflect direct donations, while soft credits are used to acknowledge indirect contributions, such as when a donor's employer matches a donation.

Hard Credits:

Hard credits represent the actual donor who made the donation.

In this scenario, the employer who matches the donation will receive a hard credit for the matched amount.

Soft Credits:

Soft credits are used to recognize individuals or entities who influenced or facilitated the donation but are not the direct donors.

The donor will receive a soft credit for the amount matched by their employer.

Scenario Application:

The donor made a donation of $500. This is a hard credit for the donor.

The employer matches this donation with another $500. The employer receives a hard credit for this matched amount.

The donor is acknowledged for facilitating the matched gift, thus receiving a soft credit of $500.

Implementation in NPSP:

To implement this, configure the Opportunity Contact Role to automatically assign soft credits to related contacts, such as employers matching donations.

Use the NPSP Settings to ensure that soft credit roles are correctly assigned and tracked.

For a nonprofit trade association that sells research papers, certifications, and other products online to its existing members who are primarily universities and companies, Salesforce B2B Commerce is the most suitable solution:

Salesforce B2B Commerce:

Salesforce B2B Commerce is designed for business-to-business transactions, making it ideal for organizations that sell products and services to other businesses, such as universities and companies.

It provides features for managing complex pricing, bulk orders, and accounts, which are essential for a trade association dealing with institutional members.

Features and Benefits:

B2B Commerce offers personalized buying experiences, self-service portals for customers, and streamlined order management processes.

It integrates seamlessly with Salesforce CRM, allowing the nonprofit to manage member relationships, sales, and order histories within a single platform.

myTrailhead is the best solution for a nonprofit organization that wants to train and test its employees on various skills such as brand messaging, creating support cases for IT, and publishing online videos. myTrailhead provides a customized learning experience that can be tailored to specific needs and allows for interactive and engaging training modules. This solution also includes testing capabilities to assess employee understanding and track progress over time.

To collect information online about new volunteers, including names, contact details, skill sets, and availability, and create a report with this information, the following solutions are recommended:

Collect Contact Information During Job Sign Up:

Use the Job Listings feature in Volunteers for Salesforce to capture volunteer information during the job sign-up process.

Ensure that the sign-up form includes fields for contact details, skill sets, and availability.

Steps to Set Up Job Listings:

Navigate to the Volunteers for Salesforce setup.

Configure job listings and ensure the sign-up forms capture all necessary information.

Add the Volunteer Sign Up Form to the Nonprofit's Website:

Create a Volunteer Sign Up form and embed it on the nonprofit’s website.

Use the Volunteers for Salesforce Web-to-Volunteer feature to automatically capture and create records in Salesforce.

Steps to Set Up Web-to-Volunteer:

Go to Volunteers for Salesforce settings.

Set up the Web-to-Volunteer form with the required fields.

Embed the form on the nonprofit’s website.

These methods ensure that all relevant volunteer information is captured and stored in Salesforce, allowing for easy reporting and management.