1 / 24

Customized Development Module: A Gift Officer's Love for EX!

Discover how Grove City College's gift officers benefit from the customizable features and reports of the Jenzabar Development Module. From prospect assignments to year-over-year metrics reports, this module streamlines their workflow and enhances their fundraising progress. Additionally, the Notepad and Launch Links functionalities provide a comprehensive snapshot of constituent activity, while the Zip Radius tool helps plan trips and target prospects within a specific area.

shawnnas
Download Presentation

Customized Development Module: A Gift Officer's Love for EX!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Things Development Officers Love About EX! Presented by Elicia Winner & Esther Hay, Grove City College

  2. Gift Officers and the Jenzabar Development Module • Our gift officers have come to appreciate how easily we can customize the DE module and our reports to fit their needs – here are a few items they have come to rely on • Prospects tied to solicitors through relationships • Year over Year Standard Metrics Report • Notepad as a snapshot for activity • Zip Radius reports to plan trips

  3. Prospect Assignments All development officers are tied to each prospect in their portfolio via relationships Prospects are split into categories by relationship code. DMG1 – gift in next 12 months DMG2 – gift in 12-24 months DQUA – prospect in qualification DSTW – prospect in stewardship

  4. Prospect Ties • Useful because officers can easily flip through their portfolio and see pertinent info through customized front screen

  5. Year over Year “Metrics” Report • Standard report used to measure fundraising progress year over year • Distributed weekly throughout the year to key staff, as well as at the end of each month, and produced on an as-needed basis • Measures key metrics: Restricted Giving, Unrestricted Giving, Estate Giving, Ketler Society Members, New Donors, Alumni Participation, and LYBUNTs

  6. “Metrics” Report – Top Half

  7. “Metrics” Report – Bottom Half

  8. Year over Year “Metrics” Report • Comprised of seven nested reports, all passing a common retrieval argument (month/day)

  9. Year over Year “Metrics” Report • Passes a “string” retrieval argument to all nested reports comprised of month/day

  10. Year over Year “Metrics” Report • Each nested report retrieves all gifts since report starts tracking, and then using computed columns to split them into the appropriate year

  11. Year over Year “Metrics” Report • Each nested report retrieves all gifts since report starts tracking, and then using computed columns to split them into the appropriate year

  12. Year over Year “Metrics” Report • Front end of each nested report displays computed columns into correct format/place, and computes the % change

  13. Notepad & Launch Links • A snapshot of activity with the constituent • Gift officers love seeing all contact in one place • Record Mailings • Track Event Attendance • Archive correspondence, biographical information and photos • Track gift officer activity and next steps • Track phone-a-thon caller notes • Record any involvement with the College

  14. Our favorite notepad tool – “Launch Link”

  15. Launch mailing PDFs and more…. • Launch link will bring up pdf of mailing in question, allowing gift officer to open while on the phone with a constituent, and see the same thing the constituent is seeing

  16. Create custom reports in Infomaker based on a specific Notepad Action

  17. Zip Radius – Grove City’s “EX Zips” IT created program – stores zip codes and then matches them to records that fit your criteria in Infomaker

  18. Purchased database of zip codes • Zipcodedownload.com

  19. Purchased distance radius tool • Purchased distance radius tool from same vendor for SQL Server scripts to calculate distance – saved programming time – one time cost

  20. Retrieve zip codes within radius • IT created a report in Infomaker that prompts for a starting zipcode and a radius in miles • The report returns all zip codes in the database within that radius using purchased scripts • You can then save zip codes to Excel, remove the +4 data, and then paste into the EX Zips program

  21. Add to Infomaker criteria • Pasting zip codes into the EX Zips window loads them into a custom table, you can then tie to the table in your criteria and any report will only return records in the radius • You load the program per user – so putting your ID numbers tells it which set of zip codes to look at

  22. Using syntax mode • If you run the same report all the time and need a radius for it, we can use syntax mode with retrievals and get the exact data instead of just zip codes (saves a step!)

  23. How we use it (some examples) • All Alumni Event invitations – we pull everyone with ANY address within a radius of the event, and then mail to their current address (so snowbirds get FL invites in the summer – in case they are visiting) • Gift Officers run a radius report before any trip and map those within area (includes key prospect/wealth ratings as well)

  24. Any Questions? • Esther Hay – Grove City College • eghay@gcc.edu • 724-458-2159 • Elicia Winner – Grove City College • ejwinner@gcc.edu • 724-458-2156

More Related