Organization Background
Oregon Health & Science University is focused on improving health. The organization is dedicated solely to advancing health sciences, concentrating its resources on research to prevent and cure disease, on education that prepares health professionals to succeed in an evolving healthcare environment, and on patient care that incorporates the latest knowledge and discoveries. OHSU created the world’s first successful artificial heart valve, developed the first targeted cancer therapy, and launched the field of personalized medicine.
Each year thousands of donors contribute millions of dollars in financial support to OHSU and the Doernbecher Children’s Hospital through the OHSU Foundation and the Doernbecher Children’s Hospital Foundation.
Challenges
Managing more than half a million constituent records required significant time and effort, creating challenges around data accuracy, duplicate records, and effective donor communications.
Time-Consuming Data Management and Imports
The business intelligence team at OHSU Foundation manages over half a million constituent records. Keeping the data accurate and up-to-date was a time-consuming task, requiring the team to rely on a slow import process and spend additional time fixing duplicate records.
The more records we accumulate, the more crucial it is to have efficient methods to process the data.
Sandra Maxwell
Inefficient Luminate Online Integrations
The organization has multiple email addresses for many constituents, and imports into Luminate Online were creating separate profiles for each email address. Updating Luminate with relevant information from Raiser’s Edge required more than 40 hours per integration cycle.
Limited Visibility for Targeted Fundraising Campaigns
Important segmenting information about constituent giving history and preferences was not automatically flowing into Luminate profiles. Without insights into what constituents cared about most and which funding opportunities they supported, campaign messaging remained generic rather than targeted.
Solution
To improve efficiency and strengthen fundraising efforts, OHSU Foundation implemented Omatic solutions to streamline data imports, reduce duplication, and better connect Raiser’s Edge with Luminate Online.
Streamlined Data Imports with ImportOmatic
The OHSU Foundation began using ImportOmatic to import more data in a single file without duplication issues. ImportOmatic’s built-in intelligence automatically cleaned data and provided greater control through smart profiles.
Automated Data Synchronization Between Systems
In spring 2018, the team implemented the Luminate Online Integration to connect Raiser’s Edge with Luminate Online. The integration enabled data from Raiser’s Edge to be synchronized and directly utilized in Luminate campaigns.
Improved Data Quality and Reduced Errors
By automating data transfers and minimizing duplication issues, the integration reduced mistakes and ensured more accurate information was available across systems.
Results
By implementing ImportOmatic and the Luminate Online Integration, OHSU Foundation significantly reduced administrative effort, improved data accuracy, and enabled more effective donor communications.
Reduced Time Spent on Data Processing
One of the most significant benefits was time savings. For the import process alone, the team reduced its time investment by half, freeing staff to focus on more strategic activities and data analysis.
We’re finding that the transfer of information is much simpler for the majority of our records. It will take minutes rather than hours and days to process.
Tammi BurkhardtBusiness Intelligence Analyst OHSU Foundatio
More Accurate and Timely Constituent Data
The team can now update and sync data more frequently, resulting in information that is both accurate and timely. This improved confidence in the quality of the data being used across fundraising efforts.
Stronger Targeted Fundraising Campaigns
With better access to constituent preferences and giving history, the fundraising team can craft more targeted messages and segment audiences more effectively, improving campaign relevance and engagement.
More accurate data means better communications. By using the fields that exist in Luminate and updating them from Raiser’s Edge, we can target more effectively.
Tammi Burkhardt
More Customer Stories
Joe Andruzzi Foundation is able to Seamlessly Integrate with Salesforce NPSP
Read the Full Story
University of Portland Uses Omatic Cloud to Improve Data Management, Increases Team Bandwidth for Data Maintenance by 40%
Read the Full Story
Greater Cleveland Habitat for Humanity Expands Donor Relations After Improving Data with Omatic Cloud
Read the Full Story