Donor Analysis by mail vs. online vs. phone
Do you do analysis to see how many donations you receive by mail vs. online vs. phone? If yes, where do you track mail, phone, online with the gift? We use mostly gift sub-type to differentiate some online third party platforms but I was wondering if someone had a better solution for this analysis.
Thanks in advance for your time and suggestion.
Brinda
Comments
-
Hi Brinda, we also use gift subtype to identify online/postal/phone gifts although we haven't done that much in the way of analysis with the data yet - is there a particular problem you've come across with recording it this way that you're looking to address, or would you just like to repurpose the subtype field?0
-
We do track our online gifts, though not our phone-generated ones. (We don't do phone-a-thons, so really don't have very many of those.) If you use OLX, then the gifts automatically contain a NetCommunity gift attribute. I'm guessing the same is true if you use Luminate or NetCommunity as well. So you can pull a query based off gift attribute to tally how many online gifts you have received in a given year.
Before we used OLX, we had a third-party, non-integrated online platform, and we just tracked it in the gift reference. I didn't set that system up; looking back, it would probably have made more sense to use a Gift Code, Gift Attribute, or Sub-type to track such gifts. If an appeal contains an online multichannel fundraising component, one could even conceivably create a unique appeal package to track the online gifts portion of the appeal response.
Edited to add: if you track via a gift attribute, you can then filter your Gift Detail and Summary Report to only include/exclude gifts with that specific gift attribute.1 -
Brinda Goswami:
Hello RE users,
Do you do analysis to see how many donations you receive by mail vs. online vs. phone? If yes, where do you track mail, phone, online with the gift? We use mostly gift sub-type to differentiate some online third party platforms but I was wondering if someone had a better solution for this analysis.
Thanks in advance for your time and suggestion.
BrindaBrinda,
How are you using appeals and appeal categories? This is how I track these things. I do not recommend gift subtype as that has financial implications with funds and GL distribution and I highly recommend reserving that field for when you need that feature.
0 -
Melissa Graves:
Brinda,
How are you using appeals and appeal categories? This is how I track these things. I do not recommend gift subtype as that has financial implications with funds and GL distribution and I highly recommend reserving that field for when you need that feature.Melissa, how would your org record a gift that was pledged through a telephone appeal but later fulfilled online (if you do ever get that scenario)? We would put the appeal as telephone and then add a gift subtype of online, but then we're not integrated with any financial software so it wouldn't cause us any issues with the GL.
0 -
I like the flexibility of gift sub-type field. We have some sub-types that are linked to specific GL account (we are integrated with FE) and others that are for informational purposes like direct deposit as it's not a pay-method yet, one of our branches has specific goals related to money to be raised by special events, etc and at request of CFO the special event and etc. are a gift subtype. It's nice because you can link to GL but not required.
Just what works for us.0 -
JoAnn Strommen:
I like the flexibility of gift sub-type field. We have some sub-types that are linked to specific GL account (we are integrated with FE) and others that are for informational purposes like direct deposit as it's not a pay-method yet, one of our branches has specific goals related to money to be raised by special events, etc and at request of CFO the special event and etc. are a gift subtype. It's nice because you can link to GL but not required.
Just what works for us.The only issue with using gift subtype for these two distinct purposes is what do you do when you need to record both on one gift? You can onlyhave one gift subetype per gift.
0 -
Alan French:
Melissa Graves:
Brinda,
How are you using appeals and appeal categories? This is how I track these things. I do not recommend gift subtype as that has financial implications with funds and GL distribution and I highly recommend reserving that field for when you need that feature.Melissa, how would your org record a gift that was pledged through a telephone appeal but later fulfilled online (if you do ever get that scenario)? We would put the appeal as telephone and then add a gift subtype of online, but then we're not integrated with any financial software so it wouldn't cause us any issues with the GL.I guess my question is what value does knowing that give you. What you want to record is what method prompted the donor to give. Does knowing how they responded give you actionable data. I do not think so but you may think differently. I want to only know what strategy did we employ to get the donor to make their gift - what worked.
1 -
Whether the GL distribution is affected depends on how the Finance department has things set up; I would assume that since they have already been tracking these gifts via sub-type that there has been no complication on that end. Our Finance dept, for example, has never used gift-subtype in its GL distribution categories.
Appeals can work, if you use them that way. We don't; we have 5 different direct mail appeals that go out, with their own Appeal records, plus appeal records for Events, etc. For us, to track by Appeal would have to include a Package for online gifts instead of its own Appeal. A Phon-a-thon might warrant having its own appeal, but anymore, integrated channel fundraising means that every appeal will have an online component.
As far as reporting, the canned Reports are really made for filtering by Gift Attribute, not by sub-type or Gift Code. You can find an article on the KB about using Reports to filter on gift sub-type, though, using Pivot Reports, here. Or, if you are into Crystal Reports, you can create a custom report to break your Fund or Appeal revenue down into sub-groups based on Gift Code, Sub-type, Attribute, or Package.
0 -
Alan French:
Hi Brinda, we also use gift subtype to identify online/postal/phone gifts although we haven't done that much in the way of analysis with the data yet - is there a particular problem you've come across with recording it this way that you're looking to address, or would you just like to repurpose the subtype field?Hi Alan,
Great to hear you are already using gift sub-type for this. I was trying to get a sense how others track information about how a gift was received.
0 -
Faith Murray:
Whether the GL distribution is affected depends on how the Finance department has things set up; I would assume that since they have already been tracking these gifts via sub-type that there has been no complication on that end. Our Finance dept, for example, has never used gift-subtype in its GL distribution categories.
Appeals can work, if you use them that way. We don't; we have 5 different direct mail appeals that go out, with their own Appeal records, plus appeal records for Events, etc. For us, to track by Appeal would have to include a Package for online gifts instead of its own Appeal. A Phon-a-thon might warrant having its own appeal, but anymore, integrated channel fundraising means that every appeal will have an online component.
As far as reporting, the canned Reports are really made for filtering by Gift Attribute, not by sub-type or Gift Code. You can find an article on the KB about using Reports to filter on gift sub-type, though, using Pivot Reports, here. Or, if you are into Crystal Reports, you can create a custom report to break your Fund or Appeal revenue down into sub-groups based on Gift Code, Sub-type, Attribute, or Package.Hi Faith,
I like your idea about using gift attribute for this. I think gift attribute will be the perfect place to record this information. I haven't used the Gift Detail/Summary report to filter by gift attribute. We also use Appeals for various DMs and then package is whether it is Spring or Fall etc. And we use gift sub-type to capture currency which works the best for us.
We currently use Gift Code to capture GL code for our gifts and it works the best for us. However, our RE is not integrated to any accounting program.
Thanks everyone for your input on this.
Brinda
1 -
Melissa Graves:
I guess my question is what value does knowing that give you. What you want to record is what method prompted the donor to give. Does knowing how they responded give you actionable data. I do not think so but you may think differently. I want to only know what strategy did we employ to get the donor to make their gift - what worked.We don't need to know for fundraising strategy purposes necessarily, but there have been a few times where I was asked to provide data on the number of gifts that have come in via various methods, for example when we changed our online donation vendor they wanted an idea of what volume of gifts were being processed that way. I guess we probably could have got a ballpark figure without using that data, but having that gift subtype did make it quick to work out.
2 -
Brinda Goswami:
Hello RE users,
Do you do analysis to see how many donations you receive by mail vs. online vs. phone? If yes, where do you track mail, phone, online with the gift? We use mostly gift sub-type to differentiate some online third party platforms but I was wondering if someone had a better solution for this analysis.
Thanks in advance for your time and suggestion.
BrindaWe do it by gift subtype and it is very interesting to track by month, quarter and year. We get a higher % of online gifts from Oct-Dec. We review by donor group: high, medium and low, and then all. We track total income and total # donors. Online continues to increase vs. mail, but mail is still strong.
Dale Anania
The Marine Mammal Center
0 -
Brinda Goswami:
Hello RE users,
Do you do analysis to see how many donations you receive by mail vs. online vs. phone? If yes, where do you track mail, phone, online with the gift? We use mostly gift sub-type to differentiate some online third party platforms but I was wondering if someone had a better solution for this analysis.
Thanks in advance for your time and suggestion.
BrindaWe track the online, mail and, phone gifts each an assigned GL. Then use appeal codes to identify specific asks. This makes query and reporting super easy.
0 -
Just curious, when you do reporting and analysis of how they gave does it affect any future actions - do you then tailor your messages and communication channels based on how they gave?0
-
Gina Gerhard:
Just curious, when you do reporting and analysis of how they gave does it affect any future actions - do you then tailor your messages and communication channels based on how they gave?Yes, it has affected our planning. We used the information to analyze the impact of our switch to OLX, and we've also used that information to plan an integrated digital component to our appeal, as well as the branding structure of our revised monthly donor program.
1
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 1 YourCause® from Blackbaud®
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board