Event vs spreadsheet?
Options
We are currently planning an event to kick off a building campaign. We have addresses of people (potential donors) to invite to a reception to introduce the campaign. In the past I have done all this with spreadsheets. Would it be better to enter all the info in the event tab of RE? How do others track the potential donors? Also can you create a mailing list from the event?
Tagged:
0
Comments
-
Moving question to RE product community to get RE specific answers.
Elizabeth0 -
Some short answers... I'm sure others do things in different ways...
1. Yep! You can absolutely do this sort of thing in Events in RE (and then produce spreadsheets from RE after the fact).
2. We have tracked invitation lists in Events, though you could do it with Actions. Just give ever constituent the same "Invitation" action with the same note and date and then you can create a query which grabs everyone who was invited. Putting them into an Event as "Invited" is a little more initial work (you can import people into an event if you have their IDs), but it's less work after the fact.
3. Yep, you can create a mailing list queries (or Export to Excel) from a query that grabs people in an event.
Some things with Events work better if you use "Participant" queries vs "Constituent" queries.... But you can create Constituent exports and mail merges and whatnot from Constituent queries as long as everyone in your Event is given a Constituent record.
Our general philosophy is: Working in Excel is GREAT because it works... but we prefer the source of the data to be in RE.
5 -
I would say you should definitely keep the information in RE otherwise there's no easy way to find out if someone has actually attended an event, was invited, etc. without having to refer back to an excel spreadsheet. Much easier to open someone's record and see all the info there.
As for actions vs. events, if you have the events module I'd say use it. You have the ability to have lots of information associated with the event and invitees (most of which we don't use but the option is there if we want it) and sometimes it's a lot more difficult with an action because you often need to have specific event related attributes/custom fields or use a field that's not really for event information which makes it more difficult to query/export/report. It's also a lot more difficult to wade through all the actions to find the one(s) for the event instead of just having that list in the events tab.
The other thing, and I've told this to people at many of the organizations I've worked at, you need to remember that development teams overturn a lot and you need to make sure that you have things set up so someone new at least has some idea of what's going on. When I'm new to an organization, or someone else comes in, generally if you want to find out if someone was invited/attended an event the first place you're going to look is in the events tab. You're not usually going to go to actions first to see what events are on a record.3 -
I think the best way to think about it is to try to think about what information you'll be asked for later. If you ever need to cross-reference attendance or invited with donor information, entering it in RE means that all the data is in one source.
Granted, Excel is a comfortable blanket that we often run to, but I think you'll be doing yourself a disservice not to entering it as an event. It may make things much easier come reporting time.
Of course, that's all depended on how comfortable you are with the Event Module.1 -
I also agree that it should be entered into Raiser's Edge, but mostly from an analytical view. Two years ago we moved all of our event registrations and invitations to Raiser's Edge. It has taken a while to get everyone comfortable with it but it is such a great way to track and analyze. For example, I can run a report showing what each table (i.e. sponsor) brought in during our gala. We can also look and see who attended an informal event and then made a gift after the fact. If the information is in two different place, it takes a lot of work to run these types of reports. We are currently re-purposing our Constituent Codes and dating them so we can see who started as an event attendee who then became a donor and/or a volunteer. How people become engaged with us and how that leads them to being involved either as a volunteer or donor is of big interest to us right now. None of this is possible with tracking in a spreadsheet.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™
- 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
- 3 Blackbaud Staff Discussions
- 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