1 HOUR 1 MIN
Fundraising Success Using DonorPerfect’s Dashboards & Reports
DonorPerfect Community Conference session with DonorPerfect trainers
Learn how to unlock the power of DonorPerfect’s reporting capabilities to make informed decisions and achieve your organizational goals.
Categories: DPCC
Fundraising Success Using DonorPerfect’s Dashboards & Reports Transcript
Print TranscriptSpeaker 1 0:10
All right. Well, good afternoon, everybody. Welcome to our session. You are joining us too in the session where we have called it fundraising success, where we’re going to talk about the Read More
Speaker 1 0:10
All right. Well, good afternoon, everybody. Welcome to our session. You are joining us too in the session where we have called it fundraising success, where we’re going to talk about the donor, perfect dashboards and reports, you are in a session that is going to be led by myself. I’m Kelly, Sarah and Amanda. And yes, unfortunately, we are not using our webcams, we encountered a little bit of some technical difficulties in our earlier session. So we are trying to mitigate those issues. And just keep it focused on the content instead of our faces, we do miss seeing your faces. Well, I guess we’re not seeing your faces. But anyway, we’re glad that you’re here. So just a couple of details, like all the other sessions, the handouts and the slide decks will be available to you, if you scroll all the way down to the bottom of the screen, you will see them there. If for some reason they are not there, it seems to be very useful if you refresh and then they’ll appear. If you want to grab them right away. Great download, if you want to add them to your briefcase, we recommend that and they will also be available when you go back to view the recording. So every session has been recorded, including this one. And it will take a little short amount of time 30 minutes or so for it to be rendered, and then you will have access to it. But just keep in mind that. While this is the last session today, that you will have access to all of the sessions and the recordings for 30 days. So you can come back and you can get the information at any point. So I am super excited to kind of have this conversation with you with Sara and Amanda. And we are going to be kind of doing this as a little bit of a tag team approach. And as I said, Our faces are not going to be visible like they have been in all of the other sessions just as a way to try and troubleshoot some of the problems we had in our 145 session. So Sarah and Amanda, I’m going to turn it over to each of you. And Sarah, I believe you are getting us started. So it is all yours.
Speaker 2 2:33
I am and I am so excited to talk about this right now and to do this last session with you guys. And as you know in any organization metrics will help you measure success and failures and what brought you to either result and DonorPerfect dashboards and there are reports will help you measure and track many of those. But I also know and maybe some of you have noticed that sometimes it can be overwhelming or even nerve racking when you are told I need this result or I want this metric. I want this information. And now you need to go and run a report and DonorPerfect and the options are endless. So it could we’re going to do today is we’re going to take a walk through three different scenarios on how Dono Perfect reports can provide the data that you need, so that you can make informed decisions and fulfill your fundraising strategies and goals. So the first scenario that we are going to walk through is how much money that I raised compared to my goal. The second one will be war, my lapsed donors and how to best re engage them. And then the third one is do I have any potential major donors amongst my mid range donors. So taking I’m gonna take you through the first one, and then pass it on to Amanda. So the first one is really about keeping track of where you are in terms of meeting your fundraising goal. And different campaigns or it could be just annually and the annual fundraising goal dashboard meter will do that. I’m going to show you that specific meter on the dashboard and I’m going to show you two reports the gift comparison by time period and the cross tabulation report. As I show them to you in DonorPerfect, I’ll give you some more information on them. So I’m going to take you straight away now to DonorPerfect. So Gare Bear with me as I navigate to the system, and hopefully you’ve seen a bit of this already in the session earlier today that talk about the different metrics and dashboard. Items that are new this year and one of them is the annual fundraising goal and the annual fundraising goal. I’m just going to make it fit my screen. There we go. It Right now we can see, it’s the first thing I see on my dashboard, it’s quick glance, I’ve raised 87,000, I had a goal of 130. That’s 67%. My goal is by December 31 2021. So I still have a bit of time, I know I have a lot potentially, I know I have a lot of fundraising happening at the end of the year, I’m not worried, I feel like I’m way on track to reach this goal. Potentially, your your year is not a calendar year, you want to track something completely different you would like to track a fiscal year. So all you have to do is right here is where the goal is, you see this little tiny blue pencil, and you can click on it. And that will let you choose whatever that goal is. And then what is the last month of that 12 month period. So the meter is really tracking 12 months ending whatever month you put here. So if I was to change it, and say my fiscal year ends, march 31, so I’m going to track till March. And my goal could still be 130. And then I’m going to save. And then when it reloads, you’re going to see it will change what percentage I’m at, because now all gifts that I’ve received in January, February, March 2021, were part of the previous year, so they’re no longer counted. But I also have way more time to reach my full my full goal. So that’s easy as that you can change the goal and the date right there. So that was the first thing that I wanted to talk to you about it today. The second thing is one of the most critical, I’d say element of success is often learning from the past. So analyzing your tactics after each campaign to determine what produced results and what didn’t, so that you can refine your strategies is a great way to do that. measuring success can be especially useful when you’re looking at two successive campaigns, the same subject, so we’re gonna do the gift comparison by time period. That is a report that lets you compare any fields in DonorPerfect over time. So it could be by year by month, by quarter or by week. So we’re going to go and navigate there now. So I’m going to go to the reports and then Report Center. And I’m just going to zoom in a little bit since I zoomed out. So you could see the giving meter, trying to make this more user friendly. And I’m looking for the gift comparison by time period. So you can always search for report in the search bar over here, and you can type the record with the right spelling, it always helps gift comparison by time period. So this is the report I’m looking for. It is a financial reports, I could have looked specifically in the folder. In my case, it’s also in my favorite because I use it often. So the gift comparison by time period will let you really choose a date range of your choice. So let’s say that I would like to see I have a campaign that I run every year and I’ve run it for the last three years. And I’d like to compare that campaign. Well, if I was to do a date range of the last three years, then I would just go back to 2019. And I can leave it till today. And then I’m going to split it over here by year. So I just want to see each year. But like I said, the system lets you do by week, by month, by quarter or by year. So I could do something completely different with this. And I wanted to remove the selection filter. So just one second, okay. And if I wanted to instead just see always a campaign going this year, month per month, if I’m running is something different every month, I can also do that. And then the field to segment by is going to be the campaign field. So I’m going to go ahead here we go. And then I’m going to click screen. If you’ve run DonorPerfect reports before you may notice that this is slightly different than the typical sidebar that we’ll see in the next report in most of our reports, but clicking screen means show it to me on the screen right now. My other options would be to print it, send it to Excel, send it to a Word document. So here I have the campaign that I’m running every year so forever home. I have 2019 2000 22,021 and I I can compare it here and see what happened in 2019. What happened in 2020? What happened in 2021, I actually received and 2021 some gifts to the previous campaign. You can see them here. And that is because some people chose to enroll in my monthly giving, should that campaign potentially, or it could be because they finally responded to my coupon and sent me an older coupon. So I can either decide that I really want to see the whole year, or I can really focus on the code on the side. The other thing that’s really nice is I have my new building campaign over here. So that is a campaign that I’m running to build a new and you Kitty Cafe that we’re building right now in my fake rescue center. And this building campaign is ongoing for multiple years. So this is even more useful to track and see. Okay, so how did you do in 2019 2020 was a rough year. And now we really have our biggest fundraiser for the building campaign is coming up in October. So that’s normal that the number is low still. So I could say that, okay, I feel like I’m on track or not, depending on the situation.
Speaker 2 11:22
So that’s for the gift comparison by time period. Right now comparing campaign by year. The next report that I’m going to show you is the cross tabulation report. So sometimes, when you’re looking, you want to look at more than just one segment, for example, understanding which solicitation effort directed gifts to what fund. So we’re going to go to cross tabulation report. So still in Report Center, all reports come from, and it’s right here in my favorites, I could have again, search for it in here, I could go look to financial reports, because it is a financial report. And the cross tabulation report, my colleague, Kelly, that you’ve heard with already today, always makes fun of me almost because I love this report so much. I think it’s the best report in DonorPerfect, because you can literally choose so many options to view it. So I’m only going to show you one today. But just remember this report as any two fields that you want to compare what has come in for those two segments, you can so right now I’m going to show you solicitation by General Ledger, which are selected here. And the cross tabulation is really going to create a table. So I’m going to see on the left side, my solicitation codes and then on the top, my general ledger, and then we’re going to see them meet in the middle. So I’m going to run it just make sure there’s nothing saved below. And here we go.
Speaker 2 13:02
And I’m going to just say Okay, so here, what we get is all my different General Ledger are listed here. And then on the side my solicitation code, so just like I told you, and then I can see that my annual appeal 2021 Well, 48 of those guests, they all went to the building fund. Now I know this is an appeal, maybe that I do strictly for the building fund. So that would make sense. If I look at Giving Tuesday, or grants or any of these, I can see different categories that were selected. So the one that interests me right now is where are people choosing to donate from my website donation form. So here I’ve got that 24 chose the adoption fund, whereas 56 Just put it to the general fund. So they didn’t necessarily pick something, and six of them actually chose health. And I still had to sorry for the building fund. And what we see at the beginning is those that didn’t pick anything, so there was no actual General Ledger selected in that column. And there was no solicitation code selected in that line. So that’s what that means. And anything in blue underlined is clickable. So I want to see who are those 24 people that donated to the adoption fund. And here it is, that is their list and all of their donations. And again, I could export this to Excel, if I needed to. I’m going to pass this over to Amanda. And I hope that this was helpful and giving you three potentially go to reports or options. And Amanda is going to talk about the lab stoners.
Speaker 3 14:55
All right, thank you Sara so much and I am so excited to get to talk to you guys about reengaging those laps donors. So laps donors are those supporters who gave to your organization in the past, but they no longer do. And the amount of time since their last donation or the criteria that you use to define a lap status that’s going to differ by your organization. But today, we’re gonna stick with DonorPerfect definition, which is they gave a gift last year, but they haven’t given a gift this year. So why reengage laps donors? Well, reconnecting with maps donors is a much more cost effective and less time consuming way to bring in funding rather than going after brand new donors. Plus, it ensures that you have more longtime supporters part as part of your organization that can help further your message. So in terms of what I’m going to cover around lapsed donors, I’m first going to show you guys some dashboard metrics to help you identify, do you have a donor retention issue, then we’re going to take a look at the Lapps donor report to see who they are, and the general ledger analysis report to identify what are their interest. So Sarah, you can go ahead and open up DonorPerfect for us real quick. And on this organization’s dashboard, we have quite a few different tiles and metrics that can help you identify do you need to focus on donor retention. The very first one is that donor retention tile, and it’s going to tell you what your donor retention rate is. In this case, we’re at 62%. But if I’m looking at that red metric, it’s telling me that my donor retention has actually decreased by 19%, compared to where I was last year. So that’s a very broad number. If I want to get a little bit more detail and look at my donor retention month over month, then I can look at the donor retention line graph. And that’s going to actually show us my donor retention from last year compared to the current year. And I can maybe start identifying the month where my donor retention is starting to decrease. And then I can also take a look at my donor retention by status bar graph, because what that’s going to do is show me the number of lapsed donors that I have for my current year compared to the number of lapsed donors that I had in the previous year. So I can see I had significantly less lapsed donors last year than I did in the previous year. So yes, I need to perhaps come up with a strategy on how I’m going to re engage them. But in order to re engage them, we have to know who are my lapsed donors. So Sarah, I’m going to have you go to the reports and Report Center. And we’re going to take a look at the last year, but not this year report. Also short into call live but so Sarah is going to go ahead and click that report. And this is one of those reports where you don’t necessarily have to apply a filter, because this report is actually going to look at your laps donors based on the fiscal year that you have in your DonorPerfect system. But as always, it’s a good idea to hit clear values to make sure there are no filters, and then go ahead and run that report. And what this report will very simply do is it’s going to list out all of your constituents that are marked as lapsed, and you’ll be able to see some of the key details about their giving history. who they are. When was the date of their last contribution? What was the value of their last gift? How much did they give total in the previous fiscal year? And how much have they given over their lifetime. So this is super helpful because we can’t necessarily go after every single lapse donor. So this can be some helpful information for you to make your lapstone or list a little bit smaller and targeted on those donors that you feel you want to invest those resources and time and reengaging and if you did want to pull this list out of DonorPerfect, you can hover over the downward caret next to run report. And you can export it to Excel. We’re or as a PDF, or you can use an export template to get the data out that way. So knowing who our lapsed donors are, that’s only half of the lapsed donor equation, because our goal is to reengage them, we want to bring them back as a donor. So we have to think about what’s the best way to engage them. And the best way is always segmentation, segmentation segmentation, let’s look at what the donor gave to us in the past, so that when we’re communicating with them, to ask them to rejoin us, we can send them a message that is meaningful to them. So one of the ways that we can do this is we can look at the last general ledger code that this donor gave to. So upstair is going to go ahead and go to the reports and Report Center. And she’s going to pull up a report called the General Ledger analysis report. And she’s going to use the search bar to search for that, or she can scroll down and find it, both of those are going to work. There’s always more than one way to do something in DonorPerfect. Now, unlike the lapsed donor report, the general ledger Analysis Report is not going to know that I only want to look at these details for my lapsed donors. So I have to set a selection filter so that when I’m looking at this information, it’s only showing me those general ledger codes for those lapsed donor segments. So Sarah is going to go into the sidebar and click the Apply icon. And what I’m going to do is I’m going to use a filter that I’ve already saved, and it’s going to be in my I believe they’re called the giving and engagement filter folders. Nope, it’s called standard fundraising filters. So Sarah clicks on that folder. And this is a group of filters that you all have access to. If you don’t see it under standard fundraising filters, you might see them under your default filter folder. But what I’m looking for is my filter for lapsed donors. And I can build this filter based on lapsed donors on a calendar year, or fiscal year, depending on what it is you want to look at. In my case, Sarah, go ahead and select Calendar. I always like running my reports on calendar. That’s just my personal preference. And now if I click Run Report, I’m going to be able to now see all of the General Ledger codes that my lapsed donors have given to. And if I click on a total given hyperlink for one of these segments, let’s look at adoption. Because that’s something that’s very near and dear to my heart. I can see who gave to that adoption, General Ledger. So that when I’m coming up with how I want to engage with these lapsed donors, maybe that messaging is going to be around how my organization has helped many different dogs and cats find their forever home. And that messaging could be through a direct mail piece, it could be through an email, you can even send a video message as a way to reengage these constituents. The goal is that we want to segment that or that communication. And we want to make sure that when we’re talking to them, we’re thanking them for their past donations and emphasizing the impact that they had an asking them would they like to continue to have that larger impact? So I could go on and on and on about lapsed donors. It’s something that I’m very passionate about. But alas, I do now have to turn it over to Kelly because she has some great information about how you can find potential major donors among your mid range donors.
Speaker 1 24:23
All right. I am super excited to follow Sara and Amanda’s conversation, and I am going to attempt to answer the question Do I have any potential major donors amongst my mid range donors? So before I explain how I’m going to do it, let’s just pause for a moment and think about major donors. Some of you may have participated in sessions already. And our conference I spoke about this but I’m really just going to kind of focus in on information that exists already in DonorPerfect so having major donors I think we would all agree is a key element or a key I like the fundamental building block of a successful nonprofit. In fact, many fundraisers if I were to pull each of you are going to say that oftentimes, around 88% of all nonprofit funds come from just 12% of your donors. And those are typically your major donors. But here’s the question, what if you don’t know who your major donors are, or you would like to increase the count of major donors you currently have. And we realize not all donors give a major gift as their first gift, their second, or even their third gifts of sometimes they’re hidden, they’re buried in there. So in fact, many of them go unnoticed, and really just remain that kind of mid range donor, they’re important. But we know from a lot of the things that we’ve learned in this conference, and you may have experienced firsthand is that you need to have some of these major donors. So we know that cultivating donor relationships is super important at all levels. But we also know that building relationships doesn’t just happen by itself, it takes time to build these solid relationships, so that when you are having these conversations with these potential major donors, they’re actually going to be really excited to support and partner with you. So I know like Amanda said, we could talk about this one topic for a long time, I need to keep moving. So I’m going to kind of break this down into a very short conversation, where I’m going to share with you two dashboard reports, two filters and two reports that you can use to find some potential major donors. So let’s go ahead and go into DonorPerfect and take a closer look. So where I’m actually going to start is at the organization dashboard. So as you know, we’ve been talking about this organization dashboard. And I’m actually going to focus in on two tiles to widgets that are really about overall metrics that you are going to find hopefully useful in tracking your efforts in cultivating mid range donors to become major donors. But you really need to think about this as a kind of a benchmark process. Here’s where I’m at now, I’m going to implement a fundraising initiative or strategy. And I’m going to come back and I’m going to periodically check to see how am I doing? So the two that I want to draw your attention to our growth and giving and the donor lifetime value, so they’re kind of bookending the tiles there in the middle. So growth and giving is one metric to help you make informed growth oriented decisions. Specifically, Growth in Giving is a percentage of growth or decline in revenue from two years ago, in the past to 12 months ago, on a rolling basis, so it’s a year over year basis, you will also see the total dollar amount difference between these two time periods. There are many ways to see a gain in growth and giving such as gifts from new donors, gifts from recaptured donors that Amanda just spoke about, and the increase gift amounts from upgrade donors. And that’s what I’m going to focus on. Another valuable metric to help us spur us on in this quest of finding potential major donors is using the donor lifetime value. Now, this is a really valuable number. But let’s break it down in case it’s new to you. So donor lifetime value is a prediction on how much money you can expect to receive from a donor starting from their first donation and lasting until the moment they stopped giving. So yes, it is based on actual data, like their average gift amount or frequency of gifts. But since we don’t ever really know when a donor will stop giving, it does become a bit of a prediction. However, while it’s predictive, a predictive number, it does help to paint a picture of how we’re doing in donor engagement, donor loyalty and donor giving. So if we apply the idea of major donors and the positive impact they can have on both of these metrics, it’s going to be the motivation we need to keep on going. So let’s go deeper in our Knowledge Quest here. So I’m going to use all the data that exists in every system, and it’s going to be the data that I’m going to use to find and find my mid range donors. So my mid range donors in this conversation is going to be an individual who has given gifts a given account of gifts excuse me, the count of gifts between two and 10, two and 10 gifts and Their largest or what was sometimes referred to as their maximum amount that they’ve ever given is between 102 $150. So that’s going to be my target. And I’m going to take that information. And that’s going to become my selection filter. All right, so here comes the dreaded words of selection filters, and it can be mind boggling and frustrating. So we’re going to try and I’m going to give you a little tip that we all use as trainers to help figure out where the data is at. So we’re actually going to go into a record. So let’s look up my donor Henry Arnold. So as Henry’s record is loading, keep in mind my definition of a mid range donor. And what I’m going to do is I’m going to show you where in the record, these nuggets of information are at because once I know where the information is at in a record, I can then go apply it and build my selection filter. So first off, I wanted to narrow this down or another way as Amanda was alluding to segmenting to just individual donors. So typically, at the top of the main page is going to be a field that might be labeled donor type, it might be labeled constituent type. And that’s where I’m identifying the type of constituent I’m focusing on individuals. So I know Henry’s an individual. Okay, the second part of who I wanted is that they have to have given account of gifts between two and 10. And you can see that Sarah is driving all this, and she’s highlighting the number of gifts. But perhaps if you scroll up to the top, you’ll notice in the donor profile, you’ll also see it there as a number. So you can see it in a couple of different places. So again, Henry meets my criteria. Now my third criteria is that they have to have given their largest gift is somewhere between 102 $150. And again, it’s a field that’s visible in the donor profile. And it is a field that I can also choose to display in an entry screen. So if you are new to DonorPerfect, or maybe you’re looking at your screens, and you don’t see some of these fields, in a giving an engagement profile section like it is displayed on this screen right now, you can add those through what’s called the screen designer, we’re not going to get into that now. But just know that it can be done. These are all DonorPerfect standard fields. So now that we know our definition of our mid range donors that we’re kind of want to search for finding, and we know where the information is at in a record. Now what we want to do is apply it to a report. So let’s go ahead and hop into the Report Center. And we’re going to take a look at what I consider a power house report. And it is the good old comprehensive donor revenue analysis. Now I could absolutely use this report and look at everything in my system. I don’t want to look at it for everything in my system, I’m focusing in on a segment that I’ve just defined. So what we have to do is we have to apply or what’s referred to on the screen as setting a selection filter. So setting a selection filter is a way of telling DonorPerfect exactly which record you want to report on. So we’re going to check the box to set a selection filter. And now what we need to do is we’re going to add a new filter. So when Sarah was talking, she used kind of the sidebar fields and criteria available when Amanda was talking about lapstone, or she was using some of the safe selection filters. I’m now going to walk you through how to build a selection filter. So we did our our kind of our pre work and found where all of that information was that made my criteria. And I know that all three pieces were found on the main page. So in box or step one, I’m going to choose main bio, because that’s where those three pieces of information existed. So the first thing that I’m looking for is mice constituent type, sometimes referred to as donor type, or individuals. So I’m going to choose constituent type. Since I’m just searching for one value, I’m going to choose exactly equal to and since this is a coded field, I’m going to click on that gray button lookup codes and then select individual. Now I’m going to add more criteria, because remember, I have two more parts of my puzzle. Now I’m gonna go back to box one and it’s still correct main bio, going to box two. This time I’m going to search for the field that’s going to give me the count of gifts which is referred to as the number of gifts. But now I have a bit of a range. So I’m going to choose between in box three and I’m going to enter in to to 10 and that’s the count of gifts. I have one more criteria to add. So I’m going to add more criteria and I’m going to repeat the process Again, main BIOS already selected, I could be choosing it just as an FYI from other pages. In this example, I’m making bios, so I’m good. But now I don’t see maximum Gift Amount. Don’t fret at the top, I’m going to select all fields. Now I have this long list of fields. And I’m just going to scroll through, and I’m going to search for maximum amount. Yep, there it is. And we’re again going to apply between because I’m looking for the range of 100 to $250. So this is the largest gift they’ve ever given, not their cumulative, but their largest gift they’ve ever given. Okay, so there are the three criteria of my mid range donors that I’m trying to learn more about, to see if they can become a potential major donor. So now I have the opportunity of reviewing what I’ve just selected, I want all three things. So I’m going to combine the criteria with and I could save this filter for use in the future. So I that’s where I can choose Save filter as. And then I can choose Done. So we’re gonna go ahead and click on Done. And now what I want to do is I want to review what I just selected. So I’m going to click on this screen. And let it process. Now again, keep in mind, I’m looking at this report for just a very specific segment. But this report in and of itself is taking all of the people I’ve selected and breaking it down into different categories on the left, active donors, retain donors, reactivated donors, and so forth. So you’ll notice that I have a lot of amazing metrics. Now, in each of these sections, there’s a blue link. So let’s go ahead and go to the active donors and click on the number 40. I think that’s a 48 might be a 45. Thank you 43. All right. And what I see is a bit more information about the people that are my mid range criteria. And they’re active, meaning that they’ve given gifts in this current time period. And what do you know, there’s Henry Arnold. Now what I’m seeing about Henry Arnold, that in this current year, so from 10 720 20, to today, I can see that he’s given one gift, that gift is $190. And in this time period, it’s one, I can see the total lifetime giving the average amount, the last gift amount. And so I’m seeing some great information. So I’ve taken a report, that could have been wrong for everybody. I’ve narrowed it down to justice, midrange, so now I can start educating myself a little bit more. So now let’s go into Henry’s record. So there’s a couple of ways we could do that. The easiest, I think is just clicking on his name in the report. So now when I go back into his record, I’m going to draw your attention to a couple of other pieces of information. So what I’m noticing in my quest for this mid range to potential major donors is I’m able to see at a glance, everybody that meets the criteria, and I can easily get into the record. And what I’m noticing in this case is that he has a lifetime so far $630. But I’m also noticing that he’s a volunteer. So volunteers are a way that you can kind of help measure. Consider this as an another kind of like feather in his cap as a potential major donor. I’m also seeing that he has given not just three gifts, but he’s been around for four years. Now, if I scroll down, and I have a section, like in this system, we have this giving and engagement profile, I can start looking at some other information like what did he give to most recently his last solicitation, I can look at what was his last contact interaction, if I were to apply and get some of the DP insights data in here. So again, this is predictive analytics, I can see some of the things that he has interest in, I can see the wealth rating. So yes, this is another part of dp Insights is it’s going to give you a bit of a glimpse about their potential giving. So what I’m seeing is that not only is Henry kind of in this mid range, there’s a lot of potential here. So now that I’m starting to dig in and review some of the information that I have, whether I’m using DP inside It’s or not, I’m able to get to, I’m getting to know Henry a bit more. So now what I want to do is I want to step back, and I want to run a different report. So this is my second report, where I want to look at these midrange donors, but I’m going to add one more detail in terms of their wealth rating. So we’re gonna go to the constituent summary. So the comprehensive donor revenue analysis was not as like upfront about who my donors wore. Now I’m gonna run a different report. And again, this is the constituents summary. So now one of the things that I can draw your attention to is in the sidebar, you are going to see that the filter that we just ran is still there, we didn’t name it, but it’s still there. So that’s kind of a time saver. So I’m going to click on the pencil, because what I want to do is I want to narrow it down just a little bit more, I want to make my segment just a bit more specific. So you can see that all three criteria are still there. But there’s a blue link there where I can add one more level. So let’s add more criteria. And I’m going to add to it just so that you can see, you can choose any field and this could be your own ranking field, it doesn’t have to be a DP insights field, but I am going to use that, that DP insights. And typically ranking type fields that you would build for yourself are going to be on the main page. So I’m going to choose main bio. And then I am going to choose the DP insights field for wealth rating. And I’m going to say that it’s between 75 and 100.
Speaker 1 41:52
And then I’m going to add that and then continue. That brings me back to where it was that I was at a moment ago. Again, I could choose to save this, since I’m really just kind of in an investigation stage, investigative stage, I may not want to. So I’m gonna go ahead and click on Done. And let’s take a look at who we have.
Speaker 1 42:23
So now I can see a bit more of a narrowed down list of who I might want to start with. And Henry Arnold is in there. So again, I validated what I selected, it’s here in the report. And now I’m able to see their name, their phone number, excuse me their address their phone number, if they had it, and I am able to kind of massage this a bit more, I might be able to send or schedule this to send it to somebody else. But there’s a lot that you can do once you have kind of a targeted segment. So talking about our potential major donors is you have to get in there and you have to dig around a little bit. And then start applying some selection filters to reports like the comprehensive donor revenue analysis, like the coms constituents summary, but then if you keep going back to those dashboard growth and giving and donor lifetime value, I suspect that you’re going to start seeing a bit of an increase as you slowly deepen the relationships with these people, because they’re already donors. Now you’re just strengthening and deepening those relationships. So as we come to closer to the end of our time, we’re just going to do a quick recap, and then we’re going to open it up for questions. Going back to the slide, here it comes. Alright, so this isn’t a, you know, a very common quote that some of you may be familiar with. And maybe it’s been read, you know, slightly revised, but you can’t really know where you’re going until you know where you’ve been. So as a summary, as Sarah said, you can use the data, you already have to see the performance. So you want to look back to see how you’ve done so that you can make informed decisions for the future. You can review your data. As Amanda was indicating, to reengage those donors to strengthen the relationship with your donors that have already given you just need to reach out and reestablish that relationship. And then when you’re searching for potential major donors, you can invest in your data to get to know your donors more deeply and implement a more personalized strategy. So thank you so much. We are now going to open it up to questions And I’m just going to pull this back. And I know when I was not talking, I did mark a couple of questions. So let me,
Speaker 2 45:10
let me go ahead, Kelly and help you out with a very good question that just came in. And it’s about the last report, you were doing the constituents summary. So if the whole database hasn’t been rated for predictive analytics, the person asked, this may not be the best report, right? So I think the report is still great. Your filter may just be different. But maybe you want to speak a bit more to that.
Speaker 1 45:44
Yep. So I think the thing to keep in mind is I could go in and for example, I’ve helped a customer build their own custom fields, they went into screen designer, and they build their own ranking field had nothing to do with DPN sites, nothing whatsoever, nothing to do with donor search, nothing. It’s their own fields, and they exported records, they populated it with their ranking, and they imported it back in, if I had been using that system, I could have applied a different selection filter that said, my custom ranking field equals b, because that means they’re mid range. So I could use that same report. But my filter would be different that they are individuals, they give an account of gift between 10, a two and 10, a maximum gift amount of 100 in 250, and my custom field equals b. So I just used one example of a new source of information that’s available to you. But if you don’t use that, and you don’t have that, it’s okay, you can use any field and you can just change your filter.
Speaker 2 46:52
Thank you. Another question that I would like to ask Amanda is when you’re using the last year, but not this year report, and maybe I can go to it so that you can answer the question properly. Someone was asking, Could you add solicitation codes to it? Or could you add addresses so that you could reach out to them?
Speaker 3 47:18
That’s a great question. Yep. So Sarah, I’ll let you get into that report before I give the answer. So the answer is right now with the standard reports, when we click Run Report, we don’t at this moment, have the opportunity to add additional columns of data to this report as we see it in DonorPerfect. But the great news is if we want to see those extra pieces of data, there’s a couple solutions that are available to you. Depending on what your DonorPerfect package contains. The one that I know, every person will have the capability to do is you can use an export template. So if you go to the downward arrow and select Export template, I like to think of these as being almost like custom Excel files that you build in DonorPerfect, whereby if Sarah clicks on that plus sign, I can go through and under selected fields, I can add any fields that I want to see in the Excel file that I’m exporting. So I can go ahead and find that last gift, the last just gift General Ledger code last solicitation, and I can add them to my template. And also make sure that I have those address fields. And when I’m happy with this, I can click Save and Close. Up and of course give it a name. Thank you, Sara. And I can just click Export, and that’s going to take these lists of lapsed donors and put them in an Excel sheet and pull out those extra pieces of key information that I want to see. So that would be solution. Number one. If your DonorPerfect system also has easy for reports as part of your package, then you could actually build a custom lapsed donor report where when you run this report, it’ll show you all of that information in the report in DonorPerfect. So really two different ways that you can do it. But both of them are gonna let you get that key pieces of information out that you need.
Speaker 1 49:37
All right, so Sarah, somebody was asking about the annual fundraising goal meter. Is it possible that that can be altered question one. So if you could show how they can change the date, and then a follow up is can they set a selection filter
Speaker 2 50:00
So the first question, can you change the date and the amount? Yes, you click the little pencil. And here you would put in whatever your goal is. And the day will be the last date that it adds, it will always look at the previous 12 months. So it’s a 12 month period, the CEU. As soon as you do the change, anyone accessing the organizational dashboard will see the updated data, or the updated information. So the updated meter. At this moment, we cannot add a filter to it. But that is coming. Right?
Speaker 1 50:38
Yep. And there’s also I don’t know if any of you participated in the what’s new, what’s next. There’s also going to be some fundraising goals. meters added where it can be for very specific you get to choose based on like solicitations and campaigns. Exactly what’s the goal was going to represent? Sarah, another question, and I can’t find that was about the general ledger analysis. Was that you that demonstrated that one? I can’t remember who spoke about that one. Okay, so the is the GAO analysis. Amanda? Is the GL analysis data based on last gift?
Speaker 3 51:20
That is a great question. So when we look at this particular report, if a donor was lapsed, and they did in fact give to more than one potential general ledger, then yes, they would have been included in more than one segment. So that would be something that is very important that you would want to be mindful of. For those of you that think, well, I want to look at that last general ledger code, how can I do that, you can certainly build a calculated field that would allow you to see that last general ledger code that a person gave to, and that could be incorporated into a report if you would like to. And I think Sara is going to pull up a donor record so we can see what that calculated field would look like. So in that case, it would be a single entry for each donor based on this field. And that could be incorporated into an easy report that could also be incorporated into other DonorPerfect reports. I’m having a brain fart at the moment, and I’m trying to think of a report that’s can that we could use that for. So Sarah Kelly, if you want to help me out as I’m trying to process in my head. No, we’re at the end of the conference.
Speaker 2 52:53
Then there’s a report, you can run on any, any There are reports you can run on any fields, right. So you could always run reports that include like different fields on it. But because now when we’re looking at the last general ledger code, we’re not necessarily looking at any, we’re not looking at a gift report anymore. Now we’re looking at a list with a main. So you’re not gonna have a canned report that will include necessarily that field, you’re gonna have to create something.
Speaker 1 53:28
So I think one of the things that everybody I hope everybody has stumbled upon, maybe you’re you’re well informed, is that any custom field that you create, and that can be done by anybody, as long as you have the user permissions, if you have the EZ Report Builder, you could create your own report. But even if you don’t, you could create an export template. And you can look at any information in any field that is in your system. And in a sense, it’s like it is a type of report. It’s XML, so it’s not officially a report, but you can still get that information and review it. Sarah, I know I’m trying to use controlling the mouse. A couple of questions in this session are coming up. They love that giving an engagement section. And they’re wondering, how do they get that on their screen? So some of them are not seeing it? So would you mind just again, going into the screen designer, I know you and I have done a couple sessions together. And we have talked about this because it’s an awesome section. But not everybody has been in our sessions. They’ve been in other fabulous ones. So where you can go to add new fields is in the screen designer. So Sarah, do you want to kind of talk through how to do this?
Speaker 2 54:43
Yeah, so the giving and engagement profile section on my in this system right now is in the main page and it’s called giving an engagement profile. It is a section that exists. I’m just going to click here preview screen so you can kind of refresh back to what we were talking about, I would say the big majority of these fields are calculated fields that come with your DonorPerfect system. Now it is possible that they’re hidden, that they are not currently displayed, it’s also possible that they’re on the bio page instead of the main page. So what I would suggest is that you try to find them. And if I go back to the field listing, you can search for them, just by scrolling down and trying to find those field to type names. And I’m going to get you in a moment. A knowledge base article that you can take with you after this, that will give you the list of all of those system fields that come with DonorPerfect. So if you’re scrolling down, you can see them, but you can also say I can’t find it. And there is a lot of fields in here, I don’t know what I’m looking for, there’s a lot there. And if you were to just set all screens so that you would find it anywhere. And you were to do for example Ctrl, F, and I was trying to find the number of gifts, so I’m going to write number. And then it’s going to find me way more things than I want. But if I keep going down, it’s going to eventually get me to what I’m looking for. And maybe not maybe the number was not a good idea to write number of get, there we go, I just had to write up. So number of gifts. So there it is. So that’s where the field is. So you’ll see is it in a section is it what screen is it on, most likely, the other ones will be near it. So whichever one you pick to look, first, you have a good chance of finding the others. If not, then you could also just go through the list and search them one by one, once you find it, you can select it over here, and then you can select them all of the ones that you want. And then at the top, you’re gonna get an option here where you can just set the field to display. Yes, here. And it was already but now it’s displayed twice, just displayed one still just say it’s being silly. You can also once you find them, and you know where they are choose to create a section. So while we’re in the screen designer, and we’re gonna give it a second to my DonorPerfect to catch up, maybe, okay, we can go here to sections. And we can create a brand new section and call it given an engagement profile. Or maybe we want to give it a different name that fits with what we’re doing, and then move the fields into that section. So most likely most of these fields exist already. And I am going to just share with you the list. Right now, if you bear with me, I just will do that right now. So this is the list here of the donor perfects calculated fields that are in next section by defaults. And most of them. If you do not have the section, then you can create the section, you don’t need the section to fields may exist in the section name something else, the fields may exist in a section that is not a section just listed all over randomly everywhere, right. So if I’m going to do add a new section, and then here, I would go ahead and give my section a name. And I’m going to call it number two. And then I save. And now I have a section that exists. Now currently at the bottom here, I could move it up, I want it to be the first thing I see. And then when I go back to fields, I can go and start moving fields into this section. So you can drag and drop them manually. Or you can select them and then use this feature here move selected fields to and then move them. Last thing just before I end. And before we let you go screen designer was in the little gear screen designer.
Speaker 1 59:19
All right. And one question that was asked and I know she’s been waiting for an answer is is there a way on the dashboard to apply filters to those widgets? So like if you wanted to exclude the requests or what have you, or different types of guests, so from the actual dashboard widgets, no, there’s no way to do that. But in our report, like if you’re in the Report Center, then yes, you could. The only other way to get very specific tiles to include specific gifts or exclude certain gifts is if you were to add on the report module called Smart analytics. So there is a way A but you know, that’s I don’t know that we want to go down that path. So the short answer is, right now the dashboard widgets are all inclusive. It does not you can’t exclude or include only certain types of gifts. So we would love to keep answering your questions, you’re asking some great questions, but we are out of time. So it says a couple of parting words is to let you know that all of the sessions, including this one, have been recorded, they are available to you for the next 30 days. So you’ll just come back into the event platform, find the session where you would like to kind of watch and you can do that. Hopefully, you’ve been downloading things into your briefcase. But it has been a pleasure interacting with you virtually as it is, but we hope that this has been helpful and we look forward to you in training sessions, webinars, perhaps and individual conversations and maybe even next year conference. So thanks so much. Have a great evening and take care.
Read LessRelated resources
DP Address Updater
Nonprofit Expert Episode 21: Ethical Data Usage for Nonprofits
Your Guided Growth Plan
Get a demo