

Organization Background
Fairfield University is a Jesuit university in Fairfield, Connecticut, with an enrollment of nearly 7,000 undergraduate and graduate students. The university’s Advancement Services team uses Raiser’s Edge NXT as its fundraising database, pulling in data from applications including Slate, the student information system, GiveCampus for fundraising, and EverTrue for donor engagement. We spoke with Kisha Baker, Associate Director of Advancement Services, to hear how the university used Omatic Cloud as part of their strategy to reach pristine data integrity for better reporting, strategy, and fundraising results.
Challenges
- Hand-keyed forms: The university’s advancement team has come a long way to reach data integrity goals, but it wasn’t long ago that the university was relying on manually keying in information from hand-written forms, and errors abounded. Even after important sources of information like parent demographic forms went digital, the team still merged them into Word and retyped them. For many years, the university relied on student workers to enter this data over the summer.
- Multi-step, time-consuming imports: The import tool built into Raiser’s Edge NXT handled one slice of a record at a time, a process that took time, patience, and diligence to complete.
- Errors fixed record by record: Solicitor assignments, prospect ratings, constituency codes, and prospect statuses were all set by hand, so they often went missing. The team built more than 100 audit queries to catch these gaps. Still, each missing data point still had to be fixed, record by record.
You’d have to run imports for that group of people for just their education or just their seasonal addresses. It’s very piecemeal.
– Kisha Baker
Solution
Fairfield University uses Omatic Cloud to bring each source into Raiser’s Edge NXT in one pass, with the same rules every time.
- Automation of incoming students and parents: New student data comes in from Slate through three profiles. The first creates the student with demographics, major and class year. The second builds Parent 1 with business details, other children, seasonal addresses and colleges attended. The third does the same for Parent 2. Parent forms later in the year run through the same three-step process.
- Efficient integration of third-party application data into Raiser’s Edge NXT efficiently: Omatic now brings data from all of Fairfield’s key applications into its development CRM. Each week, a file from Paciolan captures engagement with athletics and university events. GiveCampus captures engagement with alumni events and volunteer outreach. Weekly imports from EverTrue captures DXO fundraiser outreach and portfolio management.
- Cleanup that runs by itself: Kisha has been making full use of Bulk Data Cleanup, formerly the DBA Assistant. By using Omatic to run queries on data within Raiser’s Edge NXT, Kisha has been able to fix records automatically at scale, including the following:
- New records with no prospect status are set to Identification automatically, not by hand later on
- Single records with a blank classification get Primary Household Contact. That keeps portfolios free of duplicates who are spouses or other relatives
- Anyone who gives to or attends an event hosted by specific university Centers gets the respective constituency code
Creating these audits is easy, and it opened up my mind to what else we could do
– Kisha Baker
Results
- Hours saved in staff time: The organization gets more information into Raiser’s Edge NXT, far more quickly. In the past, the organization required five people to manually key in data from parent forms over the course of 3-4 months manually. Today, that same task only takes 1 person 2-3 weeks to complete.
- For the first time, 99.9% of alumni are contactable: Fairfield has at least one valid point of contact for nearly every graduate. Without contact information, a university can’t build a relationship with its alumni, and the chance of long-term support drops sharply.
We have a 99.9% contactable alumni rating meaning we have at least one point of contact for all alumni. And that is due in part to being able to take those demographic files and have up-to-date emails, phone numbers, and addresses automatically
– Kisha Baker
- Audit queries designed to catch errors come back empty: Most of Fairfield’s 100-plus audit queries now return zero records. Baker credits that fact to the quality of data imports. Information coming into Raiser’s Edge NXT is clean from the start, so automated fixes only spot a handful of errors that occur after large events or giving campaigns.
- Reports people can trust: Accurate parent records help prospect research rate parents and move them through the pipeline. Accurate contact data lets fundraisers reach the people they need.
I don’t know if I could put a number on how much time we save. It’s hours. We use Omatic so much, and I’m in it all the time, and I’m always thinking about what else we could do.
– Kisha Baker








