Recently in Case Study Category

university of washington for blog.jpg

Like all other colleges, the University of Washington is keen on maintaining accurate records on students and alumni. However, both students and alumni's information is always changing as they move, get married, relocate, change names, etc. The need for the university to maintain accurate records rose as the need for fundraising increased due to state aid decreasing. Not having accurate records would result in waste in postage and production costs, undeliverable mail, and not to mention the lost fundraising opportunity.

The University of Washington turned to Melissa Data's solutions to clean-up and update their database. Through the Data Quality Suite, they were able to address the issue of inaccurate data through address, phone, and email verification. Through Melissa Data's geocoding service, they were able to find and prevent duplicate records as well as analyze location-specific relationships within their data.

By updating and cleaning up their database, the University of Washington was able to capitalize on the contributions of their supporters. So much so that they recently concluded a fundraiser that brought in more than $2.7 billion! A key factor in the success of this campaign were the data quality programs they used from Melissa Data. This goes to show that accurate data truly is invaluable. Learn more about solutions from Melissa Data. 

By Natalia Crawford

Case Study: AirNet

| No Comments | No TrackBacks
case study airnet blog image.jpg

For many years, AirNet depended on applications from external vendors for data enhancement, hygiene, and matching. This proved to be a challenge when implementing its smartCommunicator product--an award-winning communication portal that allows individuals, businesses, and agencies to share information from diverse sources using a single, unified media platform. It is a portal designed to effectively deliver messages to the company's targeted audience.

This is where the main challenge comes in: integrating disparate data sources into a data-centric hub for the purposes of consumer and constituent engagement. AirNet needed a solution that would help them gain a single, accurate, and organized view of their customers by consolidating data across different data sources. They also needed a strong technical support team that would aid in the implementation of a data management solution, and provide quick responses to any issue that would arise during the transition process.

AirNet decided to implement the Data Quality Components for SQL Server -a complete enterprise platform that works within the SQL Server's Integration Services (SSIS) data flow to deliver a wide range of data integration, transformation, and cleansing and enrichment functionality.

"Name, Address, GeoCoder, Phone, and Email verification components, or transforms, are all put into action as each individual data upload is scrubbed and merged in to a single, uniform data set. This creates a single anchor record per individual from which our customers operate multi-million-record mass communications strategies" said Jeff Averbeck, president and CEO of AirNet.

Integrating the components into the organization's workflow was seamless. Averbeck added, "The solution's existence within the SQL Server Integration Services suite has enabled the company to build robust, stable ETL tools -in many cases, customizing data transforms to the specific needs of our clients."

Utilizing Data Quality Components for SQL Server proved to be a successful venture for AirNet. Visit our website to learn more about Data Quality for SQL Server!

By Natalia Crawford

Case Study: Clean Data Helps Non-Profit Flourish

| No Comments | No TrackBacks
clean data helps non profit flourish blog image.jpg

Company: Altapass Foundation, Inc.

Altapass Foundation, a nonprofit organization dedicated to the preservation of the land, history, and culture of the Southern Blue Ridge Mountains, is located in western North Carolina. As a foundation, they host many public activities and therefore have a large database that dates back more than 10 years.

The Challenge:

This is where the challenge comes in. Having a database that dates back more than 10 years is bound to have outdated data.  Another challenge that presented itself is the fact that many of their members do not have email, requiring the foundation to send traditional mail to them.

"Every mailing resulted in a significant number of returned mail items," said Michele Williams, executive director of Altapass.

In order to experience success with its direct mail, Altapass needed to update their database.  Williams, aware of that, began to search for an affordable solution that not only fit their budget but also work seamlessly with Excel.  However, every time they searched they would come up short.

The Solution:

After doing research, Williams came across Melissa Data's Listware for Excel ad-in, a data enrichment tool that integrates directly into Excel.

Affordability was one of the many factors that drew Williams to Listware. "With Listware for Excel, the cost is based on the amount of data, and the rates are very affordable.  For about $100, I was able to process over 10,000 names, addresses and phone numbers," she said.

One of the other things Williams liked about Listware was its ease of use.  "I gave [Listware] a try, testing it on known cases. It is very easy to use and it worked perfectly. I was able to process all of our database entries. I now have the data I need to ensure that our database is accurate."

The Results:

Using Listware caused a dramatic drop in returned mail for Altapass Foundation. "After running our database through Listware, I mailed postcards to over 400 people with whom we had not had contact for eight years. Only one postcard was returned!"

If you find yourself in a similar situation as Altapass Foundation and you would like to learn more about Listware and how it can help you sign-up for a FREE trial today by clicking HERE!