Nonprofits

Using Donor and Transactional Data in Salesforce to Better Serve Your Constituents

Jun 27, 2024

Many nonprofit organizations choose Salesforce as their Constituent Relationship Management (CRM) system to provide a unified platform for their entire team. Because it’s so powerful, Salesforce users often face the paradox of choice. There are so many options for automation, customization, and reporting, that it can be difficult to decide what to prioritize.  

For organizations that have the option to do so, many experts who work with nonprofits recommend working with a partner to guide them through this process. If your organization isn’t in this position, there are many free resources available to help you get the most value out of your Salesforce investment. 

In this article, we review some practical tips for using your donor and transactional information to better serve your constituents. 

Setting Yourself Up for Success

Every organization captures data in some way, whether it’s donor information, program outcomes, or volunteer sign ups. Since it is inevitable to capture many types of data, it’s important to do so with intention by planning how you can use it to your advantage. By following a few best practices, you may find yourself with a happier team, more reliable data, and better long-term outcomes: 

  • Have a Plan: As the famous French novelist, Antoine de Saint-Exupéry, once wrote: “A goal without a plan is just a wish.” When planning a data strategy, think about what your goals are as an organization and think about the information you’ll need to get there. If your goal is to improve your major giving strategy, perhaps you need to better understand your current donors’ patterns, what campaigns or messaging get the most engagement, or who on your team is most capable of forging relationships with donors. A great way to frame this is in the form of questions. If you know what questions you want answers to, you can begin thinking of the specific data you need to collect. Knowing what you want to achieve lays the groundwork for a strong data strategy.  
     
  • Define Your Terms: Picture you’re new to an organization. You log on to Salesforce to get to know how your team has been tracking donor information and come across a checkbox labeled ‘Old Donor?’ You see that this field is checked on about 10% of all donor records and all by the same person who is no longer at the organization, who also created the field. What do you make of the data in the field? Is it a lapsed donor? A donor who was imported from an old system? Or maybe it indicates a donor of an advanced age? In any case, the data is not reliable and has just cost you time and confusion trying to determine what it actually means.  
     
    This scenario is all too common and that’s why it’s important to have clear definitions for all the data you want to capture. A team with a shared vocabulary communicates better and works more efficiently. 

 

  • Less is More (usually): When setting your goals and building your plan, ask yourself: “what is the least amount of information I need to get the most insights towards this goal.” If you survey your team for their least favorite day-to-day activities, don’t be surprised if a majority say, “filling out data in Salesforce.” The more information people need to complete, the less likely it is that all of it will be reliable or meaningful. Before introducing any new fields or metrics, make sure you have a clear understanding of how you want it used, label it accordingly, and communicate the ‘why’ behind it to your team.  

Donors and Transactions in Salesforce

With these best practices in mind, let’s look at some practical examples on how you can use donor and transactional data to your benefit. Capturing who your donors are, what their giving patterns are, and how contributions are associated to individual campaigns are powerful metrics for measuring success and adapting your strategy accordingly.  

iATS Payment by Deluxe offers a native Salesforce app, Brickwork, that lets nonprofits easily process one-time or recurring donations via credit card or ACH (EFT in Canada) directly in their Salesforce instances. By capturing this information, nonprofits can generate reports and build dashboards, like the one shown below, that can help your team know if they’re on track to hit their goals: 


Here are some ideas of metrics that your nonprofit can begin tracking, some of which are included in the dashboard shown above. As mentioned above, remember to Have a Plan when considering any of these metrics – some may be useful for your organization, some may need to be adapted, and some may not be relevant to you. Just because someone says a particular indicator is important doesn’t mean that it’ll help you reach your goals. Capturing data for data’s sake is a common trap organizations regularly fall into.  

With this caveat in mind, here are some sample metrics to get you started on your data-driven journey: 

  • Donation Volume over Time: if you’re wondering if your donors give seasonally, at certain times of day, or with some degree of consistency, measuring donations over time can help you decide the best times to launch campaigns. You may discover unexpected patterns, or you may confirm a hunch that will allow you to double down on your strategy. 
     
  • Total Annual Giving: setting an annual fundraising goal may seem overly basic, but comparing real time transaction data to that goal can help your team know if they are behind, on track, or exceeding their targets (which could merit a reward and make them feel appreciated). Depending on your organization, you could use similar barometers based on monthly targets or divided by individual development agents so you have an unbiased understanding of your team’s performance.  
     
  • Top Donors: knowing who your top donors are can help you steward donors, find volunteers, or even identify potential major donors. For more granularity, you could segment donors into tiers depending on giving amounts or frequencies. You can also divide donors by average gift amount or any other segmentation that helps you show them you appreciate their generosity. 
     
  • Donations by Method of Payment: having multiple giving channels helps donors give in the ways that are most convenient. Some donors may want to pay via credit card online whereas others may still prefer old fashioned checks. By understanding how many donors give using each method may inform such simple but powerful UX principles like the order in which giving methods are listed on your page - convenience is key. Understanding the balance of ACH (EFT in Canada) and credit card donations is also useful as it can help you optimize the fees that are charged by your payment processor. Managing this cost effectively means more dollars towards your operations. 
     
  • New Donor Acquisition: knowing how many new donors you gain within a given time period can help you understand which activities reach new supporters. Finding new donors is a perpetual challenge faced by fundraisers and evaluating whether or not you have a net-positive donor pool will help you plan for the future. 
      

There are so many more metrics you could use to keep track of your progress. As long as you Have a Plan, clearly Define Your Terms, and remember that Less is More (usually), you’ll be well on your way to succeeding with donor and transactional data! 

Some Ethical Considerations 

Keep in mind that there are some ethical and legal considerations to consider anytime you are reporting on donor information. When a donor gives you their personal information, it is your duty to keep it private and secure. All of the metrics shown above are specifically for internal use only as you would never want to share any information that could identify any one of your donors.  

 
There are some circumstances where your organization may want to publish a report using donation data.  These can be very insightful and motivating reports as you can prove to your donors the impact that their donations have on your missions. While we wholeheartedly encourage this type of data driven work, it is necessary to do so with wholly anonymized data unless given explicit permission from your donors. Always lean on the side of caution when it comes to sensitive donor data, especially when transactions are involved. 

In Summary 

Being intentional when administering and managing donor and transactional data can create major long-term value for your nonprofit. Reliable metrics are beneficial for every team and can help drive your mission forward. Better metrics also mean better constituent relationships, as you can more easily identify and prioritize stewardship and engagement efforts.  

Take the time to do some research and find which metrics are relevant to your organization to measure success. Create a plan, build a shared understanding across your team, and only capture data that you can reliably use. With these best practices in mind, you’ll have a clean CRM that’s easy to use and a happy team that truly understands the value of data. 


iATS Payments by Deluxe is a leading payment processing solution built and designed exclusively for nonprofits. Over 16,000 nonprofit clients trust us to process their valued donor contributions. If you want to see if Brickwork by iATS is the right fit for your organization, contact us today.