Video: Ask The Expert about Standard Reports | Duration: 3504s | Summary: Ask The Expert about Standard Reports | Chapters: Welcome and Introduction (3.76s), Understanding Database Terminology (107.395s), Gift Entry Terminology (310.99002s), Standard Report Queries (577.23s), Soft Credits Explained (968.35004s), Support and Resources (1508.395s), Aggregates in Reports (2180.06s), Technical Issues Resolved (2730.875s), Wrapping Up Session (2756.415s), Additional Support Resources (2952.385s), Blackbaud Engagement Programs (3124.645s), Community Access Guide (3285.3801s), Concluding Remarks and Outlook (3360.34s)
Transcript for "Ask The Expert about Standard Reports": Hello, everybody. Welcome to this week's or this month's Ask the Expert session. Of course, I'm Geoff Arbuckle. Glad to always see people coming in and, saying hello to everybody else that are attending here in the chat. That's always, appreciated, and that's always great to see that interaction. I hope everybody is having a good Wednesday. Yes, Addie. It is hump day. We're all it's all downhill now for, for the weekend to come. So, hopefully, we are all rushing into the weekend, in good spirits and in a good place. Of course, I am broadcasting from, Indianapolis, Indiana. Sunny, but a little soggy. We had rain all morning, but, things are starting to, get a little bit nicer out. So, hopefully, the spring weather is, treating everybody well, where you're at too. See a lot of folks from Virginia. I see, Judith, always glad to see you, and Louisville, not too far away from me, a little over an hour. Bella, good always to see you too up there in Saskatoon. So fantastic. So before we really kind of get into what questions you folks may have based around some of the other, some of the other stuff that, that we talked about last week with the, with those standard reports. I did wanna talk and kinda cover a couple of things that I didn't really get too much of an opportunity to cover in the slides that I had from last week's session, but also wanted to be able to, talk to folks about, one of the big questions that came up as well during the course of the session. So let me pull up my eTapestry here. I believe it's this yes. Alright. So one of the big questions that people asked, which I think honestly is one of those kind of terminology things that people always, do have questions about. And that is what's the difference when we refer to things as gifted, pledged, received, raised. And what does that actually mean? And what fields are that actually you know, are those kind of terms kind of focusing in on and zeroing in on as well? So let me actually pull up my account here inside my database. And let me go into the journal. So I kinda wanted to to illustrate this to you a little bit further just so that you had a better understanding because you're going to see these terms used all over the database. I mean, in fact, right here, one of the default columns that is in your journal are the is the received field. Oh, thanks, Cali. Yes. Captain America, it's comic book day. So, yes. I decided that, before I head out to the comic book store, I would definitely, wear my, Captain America shirt. So, but as I was saying, the received column is one of those default fields that you're gonna see all over the place. Now when you're looking at it in the journal, I think it makes a little bit better sense to folks. Right? It it's what you received. We have a payment here of $250, or we have a gift of a hundred dollars, or whatever the case may be. Right? It's pretty straightforward as to what we are referring to when you see it in this kind of context. The same thing kinda, can go into effect when we look at it from adding a journal entry as well. So when you are looking at adding a journal entry, if this was a pledge, you would put in the pledge amount. But if you were actually putting in a check or a cash donation, you would put it in under received. So, again, the kinda the context around that, I think, kind of makes a little bit more sense when we are looking at the term received. But when we are thinking about it in terms of a report or a query, you might see things like individual transaction received or individual transaction raised or individual transaction gifted. And that, I think, is where some folks end up having a little bit of, a little bit of confusion and a little bit of, you know, trying to figure out what we mean by that. And it still ultimately comes down to these two fields when you are entering a new gift or a new pledge or if you are, entering in a new, a new payment to a pledge. You will see received amount. So, again, when you are looking at the terms pledged, gifted, received, raised, when you're building a report or you've exported a report or you're building a query, it comes down to received is physical money that has come in. It doesn't matter if it's an individual gift or in this case, a payment to a, pledge. It also doesn't matter if it is a, recurring gift as well. A recurring gift has a received field in it if you are entering in or you are looking at a recurring gift. Oh, yeah. So as far as enlarging the image, I it's not very easy for me to do that without it really kind of changing around what is actually, able to be viewed on the screen. One thing you should be able to do, there should be, like, a little cog wheel or a little, expansion arrow that you can use in, to make it full screen, on your screen. So the instead of, having it kind of compressed down, you can you should be able to expand the, the what is being shared and what the slides or what the, section there that's being shared on screen. So I would recommend doing that because I know sometimes if I expand this, which I can expand it a little bit, but I also don't wanna make sure that it doesn't throw things too far out of whack here for you. So I was able to expand it a little bit. Hopefully, that helps. But yes. So the so yes. So received is anything that you have physically received, and it doesn't matter if it's an individual gift that you've entered into the journal. It doesn't matter if it's a pledge payment or a recurring gift, entry. That also can play into one of the other things you can add to a journal. And this is taking a little bit of extra time to load for whatever reason. Gotta love technology when we're doing live things. But that also comes into account and you'll see it here. I have a disbursement entry and you'll see that hundred and $50 is in parentheses because it's a negative amount. So disbursements also have, this disbursement amount can also play into received as well. So basically, it is any kind of physical money coming in and out. As far as the entry, as far as, like, what it means to be raised, now raised looks specifically at and let me come back here to a new gift pledge screen. A raised amount specifically looks at what was entered into pledged amount plus any one time gifts that have a received amount. So gifted are those one time gifts or recurring gifts. So, that those are gifted amounts. So whenever you see gifted, that's not looking at pledge payments, and that wouldn't necessarily, and it would just look at those one time or recurring gifts. Anytime you see the word gift, basically, in a journal entry. As far as ray, received, received is again anything that comes into the received amount that's pledge, that's, pledge payment, that's gifts, that's recurring gifts, that's disbursement. So when you're looking at the raised versus received versus gifted versus pledged, it comes down to the makeup of the actual transactions themselves, and what is being counted particularly when it comes to raised and received. Oh, as far as the recording of the cleanup webinar, those should be getting posted over to our re our eTapestry resources page. Let me see if it's there currently, and I'll send you. Does not look like it has been updated there yet, but usually, you will find the, the past recordings at the link that I just put into the chat there. So I do recommend everybody bookmark that because normally after a session is completed, it falls off of that registration page. So keep checking this page. This first one from, April, the, compound queries, has already been added there. So it will only be a matter of time before that cleanup will be added to this page as well. So as far as some of the, something else I wanted to talk about when it came to the, eTapestry standard reports. One of the things that you may have noticed when I was looking at the various, different types of reports that you can get here, particularly like the top donor report, you may have noticed that I was constantly selecting base all constituents. Now with base all constituents, that is, definitely something that, all of these reports are able to use and get you information even if this information, like the top donor report, is designed to be a financial report. One of the the big rules of thumbs that we always say about reports in general is, well, if you want to get transactional information, your query has to be a journal entry return type. That does not matter as much for the standard reports. If you wanted to find specifically the top donors from the, from, like, last year or this year so far, then you would need to have a let me oh, where's where's last year? There it is. You would need to have a journal entry report because then that in you know, so for the top donor report, if we wanted to see all of the people who were the top donors last year, then you can just simply use the category constituent journal entry date and the query last year, and it will just pull the last year people. The big difference typically comes down to being whether or not, people are, looking for overarching, like, you know, the top donors of all time versus the top donors of last year, or in some of the other reports that we talked about, like the recognition report by gift amount ranges or the activity summary reports. If that was something you were looking at for all time, base all constituents is good. If you need something more specific, it might require you to use one of those constituent journal entry date like last year, this year, last quarter, last month, whatever it is you want to look at. Or if you need it to be a lot more specific than that and you only wanna see people with a certain user defined field selected from last year or something, then you would have to create that query itself. But all of these reports generally will work to give you all time data, basically, with the, base all constituents query. The one exception are the executive reports. These executive reports almost entirely work specifically with base all constituents and won't allow for you to put in, say, like, constituent journal entry date last year. The reason for that is is that these executive reports and in particular, like the donor renewal rates or the GivingDynamics report, those are specifically looking at the accounts activity from one time frame to the next. If you were to pull in a journal entry date query or, I'm sorry, a journal entries return type query that says I only wanted to find I only want this information from this group of journal entries, something like the the, Giving Dynamics report will not stick to simply those journal entries. It looks at the account as a whole. So rule of thumb, every, every executive report use base all constituents because that's typically looking at all time data or, looking at the data from the entire account between two date ranges. All of the rest of them, that ask for a query, you can use base all constituents or something more specific if you need to to be able to display things like top donor, summary, the gift ranges, so on and so forth. So that was one thing I didn't really get to to talk too much about last week because I really kinda wanted to talk more about what the reports can do. But when it comes to the, to the running of those reports, certainly, definitely recommend that you do, you know, to to do that. So yeah. No. As far as I need a report of all constituents since we began, to use eTapestry. Something like that. Honestly, I would probably look at either doing, like, the account list or possibly the journal entry list. The journal entry list will give you all of the journal entries that were entered. But if you're just wanting to see all of the accounts that are in the system, I would just come here to account reports and do base all constituents. Depending on what else you need to, to include on the, on the report itself, then that might be something where, certainly would recommend, reaching out to the support team through chat, asking about, like, a, because we do have some step by step knowledge base articles that can get you more, like, customized information to get exactly what you're looking for. Alright. Okay. So I will pause here for a moment. And, if anybody has any specific questions that you want to ask, I'll give everybody a chance to put those into the chat. And so as I pause, I will take a sip of my drink, and then we will, see what comes in. And otherwise, I can talk about a couple of these other reports as well. One question that I did get through the, yeah, q and a. That was actually, Jeanette, that was exactly what I was going to, that I was going to bring up. The soft credits yeah. So soft credits are almost entirely separated from gifted, received, and raised. So, yes, that is one thing. If you do heavily use soft credit, amounts, like, when you are I know somebody asked last week what is a soft credit, compared to what we would refer to as a gift or a hard credit. So a soft credit like, let's say I am going to make a donation and Blackbaud is going to, match the donation that I made to one of your organizations. I make a donation of, say, a hundred dollars, and then later, Blackbaud sends along whatever their match ratio would be, which is, I think, like, $50 or something like that. What you would be able to do when you receive that $50 from Blackbaud, you would then be able to say, well, we received this because Geoff gave to us. So we can put Geoff as the soft credit, which would tie to his account and say, you know, Geoff overarching, influence or assistance to us or, well, I should say, his overarching support of us and the influence he has to help us raise more money, was able to, show that he gave a hundred dollars and he was soft credited on that matching gift from Blackbaud because without him, we received that. So let's see here. Carol asked them, how do we, yeah. So how do we exclude grants which were entered as well? So when it comes to something like that, so that's where we get into, like, where the query would come in. So, like, maybe you don't want people who make large grants as part of your top donor report. Now it comes down to how the entry was put in as far as, you know, if you have a specific fund or a specific campaign or a specific approach that you mark those, those specific gifts that you don't want to see. One of the ways that you could do it is and most of the time, I would say, if I were to make an assumption, most people would probably enter grants as a specific fund, or possibly a specific campaign. But the as far as the query that you would set up for this, what I would do is especially if it was just listed as funds, what I would say is, okay. Well, first, you want this to be journal entries as the return type because you only want specific journal entries to appear in your, in in terms of your, results. You only want those journal entries that are not, grants. And then what you can do is you can select whatever funds you you want to include that would not be the grant. So, like, let's say general operating instead of general operating instead of grant. I would select all the other funds except for that one and then run the query that way, then use that query, like, in your top donors or in your dollar amount range, re standard report or whatever the case or whichever report that you wanna run. Now the only downside to that is is that you would not really be able to exclude that type of stuff from, like, a, the Giving Dynamics report, the executive reports. Because at the end of the day, if somebody if somebody who made a grant also made other, contributions, their grant is still going to be taken into consideration on that from their account. So that's the one downside to that. Otherwise, if you want to remove those people who make grants totally, then that would be get a query of all the people who give grants, and then use a compound query to subtract them out of your, of your query of your all constituents query usually. So it kinda depends on what on how that stuff is entered and exactly what you want that to show. Again, that would be something that would be, you know, certainly, something our support team would be able to to assist with as well. Judith, I will come back around to your question about aggregates here in just a moment. So yeah. So Mason asked, could you show me how to pull a list of donors who gave between 750 and 999 in the past calendar year, for example? So there are two ways you can do that. You can certainly do that with that, dollar the gift range, standard report and be able to say, okay. Let me pull that, standard report up here and show you how you would be able to do that here. So yeah. So you do go to the recognition report according to, gift amount ranges. Your query can be, constituent journal entry date as the category, and last year is the calendar year. So that would be last year, so 2024. And then you can only put in, if you want, that one specific, range. And then, if you want to show the group totals, yes, or if you wanna show you could have it like that and it would show those people listed. However, if you want a query to be able to use, like, for a, communications or another type of report, then for the query, how we would do that is when you create a a new query, you would name the query. You would say, okay. Well, base all constituents is perfectly fine to use as a starting query. You can also use that same constituent journal entry date last year. Either one is fine. So base all constituents or constituent journal entry date last year. Either one is good. I would probably oh, actually, now that I think about it, we do okay. One thing I do wanna say, as far as the starting query, this is the query that you definitely want to have as the starting query. I didn't think of something that we will need to pull down here in the criteria. So your starting query will be this constituent journal intraday and then last year dash j e. That must be the starting query for the one that you're looking to do there, Mason. Sorry for the confusion there. Depending on what you wanna do, if you want to see their grand totals in a report or in a communication, then I would do journal entries as the data return type. If you just want their account information for whatever reason, then accounts is fine. We'll just say, okay. Well, this is the, this list of people you wanna see, their actual journal entry information, their gift information, and so forth. Then down here now remember, we already have the starting query giving us the last year criteria. So the only thing we need to pull in the criteria section is we will change this from commonly used fields to, to cumulative amounts, and we're going to do cumulative raise. Now cumulative is going to look at if somebody gave more than one gift and they end up in the in the dollar range, then they will count. If they only gave once and they end up in the dollar range, great. If they gave two or three times to hit that dollar range, then they will show up as well. So cumulative re oh, and I'm sorry. I selected cumulative raise instead of cumulative received. Sorry. So cumulative received will take into account all of those transactions from people to be able to do that. And then you would say greater than or equal to 750. And in this optional comparison section, you can say less than 1,000 or less than and or and or equal to nine ninety nine dot 99. Okay? So that would be my, recommendation on how you would build that query, Mason, to be able to do that. Tiffany. Yes. So as far as the, way to be able to see the, columns and fields that are pulled into the standard reports before actually running the report, what I would do is, go to the k b. So kb.blackcloud.com and search for standard reports. That will pull up a result of the help document section, or you can come in here under the question mark and click on help. And, you'll be able to search for standard reports there. Each one of the standard reports should be listed there, and it should tell you what the, columns that you would see and what those columns mean as well. So it will also give a definition for what that column is. Yes. So actually, let me just, it's this page here. I just put that into the chat. And if I were to search for standard reports and I go to eTapestry, it'd be the very first result. So when I click on this, it will have all of the different categories of the reports. And when you click on that, it will then say here are the reports in there, and it should show you oh, it doesn't show you all oh, it does say here. It shows the name, city, state, postal code, and phone number for those accounts. If it is a, especially if it's a report like the, like some of the executive reports, that's where it will go in and give you, like, definition. But each one of these should tell you basically what it's going to display in those reports. Should give you an idea of what that of what you would see in those. Yes, Deborah. So what I would say So, Deborah mentioned here, I enjoy the webinars. Can I ever speak with someone directly to help me? Now, of course, working with support I mean, the the the primary access point to support that all of you will have is under this question mark icon and going to the chat now. Now by default, the first thing that's going to come up, much like a lot of other places now, is going to be a chatbot that's going to try to provide you the answers. You know, if you ask the question, it will try to provide you usually some sort of a, knowledge base article that can assist with that. However, there you know, if you ask for it to connect you to a member of the support team, it should be able to get you over to somebody if your if your question is not answered by the, the knowledge based solution or the options that it provides back to you. Another thing that you could also try is for most of you, your organization will have, access to our customer success team. And, and when I say most of you, that is because most of you are going to be assigned to customersuccess@blackbaud.com. If you send an email to that saying, you know, I've got some questions. I'm not entirely sure where to get the answer to or how to get some assistance on what I'm trying to do. A member of that team will either connect you if you do have an assigned customer success manager, like an individual on the team, or if you don't, they will assist with getting you the answer or getting you to the team that can help you answer the question. So that would be my recommendation as far as reaching out to somebody to get some assistance. Certainly, would recommend the, you know, the chat, for, like, how to or troubleshooting issues. But if you are just trying to get some assistance or trying to figure out, like, what the, best path to take on something, reach out to customersuccess@blackbaud.com, and they will get you connected either with somebody who can answer the question or get the answer for you, and then see how they can assist you with that as well. Yes. And, Jeanette, you are exactly right there. If you do have people that, are coded a specific way for grants, then I would say, you know, use that user defined field that you use to code them. Or again, if it's a fund or a, or a user defined field on a gift as opposed to the account itself, then I would recommend using that to potentially exclude those folks in a compound query. Yeah. You're exactly right there. Lisa, as far as your question regarding, like, the QuickBooks, you know, reconciling with QuickBooks and the BBMS, terminal, certainly recommend you reaching out to the support team on that, because that will be something that they can help kind of troubleshoot if there are any issues or help get you the steps on the the right you know, the best way to, potentially export that information from the BBMS terminal. That's something that I sadly don't have a whole lot of, insight on as far as, like, the BBMS side of things. In larger organizations, are or I'm sorry. Wait a minute. Let's see. In larger organizations, is there a way to connect separate bank accounts to respective funds? No. So not directly inside of eTapestry. Except, one thing that you can do in terms of how you can, potentially set up funds to help you reconcile, like, what bank account they should be going to. When you are looking at your funds, and this can be done either when you're setting up the fund or after you've set up the fund, one thing you can do is you can fill in the cash account, receivables account, and so forth. When it comes to actually setting up separate bank accounts for things to, to send over to, like, the specific bank that it should be going to, that would be handled by setting up multiple Blackbaud Merchant Services accounts, but it would not be necessarily tied to the fund. It would be tied to the online gift or how or which processor you're using to process the transaction. So it wouldn't be tied directly to fund, but you can distinguish what the accounts are supposed to be to help you with the bookkeeping side of things. And then whatever account that would be associated to whatever bank account on the bookkeeping side would then be displayed at least at that point. Yeah. And, Gabrielle, you're right there as far as, like, the, the way that that is, yeah. It's it it would be basically depending on how you are processing gifts. Now one of the other things to take into consideration is how, the, like, if you set up a a, an online form, for example, that online form can only be tied to a singular processor. So, like, if you want to have certain transactions going to different bank accounts, when you are entering a gift, so, like, when you are adding a gift here and you come down here to, you're entering a credit card, you can choose which processor you want to process that gift through if you have the bank account and from or if you have the transaction information and the credit card information in front of you. If you are going into a, DIY form and setting up a online form that you want to process through a specific processor, that can all be done in the settings, but only one processor per page is allowed on the DIY forms. So that is something to be mindful of. So So other software so, like, directly, yeah. And that's something else, Gabriel, that you asked about as far as, connecting to financial software directly. Most of it is handled via a, like an export, like one of our standard exports, which are found under management. And we have various exports that can, you know, be imported into other, into other programs. However, one of the things I mean, we do offer, Financial Edge through Blackbaud. I think that there is an integration there that can, be looked into. That would certainly be something that I would connect with your customer success manager or customer success at Blackbaud dot com to, you know, if you wanted to kind of look into that possibility. I do know that one of the biggest headaches that people have, and it's something I'm particularly frustrated about because when I spent time in support, sometimes we would get questions about how to do, like, the QuickBooks export or something like that. QuickBooks, for whatever reason, when they went to their online service, they didn't do imports the same way as they always did with their desktop version, which kinda left us out kind of in the cold because they didn't want to give us the the the proper whatever it was that we needed to be programmed into creating a proper export that would then allow for it to be imported into, QuickBooks online. So our QuickBooks desktop export doesn't really work for QuickBooks online, because for whatever reason, they changed how they did all of that type of importing. And it's a bit frustrating because I know a lot of our eTapestry users wanted to stick with QuickBooks because it was, you know, it's the standard. Right? And so that is definitely something that, is a little bit unfortunate about about that. Now one question that I wanted to come back around to, and that's Judith's question. She asked about, how to use aggregates in reports in general. Now this is something that is not a standard report feature, but it is something that a custom report can do. So if you are building reports that you want to find, you know, you you have a specific query and you say, I wanna be able to show, based on this query, I want to be able to show all of this information in a spreadsheet, and export it and use it, you know, for whatever. There is a way and there is something in the settings of those various columns that you can include that include aggregates. Now as a kind of a sneak peek, this is something I'm going to talk a lot more about probably. And when I say probably, I mean, probably talk a lot more about this summer. I have already, scheduled out for the rest of the year what my topics are going to be for these webinars. And one of them is going to be about, the queries that everyone should have inside their database and, some reports that everyone should be able to know how to build. And one of the things that I wanted to talk about specifically was how to use aggregates. So here's a little bit of a sneak peek for you about how aggregates work. So let's say I have a query of, all of my, all of my accounts. We'll just say all constituents. Okay? And I want to be able to display what, you know, I have all the journal entries from all of my constituents, and what I want to display is, what they have given year over year as opposed to just showing their grand total. Now when you're doing a custom report, the typical, thing that you would do when you come in here to create a new report, you would first you would name the report. Usually, in this type of scenario, you will want to group by account and collapse groups so that everything for each account is just on one line going across. I will, like I said, I I will plan on having a session, this summer that will go much more into that, distinction of what these group results do when you select certain combinations. But, in this case, we're going to collapse groups and we'll say, okay. We want the account name. We want the address. We want city, state and postal code. And now I wanna see three years worth of information. Now if I have all of my journal entries from the last three years or all of my gifts from the last three years, what I can do is I can say received. And when I click the little, three dots here, it opens this up here and you will see that there is an aggregate field here. And by default, it is set to none, which means that if we were just to leave this alone, it would just display from my query when I eventually run this report that I will, see the grand total for the receipt for each, account. But here, if I open this up, you will see that I have these various different options. So for this one, I wanna make this year to date, and I can rename this 2025 received. Now for the other years, I just add additional received column. So I add a second received column. I come down here to aggregate, and I do one year ago, and I rename the field twenty twenty four received. Now I can continue to add these different received and having these different aggregates in here. But one thing to keep in mind that beyond the year to date, there are only five years backwards that you can look. So you can't go on forever with those, but I can show you the twenty twenty three received here in this case. And then what I can do here, also, if I want just to be just to have a little bit more fun, I can come in here to received. And for this aggregate, I will say, give me the average. And what it will do when this exports, each one of these columns will look at it and say, okay. Well, this transaction was from 2024 you know, these transactions for Geoff Arbuckle were 2025. So they go under the 2025, received column. And here's the grand total because we are collapsing it all to be on one line and show $1 total. Here are the 2024 and here are the 2023. And based on everything that Geoff has in this query, here's the average that he received. So these aggregates are one way that you can get that additional information. Now, as a little bit of a tease to save that for, later this summer, we also have something called summary fields that I'm a big fan of as well. And that is definitely something else that could look at individual, columns for each past year or year to date or whatever the case is. And the summary fields have all sorts of different things that it can look into and pull information from the account on. So, didn't really go into perfect detail on that, but I did want to, absolutely give a little bit of a tease as to some topics that we are going to talk about, later this, summer. So I think the reports one is going to be August. The queries in, July, reports in August. Don't ask me to recall what I just sent over yesterday as far as what September, October, and November are. I can't remember because, well, that's the first thing that goes with age. Right? The memory. But I will say that each month for the rest of this year, we do have more, we do have more webinars, coming. So, be on the lookout. One of which, for those of you who attended, last week's, product update briefing, the end of the year, I will talk about those new, compound queries that should be released, I think, in I think we're thinking q three, but it should be out by the end of the year, and we will be talking about those in December. So okay. Bella, one more question here. Is there a way to run two campaigns at my, organize that, page on DIY page type? So no. The campaigns and the approaches are just one per page on the DIY forms as well. The the fund, you can have multiple funds and then you you can have your donors select between which fund they wanna give to. But, the campaign and the approach are just one per page on that. I'm try I am trying to now I'm now I'm stuck here, Jill. I see your question about what's coming up. I am trying I know I think November, I'm going to talk about, some, call to action, kind of like end of year sending out, like, thank you letters versus or not thank you letters. Sending out, appeal letters versus potentially, like, emails. There is a little bit of a difference on what you should be kind of taking into account with that. So I think that's going to be that's certainly before, the week of Thanksgiving because I am off the week of Thanksgiving. But yeah. So that that is definitely November as well. So, I I can't believe I'm blanking completely on what September, October, are. But, anyway, yeah. So, last call on any questions here because we are coming up to, the last fifteen minutes here. I wanna make sure that I, talk to folks or make sure I get everybody's, questions answered. Oh, and, one thing that I wanted to bring up also, Jeanette, who is in our, chat and attending here this week, she was not able to attend last week's session and was having a little bit of trouble until, I think, last night getting into the recording. I don't know if anybody else was having issues getting into the recording of last week's session. It should be working because Jeanette let me know that it was, that it was fixed. So that is definitely something I do apologize for if anybody else was having issues getting into that recording of last week's session. It might have been something on Goldcast side. It might have been, something localized in, you know, Jeanette's network itself. I, but I definitely wanted to say, that if anybody was having problems getting into that recording, you should not be having problems now. So hopefully, that is fixed. Alright. I'm not seeing any other questions. So let me go back to my slides here and make my usual appeal here at the end of these, sessions. Always yes. Absolutely. Judith, if you can link to that, eTapestry user group on Facebook, that is that would be great. The, and, also, just to kinda follow-up on what Judith said there about that user group, she's being very kind saying that that they're all big fans of mine over there. Know that I am not in that group. So if you don't like me, please feel free to, to let me know. I'm sure my legion of fans will, will, support me and back me up there. No. I'm just kidding. But, yeah, definitely recommend joining that group because that's a great way. Yes. And it's not Blackbaud affiliated. So it is just users getting together, talking through some of the stuff that they're, that they're running into. And, yeah, absolutely recommend you, going over there and checking out that group. Linda had a, couple of questions here before we wrap up. Last session, I realized we've been using the soft credit function backwards. Example, soft crediting Schwab instead of the donor who, initiated the transaction. Does it matter? Yes. It will. So it does matter because, ultimately, what we would always say is the rule of thumb is whoever sent you the physical check or the money or whatever the case is, they're going to be the ones who ultimately will be receded in some way. Now that doesn't really matter if it's if we're talking about an individual versus a corporation versus a donor advised fund versus a third party like United Way. They should be getting the hard credit, dollar amount in the received column for them. That way, if you ever need to send them, like, a tax receipt or something like that, it is showing that they were the ones who physically made the the donation. Now if you're giving through Schwab or if you're giving or if somebody is giving through Schwab or they're giving through United Way or any other third party feature, normally, the third party will, be the one who will typically be doing the, the tax receding. At least, historically, that was always the case. You are more than welcome to thank the individuals if you want, and you can certainly use soft credits to build a query of saying, okay. Who's everybody that, I have a soft credit for this week? I'm going to, you know, pull them out and put them into a thank you letter or something. That's fine. Unfortunately, there's not really a great way to correct the entries other than reentering them. The good news is is that deleting them is not going to be, that much of a pain because it's just gonna be clicking delete the entry, you know, to delete the entry on the entry itself and then saying, that you do approve the deletion. But otherwise yeah. Unfortunately, the the only way to really fix it is just to do a a reenter of that. Yeah. So yeah. And that's the thing also. It's like, that's one thing to keep in mind that, your reporting can be off if you end up creating a received amount for both sides. Like, in that type of situation, I give through a a donor advised fund or a third party. And, you end up adding the received amount to both my name and that third party. That is going to throw off reporting. Absolutely. So that's why we do also have that that, soft credit feature. And some of those, standard reports, that that I talked about last week do take into consideration, soft credits as well. So, yeah. So as always oh, I did not mean to skip ahead. As always, I do recommend that, anybody, that is listening, if you haven't already, go check out the Blackbaud University. That's just going into blackbaud.com, signing in with your Blackbaud, login, and going into the training and support menu, or support and training. I always forget what order those are listed in. Of course, you always have the, customer support, which you can reach inside blackbaud.com by, going into the question mark and clicking chat now. And, tied to that also, and you can also get to that inside the little question mark icon inside of eTapestry on the top right hand corner, is the knowledge base. And, the knowledge base is a great place to find, like, a lot of step by step information. Customer support, really good with, either connecting you to the right knowledge base solution or helping you with some, troubleshooting or errors that you might be seeing or something that, requires a little bit more, than just the steps that would be provided with the knowledge based solution. And then, of course, the Blackbaud community. Now that is kind of like Judith's, Facebook group. The Blackbaud community though is Blackbaud, affiliated because we run that. It's a great place to connect with other users. Ask them what they are doing with some of the stuff that you might be trying to accomplish in the system. It's a great place to, to check that out and, and to really kind of network from there as well. And, of course, I absolutely recommend Judith's, Facebook group as well. I I'm recommending it so much. Now you're gonna be wondering if I'm in there as an alias because I recommend it so much. But no. I I promise. I am not, nobody from Blackbaud that I'm aware of are are part of that group. Anybody who might be interested in these, these programs, definitely let me know in the oh, there is the there are screening questions. Yes. There yes. It is a it is a private group, so you will have to answer some questions to get into that group. That is something I do know from, working with Judith in the past and talking about this group. So, now as far as, maybe these, one of these programs might be something that you would be interested in getting involved with. We have our Blackbaud champions. I kind of think of this as community plus where, yes, you can connect with other Blackbaud users, share ideas, share feedback, not only with each other, but with us directly. There are that is something that we are active in as well. There are also, kind of a gamified little rewards program with some of the things that you can do in the champions program. Definitely something I would recommend checking out, especially if you've been using Blackbaud for or been using eTapestry for a little while, or any other Blackbaud products that you would be, interested in getting in there and and, really kinda having your voice heard and kind of having your, your power user status really kind of, celebrated there as well. We also have the reference program where you can, connect with a potential Blackbaud customer. In this case, it would be eTapestry. Sometimes, we get folks who are looking to, talk to somebody who's already using the system to to really get a idea of what they are doing with the system, what successes they've had, and so forth. If you are interested in that, you completely and totally control what the, you know, how often you are willing to take a call from one of these prospects. And we also have a spotlight your success. We can celebrate your successes and, position yourself as a thought leader. You can participate in customer stories, writing a blog for the community, or speaking in a webinar or podcast. Speaking of another thing about blogs with the community, that is one thing I did mean to bring up earlier. I also recommend that you get into the, community and subscribe to the blog in the eTapestry community because, I am planning on doing some more blog posts in the second half of the year as well. I kind of have starts and spurts of of blog posts from time to time. I wanna do something a little bit more, like, maybe monthly or something like that going forward. So, that's always a good way to get get your eyes on that, for those informational blogs that I put out. But yeah. So if you are interested in any of these programs, please feel free to let me know. You can let me know in the chat, and I will, take your name down and nominate you through the normal process. And then there will be somebody from that team who will, review that and possibly reach out to you to figure out, what the next steps are. Yes. So if you go to the blog, so one of the things you can do directly from eTapestry oh, nope. Never mind. I thought the the community was in the help, menu, but let's see here. So if you have the quick links, tab or the quick links window on your homepage, there is a link here for the community. And when you click on that, you might have to, log in to your, yeah, here. You might have to log in to your blackbaud.com, login, which should be the same as your regular Blackbaud ID and your eTapestry login. But, you can also if this doesn't deposit you right on the eTapestry, page, you can also come up here to products, and you will find the, eTapestry. ETapestry would be listed under browse my communities. Just because I'm not logged in right now to Blackbaud.com, I can't really see that. But that is something you can reach from the quick links directly from eTapestry. Alrighty. So with that, I wanna thank everybody for attending again and for all of your questions. Next month, I am doing a little bit of a rerun of the, so in June, you might notice something that sounded familiar from something that I ran back in, I think it was March. I'm doing another run of the, event registration forms, webinar because I had some technical difficulties doing that. So if you've already attended that, you don't necessarily have to attend again unless you have some more questions or if you just wanna see the content again, or if you were in the session back in March. And, because I wasn't able to kind of get through everything quite as normally as I could, please feel free to attend that. But do know that it is a sort of a rerun. But what will be coming in July and beyond, July, I said, being the queries session, August will be, the reports session. Going forward there, at least for the rest of the year, will be all content that, is relatively new in terms of, what I've covered before in these types of webinars. So, but thank you for attending. I hope you have a great rest of your day. I hope you have a great, rest of your Wednesday, and I hope you have a great weekend coming up. And, if you have any further questions about anything that you've seen or anything that you would like to discuss further, you're always welcome to reach out to customersuccess@blackbot.com. And, we will be looking forward to hearing from you again. Talk to you soon. Thanks.