Reporting on the Success of Monthly Giving

Hello everybody. Good afternoon. Maybe welcome back to some of you. Yet another webinar in our monthly giving series. As always, these webinars that we do in the earlier time slots they are slightly more advanced topic that today being reporting, it is helpful to have maybe a foundation of Read More

Hello everybody. Good afternoon. Maybe welcome back to some of you. Yet another webinar in our monthly giving series. As always, these webinars that we do in the earlier time slots they are slightly more advanced topic that today being reporting, it is helpful to have maybe a foundation of selection filters. But I’m still going to go over some of the basics of reports today. And if you wanted to, if you had time in a couple hours at a 3pm eastern today, I’m doing a another generic webinar that’s just about reporting in general, but Sticking with the theme. Last week we had somebody else this week, it’s me. This is our last webinar that we have in the monthly giving series for this. This go around. We’ll do this again next year, but today, we’re focusing on just reporting on the success. How can we find information about our recurring donors, past and present? There might be a way that your organization specifically has been doing it, and even if you haven’t, there is ways to find these folks. Everything really does boil down to data entry, which is where we’re going to start. I can’t think of a single webinar that I do where it doesn’t start at data entry in some way or another. And data entry is a little bit of an art at a certain point. You know, there’s, there’s a lot of drop downs that are in there. What options do we put in there? Yeah, I have some suggestions, but it is a little bit of an art. We’ll take a look at some of those options. My name is Sean Potero. I’m a training specialist here at DonorPerfect, often working one on one with clients. I do get to do these fun webinar weeks, every now and then, and we’re kind of new to zoom. I’m new to zoom, zoom webinars. At the very least, if you can hear my voice, let me know what your favorite fall activity is in the chat, please. There used to be a way in our old webinar system where you could check off a button and it would send me a notification like, Yep, I can hear you, but now I just look for audience feedback. So if you can hear me, what is your favorite fall activity, put that into the chat, I’ll know that my webinar is working, and I can continue talking for another 50 plus minutes. Oh, Kelsey, the cider mill. That sounds very cozy. I don’t know if I have any cider mills around me, but we do have a 1800s area festival that, you know, recreates kind of all the old timey recipes. And I know that there are some people in bonnets that make some cider there. I don’t know if I’m making it out there this year, maybe some corn mazes or something. I think I’m a little bit more excited for Halloween. Personally, I have, uh, 135 full size candy bars, and it has been two weeks that they’ve sat above the fridge, and I haven’t touched a single one. It’s for the kids. I got another two weeks to go before Halloween and then get all that candy out of here. This is a new record for me, but that is not the goal of today. Thank you, Kelsey. I know my headset is on and working today. We’re talking about monthly giving. I know when you signed up for this webinar, you should have gotten a PDF that had additional information about today’s talk topic, and linked within that is the monthly giving starter kit. I will preview that at the very end. This is something that was created by our marketing team, and our marketing team is full of former Nonprofit Professionals, develop executive directors fundraisers, and now they work for us as marketers. They’ve compiled all of the best advice we could could come up with in the monthly giving starter kit, and if you’re having trouble finding that resource, I’ll point you in the direction of it at the very end. As I said, I am starting off on data entry. How are these donations being entered into the database? Sure, we might have amounts and we might have dates, and we might be processing those things, but we have in DonorPerfect, what we call COVID fields, fancy term for a drop down menu, where we can use those drop down menus to add options that.

That then represent a unique label on that gift or on that pledge. And even if you’re not considering these drop down menus structurally for recurring payments, there are some gift codes that you can use to isolate these people if you don’t have a coding system in place, and there’s many different options that we have for reports. Our financial reports has to be our biggest group of reports that we have available, and some of them are tailored specifically to monthly giving you most of the time. Have to be very, very aware when you open up these reports What instructions you’re giving it so that you just see a certain segment of your database. These instructions, we call them selection filters, where we use fields to tell the report what we want to see, because the report on its own is just a group of fields, and then we have to tell it, well, for that information, what segment of the database do we want to see with it? So there’s many different ways that we could do this, I’m definitely going to show us at least four. I can think of one or two others that we might want to see as well. One of them we saw yesterday. I ran a couple quick reports yesterday, the Daily Log, amongst others, and we’ll see those again today this webinar, as with all of our webinars, we have a fake database in here. Everything’s customizable, and the way I have my screens arranged and the fields within it, it might just look a little different from what you’re used to seeing, but we all have the same fields available to us just might look a little different. So cool. So I’m going to turn my camera off and hop into DonorPerfect. I’ll hop back in if we have questions at the very end. Of course, as we’re going along, locate the chat box. If you have any questions, please feel free to ask as we are going along.

Oh yeah, the monthly giving dashboard, yet another thing that everybody has access to. No paywall really behind today’s today’s content. So starting off with data entry, here’s a screenshot that we have for my database. And one of the pledges that are in there, any of your constituents that is a recurring donor and that is being processed automatically out of the database, they are going to have a pledge. And now this pledge that’s in there, really, you could have gotten away with just having a start date. What is the day that they want to start this ongoing commitment and a billing amount, what we’re going to charge them? The exceptionally generous folks that want to give and give and give, they don’t have an a total that they want to give, so $0 is seen as an indefinitely recurring pledge. And then our frequency, of course, that’s going to be required. It doesn’t have to be monthly. Monthly is the most common, but there are several, several others, weekly, quarterly, annually. All of them work for automatic monthly giving, monthly giving. When you hear me and DonorPerfect talk about monthly giving, I put it in quotes because it’s often just referring to the databases ability to process recurring donations. So what I’m what I’m saying here today and all the reports I’m about to run, I use the word monthly giving a lot, but I could also be referring to anybody that has an automatic payment set up. Or we could even include the folks that send in checks. Maybe it’s not automated. Maybe they’re sending in money on a regular basis. It’s still a part of a commitment. They should still have a pledge. And it’s the values that are attached to this that we’re looking for, dates, amounts, frequency is bare minimum. You could technically have these pledges and not have all the extra detail that we’re going to see in some of these examples, the pledge that we’re looking at now has the same exact fields as the gift screen. Born from this pledge will be gifts that share the parent pledges, values, what General Ledger. Manager is on that pledge and the gifts that come from it. What fund is this money going into in general ledger? Really? I think every financial transaction should have a general ledger on it to keep our accountants happy, especially if we’re using QuickBooks, going to need to have a fund on there. The next three. This is where I think it becomes art, a little bit campaign solicitation and sub solicitation. These three you can use to record what your fundraising efforts were. Where solicitation is. In this case, we have a monthly giving 2024, option. This will help us distinguish between pledges that started in different years. A little bit easier. Solicitation, always a year specific fundraising effort next year, retire it create a new one for new data entry solicitations, the fundraising effort sub solicitation for revenue streams, not always needed, but if you have a campaign and overarching umbrella strategy, we might record our monthly giving in there. I kind of think of gifts and pledges. If you could personify something as abstract as a donation or a commitment, I think of these pledge gift people as wearing different clothes, like we can think of these drop down menus as different clothes. We are giving all of these gifts and these pledges similar clothes or similar codes so that we can find them later on. And that’s that’s what I have in in my example database full of fake people that we’ve been using for, oh, maybe eight or nine years we’ve been running some of these. Some of these fake donations have just been going on and on. Let’s take a look at one of them on the pledge screen. Before even going here, I could tell that this person has a pledge because there is a purple dot that’s here always indicates that there is information in a transactional table. In this case, we have a monthly giver, and if I edit this pledge, Ah, okay, it looks like this particular pledge was turned off. We have the date in January, and the total of $50 the billing amount of $50 total paid of $50 this does happen. Sometimes, you’ll, you’ll see people go online. Occasionally, they might accidentally sign up for a pledge, and they don’t mean to. They’ll, they’ll call in and they’ll, they’ll ask for that commitment to be stopped. And you could change the pledge. Initially, it would have been this a total of $0 further more monthly giving would have been set to yes if this were an active pledge, even if it wasn’t monthly, if it was annual, quarterly, semi annual, weekly, if it’s going to be charged automatically, monthly giving is yes, meaning payment method is required. You prepared, but certainly not the case here. Monthly giving was set to no at some point, even though this is a fake person. Actually, this is my buddy in the neighborhood. I add my friends to the database, but if this was actually a pledge. I would want to see a note in here. If Anthony had called in oops, I clicked the wrong button online. Can you please stop that? It would be a good idea put a little note in here. Pop today’s date. Talk to Donna. Started by accident. Years from now, we’ll be able to see this, and then if it ever pops up in a report, we’ll know exactly what happens. And those, structurally, those are the most important fields to this thing called a pledge. What our dates are, what the amounts are, is it turned on, is monthly giving enabled. What’s the frequency? But we can, and really should be, giving it a lot more detail born from this pledge and connected to it would be a gift that has the same exact codes that we’re seeing here, General Ledger. What’s the fund it’s going into? Yeah. Uh, what’s the campaign that brought about this commitment? And here the solicitation was annual appeal 2024 but, uh, that makes sense. We might have many different efforts across the course of a year that will bring about a pledge like this, and we’re going to see some reports where we can isolate those gifts and maybe see which which of these fundraising efforts did the best. So this and this is going to be different in your system, you might have a different coding scheme for campaign solicitation and sub solicitation. Let me actually, while we’re on that subject, let me pull up this. This is maybe a hair two elementary but just because it is very important, I’m pulling up an infographic right now. Here it is this my colleague Amanda made this to illustrate what a possible coding scheme could look like, using these drop down menus where we have the light blue these are so our solicitations. These are year specific, and if we are doing several different fundraising strategies as part of a grand strategy.

We might refer to that as a campaign, and maybe not the case for monthly giving, but for appeals, we could have different segments, if that actually this would be a good way of doing it. If we had a segment of that appeal that was specifically for monthly donors, we’re sending it out at the same time of year we do every year, but we have our new donor segment. We’re sending them communications with ways for them to donate, and are ensuring that we have these codes when they do donate, we can lock those in on the online forms, and then we can follow those donations back into DonorPerfect, but only if we’re labeling them that way, and even even me practice as I say, not as I do. It would have been great if that pledge example that we were looking at that said annual appeal, if it had monthly donor segment on it, that is an that is a sub category of this fundraising effort. But this is an art, and it certainly shouldn’t be a decision you make on your own. Talk it out with everybody that’s doing data entry. This is, this is how we happen to have it, and maybe, yeah, see, we do have a monthly giving sub solicitation, but made a very human mistake and just didn’t apply it earlier in January, whenever this came in.

And one more thing to look at here, if I scroll down, okay, I wanted to see who made this. If you scroll down to the bottom of a gift or a pledge, like I am. Now, while you’re editing it, you can see who created it. And here it looks like Donna, because that’s Donna’s user ID. Donna created this back in January, earlier this year. And then we can see Sean patero His user ID. Me modified it just today, so that’s a piece of piece of the puzzle as well. What my thought was was, if this had come in from online, I might want to take a look at that online page where this would have came from. This is a screenshot from the classic forms, our online forms for donations, and you have the ability and the option to add some of these codes on the back end. The person goes to the form, they pick what their frequency is, how much they want to donate. They pick the start date, just by the day that they make that initial transaction. But you get to decide how that pledge looks. You get to decide how those pledge payments look. All of that’s on the back end of the form for any of the forms. This is classic forms I really should add. Ed, I don’t have a screenshot of the new forms, but same deal there. You can have codes on the back end. And if you’re using give cloud, or if you’re using any of our other non connected softwares, you give whoever you’re using for donations, you should be able to attribute some type of unique values to it. Yeah. It, and hopefully you have them in there. If so, you can lock some of those answers in. And as always, when we are reporting, step one is to know how this information is being recorded. Okay, I want to find my monthly givers for for 2020 well, did we have a unique solicitation for monthly given, 2020 did we have a thank you letter code because we had a unique email and letter template? Were we classifying this as a campaign, as a big strategy from event to event. It really all depends. And you might have inherited a database from somebody else, and that person’s not there anymore. You have no idea how they were recording it previously. That’s okay, because there are still structural elements of these pledges and the pledge payments that you can use to identify them, even if there wasn’t a unique monthly giving campaign code that you had and you know, wasn’t added or people weren’t consistent, that’s fine. There are still values of the pledge and the gift that you can use. One is a field called record type. Record type is not a field that you see very often, or maybe even think of, until you start running a report like this, because essentially, when it comes to the finances of a constituent profile, yeah, they could be they could be gifts, or they could be pledges. If we’re finding somebody that has a pledge, it is going to have a record type of p when we’re looking at the profile, they’re on different areas. The pledge is recorded separate from the gift that it’s attached to. But the pledge itself, there’s a field called record type, and for that pledge, it is p, and the opposite would be true for the gift, it would have a record type of G for gift, or if you’re recording soft credits, those things on the gift screen would have a record type of S for soft credit. We would also have a check box that’s on the gift screen. This is another one a lot of people don’t realize is their pledge payment. It’s a check box, and if it is checked off, it’s a pledge payment as a checkbox. It actually doesn’t even allow you to check it, but when a gift is attached to a pledge, it checks itself off. There’s a couple steps that you have to do to connect it. And then this is something I did earlier pledge records, and they’re created by had that pledge not been created by Donna, but it was created by an online form, it would have a couple different created bys, W, l, a for our classic forums, or DP forums, for our new forums. Or if you’re using give cloud, it would say give cloud and not in the case of the example I saw that one Donna made, and then gift type for online recurring gifts, if it came from an online form, you might Have a gift type that’s locked in on there. So sure. So let’s take a look at some of these, at some of these values, and let’s capture some of these folks in some reports. And let’s say I am on that pledge still, and I’m looking to see, I don’t believe we have the record type field set to display on the pledge, but we’re on the pledge screen. Anthony here certainly does meet the criteria. This has a record type of p where this is going to be abundantly obvious is when I come back and I look at the gifts. Let’s look at this one here. Let me edit this here. We can see the record type. It is a read only field. I can’t change it. It is a gift, as opposed to a pledge or a soft credit. I. And it is also a pledge payment. This box would have automatically been checked off because it is connected.

And, yeah, let’s use this. I was see, we do have monthly giving 2024 but I could still find my pledge payments in a previous year, even if we didn’t have a specific code like that. So I’m going to, I’m going to leave this example profile open, and I’m just going to go over to reports and Report Center, where all of our fact finding begins. And I’m going to start off with one that I did yesterday. This is our daily log. Now I’m going to I’m about to build a selection filter. If this is the first time you’ve seen any report or seen selection filters, I would check out my webinar later today, at three I’ll be going into this a little bit more. We also have other webinars that go into this in great depth, but essentially, these selection filters are going to be the instructions for the report, the daily log report that I just selected. It’s just a list of columns in results. I still have to pick what the results are, and step one is to know which records I want in the output. We’ve accomplished that I could use any field to determine my output. There’s over 750 maybe even more, if you’ve created new fields, and I could use any of them to determine my output out of my whole database. What do they have in common that I might want to see in the results many different fields that I could use. But in this case, it is a checkbox, and it being a checkbox, very easy to analyze. This it’s not necessarily an amount that is greater than or less than something. It’s either checked or it’s not checked. Checkboxes are real easy to look for, and in this case, we’re going to use that value to find these people.

Okay, and I have my sidebar here, but I’m not going to use that. I’m going to go right to the selection filter. There’s none selected right now. I’ll click on apply so I can build a new one. I definitely I have my own folder in here. I know I’ve made this filter before and I could reuse it, but I’ll show you how we can make a new one. Start by clicking on add new filter. Now this process always works left to right where we are writing our instructions for the report, and essentially we are saying that for this report, that pledge payment field has to equal yes out of all of the fields we could use in all of these different screens, in the profile, the one I care about right now is on the gift screen, and it’s called pledge payment. Step one, I’ll pick where my field lives. It’s on the gift pledge screen, and now in box two, I’m only seeing the fields from the gift screen, but I’m not seeing the fields that I need right now I’m seeing some helpful ones, like frequency. We might find somebody that has a monthly frequency or a certain start date, but I’m looking for that pledge payment. It’s not one of my favorite fields. This blue option, it would allow you to pick and choose, select your favorite field so it just pops up. No big deal. I’ll click on All fields, and now it’s showing me all of the fields on the gift pledge screen that I could use to narrow down my results. Don’t let this intimidate you. It did for me when they were teaching me all this. It’s a lot, but I don’t care about 99% of these fields, most of the time, especially now, the only one I care about is pledge payment. And we’ll see that in box three, a lot of my options went away when I have pledge payment selected, it’s either checked yes or not checked, which would be different from, say, something like a gift amount, where we could find amounts that are greater than less than between pledge payment is checked or not checked. Easy. So. Uh, I’ll say yes, checked, and then I’ll click on Continue. I could give this a name if I wanted to save this for the future and put it into a folder and share it with my colleagues by checking that box down there. But we don’t need to. We can say done. It doesn’t need to be saved forever.

And I could use this selection filter in conjunction with the sidebar, you could use both, let’s find, let’s find my 2020, folks, and then run and here we have it, and it looks like this is verifying consistency of those solicitations. We do have columns in this one for general ledger and solicitation. This one also has a column for Pledge payment. We almost retire the Daily Log. But a lot of people like this, and this is one of the reasons. It tells you whether or not it was a pledge payment. Obviously, I’m focusing in on those. So all of these are going to say, yes, ah. And see here I have in 2020, solicitations of monthly giving, 2019 and that would be from pledges from the previous year, the year before that, the pledges, let’s take, let’s take a look at Jack Saunders. Here we can look click on his name, go over to his record. Yep. Start Date, 2019 uh. The day of the month is, uh, September 15. So it always be the 15th that they’re charged monthly giving solicitation, 2019, and as always, we have our running list at the bottom. So in future years, we can still see how well that initial campaign did, went from 2019 all the way up till 2022 and there’s going to be a report that that highlights that pattern. But it’s only because my colleagues and I were were consistent with that data entry.

One of the benefits to having a year specific solicitation, that’s one report I’m going to do one more that wasn’t originally on our agenda for today. If you go into the Report Center and look in the search box and type the word pledge, it gives you 10. Actually, we do pledge singular, it gives us 11 different results. If we want to look at a list of pledges, I am fond of pledges dash listing. Out of all of them, they’re all very helpful. But I like pledges dash listing. I’m fond of this one. And if I want to find all of my folks that are set up for active monthly giving, Jack Saunders here and Anthony not going to show up in there. We can see, even in the donor profile, that it’s not lit up, and that is because monthly giving has been set to either blank or set to no anybody that is set up to be processed automatically should have yes and again, even if you don’t have these monthly giving specific codes in your drop down menus, you could still use a field like monthly giving to find those folks for any of these frequencies, we’ll see if there’s any non monthly but that is the most common. So pledges listing. I have my sidebar again. Make sure there’s nothing in here that gets in the way, and I’ll go with my selection filter. My field is on the gift screen. I’ll go to all fields. Now, monthly giving is a drop down. And in my opinion, I think it would be great if, when you selected a drop down, if in box three, I wish a lot of these options would go away less than greater than between these are ways that you would analyze dates, amounts. A drop down is going to be equal to, not equal to, or maybe it’s a big drop down with a whole lot of options. You could include multiple matches, uh, here I’m just going to say equal to lookup code. Is select Y for yes, continue, and then done. And now, when I run this, my instructions say that pledge that this report is designed to show us, has to have monthly giving set to Yes. Another reason I like the pledges listing is that it has a sort order that you can determine so I could sort this by start date. This would also be the report that I would advise that you run if you just had payment processing enabled. Or if you have a database where there weren’t any recurring donors for a while, I would run this one before enabling the actual master module that controls the process, just in case, because these are the ones that are potentially going to be charged because monthly giving is set to yes. I also like this one. It is a little much, but it crams a lot of data in here gives us the pledge amount, how much is received, what the balance is, if they’re delinquent at all, and the codes that are on there, and that’s pledges dash listing. I think if I had to show another report like that, it would be pledges, pledges balance due. Pledges balance due. Once you run that, that one has hidden instructions where it will always show you pledges that have a balance.

Do you uh, these next ones are also very helpful. Some of these you might not have realized are in there unless you went to a webinar like this, uh, comprehensive donor revenue analysis. This one comes up in four or five other webinars that we do, and it’s favorited for you. It’s right at the top of the list. Same thing with cross tabulation, income analysis and gift pie chart. Income analysis is all right, but gift pie chart, Oh, this one can show a lot of good graphs, but one at a time, one at a time. Let’s start off with cross tabulation.

Do uh, reports, reports and Report Center.

And now which reports we have favorited with yellow stars that is set on a user by user basis. So I have a lot more favorited reports than you do. Starting off, there’s maybe about 10, and the one I’m looking for is called cross tabulation report. This one also has a unique sidebar in in that it’s going to allow us to determine our X and Y axes. This will make more sense in a minute, but we are going to show the correlation between general ledgers and solicitations. Let me narrow this down further. It’s looking at this calendar year. Let’s go back a few years, and let’s change this selection filter. You’ll notice the selection filters follow you around like a lost puppy. Sometimes it’s helpful to analyze the same segment over and over again in different ways, in different reports, but this one’s going to get in the way. Let me bring back that pledge payment one.

We go pledge payment equals yes, and the date range is in this time.

Okay, so my field to show along the left is going to be general ledger. I could have picked another field to compare, but I think this one’s pretty helpful. We see all of our funds on the left hand side, and then our field to show along the top is solicitation. And since everything that we see is correlating to a gift that is a pledge payment. And we can be sure that this column for annual appeal 2024 has $360,000 worth of pledge payments. Now you might notice that this very first row is blank because on the left hand side, I am grouping by General Ledger code. The first row is always going to be where that field is blank. So in this case, I do have 37 gifts that have annual appeal, 2024 as the solicitation, but no general ledger. Likely, this came in from an online source. I have this as a required field. I want to be able to save this. Let’s see, scroll down to the bottom. Ah, here is another created by that we could consider running. We could find everything that was created by auto EFT that is something that every pledge payment will also have in common auto EFT that’s essentially just monthly giving, monthly giving win in there, in charge of them, is what auto EFT is. But everything that was created by auto EFT is also a pledge payment. So this one a bit a bit easier to find that same group. And let’s see, I reckon, just like from those pledges that I saw earlier, even though I am looking for a date range, in 2020 we still, yeah, might see monthly giving from previous years. So between 2020 and 2024 we still had 49 monthly giving, 2016 donations come through, as always with these reports, anything you click on you can drill down into, to get a mini report.

Another interesting way we might run this one is to compare uh campaign, and I could only do this because our codes are set up this way and have been for pushing a decade, uh, and if we haven’t been consistent again, the report will highlight it. We do have a monthly giving campaign. There might be some overlap with some other efforts and our recurring donors, but we’ll see. And let’s see, how are people paying the type of gift field, also called gift type? Let me find it that is the format of payment, Visa, MasterCard, American Express bank account. How are our recurring donors paying?

Here? It is.

There we go. Okay, over to the right, at least in this date range for our pledge payments and most likely the pledges that are attached to we’ve been pretty consistent. Our first row is always where the value is blank. We can see that most everybody’s fallen into the monthly giving program, but annual campaigns that are typically being ran in conjunction, maybe with some events or with some mass mailings or email blasts generated some monthly givers as well, separate from the Monthly Giving initiative, which you may or may not have.

And not seeing any real trends in my fake database, since we actually don’t have a type of gift for a for a lot of these examples, there’s only so much that I can recreate in theory by processing fake donations, and that’s the cross tabulation report, very helpful for seeing trends, very dependent on consistent data entry. A good way to find inconsistent data entry if you want to do a little cleanup too. This next one. Is income analysis.

Now this one’s a little bit different, no sidebar on a report like income analysis and same thing with the next one as well. No sidebar on some of these, the more complex they get, I tend to tend to lose the sidebar. We do have a date range where we can pick an ending date range.

We can also segment our results, maybe I’ll select solicitation instead, and this time, instead of my pledge Payment filter, let us do something broader, since that other report I just ran confirmed that our campaign monthly giving is pretty consistent, let me do on the gift screen. Campaign is equal to our monthly giving program, and then we have the splits. This will make more sense in just a little bit. So our splits are going to group together by donation amount. So for the annual appeal, 2024 in this month, we haven’t gotten anything. But this year to date, we have seven in the 10 to $25 range, four in the 25 to $50 range, and then dropping off a little less as we get higher in the 50 to $100 range. We only have four year to date, and over 100 we only have one. And this is where I wish I could be showing you reports from a real nonprofit, because here we can start to get trends on how people are giving with a report like this, we could see how many people are donating at different levels, and perhaps might go into our strategies for asking amounts, because I chose to segment by solicitation. That’s going to be the grouping on the left hand side. Uh, what everything has in common is that campaign, campaign of monthly giving programs, some of it from annual appeal. Some of it from monthly giving, 2016, none in the current year, uh, calendar year income analysis. It is focused on the here and now, but depending on how you filter this, it may bring in some old things. Here we go, monthly giving 2018 we are seeing monthly giving that started in 2018 that is ongoing this year, not too many in the lower end of things, uh, seeing a little bit more variety for monthly giving. 2023 as we’d expect, fewer people have fallen off. Uh, constituents that are in a monthly giving program have a donor retention hired at 90% if it is monthly, if that is the actual frequency once a month, their donor retention from one year to another is going to be closer to 90% and that’s calendar year income analysis with splits. There is a fiscal year equivalent to that as well. Speaking of donor retention, that brings us to our next report, comprehensive donor revenue analysis. This one could be a 60 minute report. It could there’s, there’s just that many data points that are in there. And again, we don’t have a sidebar on this one. It’s going to let me pick an ending date, and interestingly, it has two options for filters, a donor filter or a gift filter. I’m not a fan of the way that we phrase this gift filter is to say we have a selection filter that’s using a gift field. Or we could use a selection filter that’s using a main screen field. We could run this for, say, a state of Pennsylvania. Or we could use a gift filter for a campaign of monthly giving campaign. But I. Do monthly giving campaign in Pennsylvania. The more complex some of these reports get, there’s odd limitations on the filtering. But here I’ll use a gift filter, and I’m going to do campaign equal to monthly giving again, that’s a gift filter. I’ll leave it at today’s date, and then I will click on screen.

And now what I have are five different columns. The very first column is my current year. There was a spot there for an ending date, which I left as today. So that gives us our current year, the last 365 days. And what all of these donors and donations will have in common is that there are gifts with monthly giving campaign on them. And in this year, we had active donors, 88 people with a gift that had monthly giving campaign on it, which takes us down to our retained donors of 6767 people in the last 365 days had monthly giving campaign on it. And the previous year, the previous year, there were 74 active donors that had monthly giving campaign. And of those 74 last year, we had 67 that were retained. That gives us our donor retention of 90.54% now that is a small segment. If I go to Reports and dashboard, this thing called the organization dashboard will give us our all, our overall donor retention. Or I could have ran this without a filter, and it would give us the appropriate donor retention. But because I am filtering for a subscription audience, this is even though it’s a fake database that stats in line with industry norms, new donors, first time donors that are given to monthly giving, reactivated donors, people that stopped and then started again, or our attrition groups, any of these blue numbers we could click in donors for three plus years that had monthly giving campaign, but we lost, and then it compares it to the two prior years, and we have differentials in the last couple columns.

This next one is definitely not going to be favorited for you. You’re gonna have to find this one, and it’s going to be in the other report folder on the left hand side, where I sometimes called call this our hodgepodge miscellaneous folder. I think this would be right at home in financial reports. It’s called The Gift pie chart. The gift pie chart.

And another unique one, yeah, we can go 2023 up until today for date range. And I have a drop down menu here that’ll let me pick any field the cross tabulation report. Let me pick a bunch of gift fields to compare. Here, it’s letting me pick main screen fields, gift screen fields here, I think I’m going to go with solicitation for this one, and we’re going to see a segment that we’ve actually already seen pledge payments in a time frame, but here I want to group them by solicitation.

Oh, boy. Why is that listed twice? Huh? Well, we’ll find out if that’s the right one.

Be careful creating new fields. One might exist already. And you know what? Let me go back so we have more time and my selection filter, yeah, we can leave that as monthly giving. That’s been pretty consistent. So this date range and monthly giving now what we’re going to get is a pie chart.

Ah, interesting. When. We have the campaign equal to monthly giving. Every single thing except for our other group has a solicitation. You know what? Actually, I reckon this 2.7% these are probably some of the miscellaneous fundraising efforts, like the annual appeals and some of the events that might have drove a person to start a monthly giving otherwise, 2016 on top for the past four years. That’s one way we could see it. We could see it as a count, in this case, a count of gifts in that time frame. But we could also break this down by amounts where, oh, we have a new contender to the throne, monthly giving, 2020, just beating out monthly giving 2021 see how are we on time? All right, we got time for one more, and this next one involves no work. You just have to go to Reports and dashboard.

And when you load it up, it’ll take you to something called my dashboard. And this you could customize. You could design this with various financial reports. What I want to see, though, is the monthly giving dashboard.

Now, this one is a little bit unique compared to the rest of the reports. Well, one, I don’t have to tell it to do anything to show my 12 month total of recurring payments. I don’t have to see what my conversion rates are. Here they are. It just runs. It does all the math for me. But this is not including anybody that is on a manual pledge payment before. If I’m looking for that monthly given campaign or pledge payment to be checked off, it technically could be not automatic. If it’s somebody sending in a check or cash occasionally monthly giving dashboard here, this is just things that DonorPerfect processes, including annual or even orderly. And, oh, let me pull this up. I know I had it up. Where did that slide go? Okay, moving on to our recap. And then if anybody needs it, I’m looking for the monthly giving dashboard, and I’ll put that into the chat for anybody that needs it. Very helpful resource, the monthly giving hub. Consider, consider your data entry and how you are recording information. You might not have paid attention to those drop downs too much, but it will help you out in the long in the long run, if you have some type of unified strategy and it we do have other webinars where I’m talking to the audience a bit more and kind of generating ideas. And I love those webinars because I the creative plans that people come up for their monthly giving programs is so impressive. They have branded names for them, they have newsletters that go out. They treat them like they’re a special part of the community. And I always love hearing about that. But however you’re doing it, do it as a group, especially when it comes to the data that’s being entered, we can have different people doing different things. And if you’re new to monthly giving, and you maybe went to the webinar yesterday where I taught you how you could turn monthly giving on, I’d reach out to the Support Department. Hey, I never, I never. I’m about to toggle this switch on for the first time. You know, look at this report with me, make sure I’m doing it right. There’s a lot going on. Doesn’t hurt to ask for help. And if anybody has any questions, please feel free to ask away. I am pulling up here is that link. I’m putting it into chat hosts and panelists. Let me send this to everybody. Okay, so I just put that link into the chat. Do? Here’s what it looks like. And there is a sign up at the very bottom for you to download the monthly giving success kit. That is the full collection of everything that our marketers have created to guide you on the right direction. It even includes a monthly giving calculator, which is pretty neat. If your campaign you are aiming for a certain amount of people, it’ll help calculate and keep you on track with your goals.

And that’s all I have for everybody today. Thank you so much for stopping by. If you have any questions, I’ll hang out for another few minutes or so. If anybody has anything, if not, thank you for stopping by. Keep up the good work. 

You’re welcome, Kelsey, take care. right. Looks like that’s it for everybody. Thank you so much. This has been reporting on monthly giving. I have been Sean Potero, and you have been a great audience. Thanks everybody. Take care. Bye.