FundSvcs Community

 View Only
  • 1.  Address appends

    Posted 10-02-2020 02:13 PM

    Good afternoon and happy Friday,

     

    I have a question regarding address appends, especially those that specialize in constituent records that are lost or who have not had an update to their address in years.  I am curious as to how your institutions validates that information; in the spring we did an append and received over 10,000 new addresses but over time have found that a lot of the information was not valid; some were deceased for years, some never lived at the address provided and some were just the wrong person. 

     

    If you have done this type of append I would love to pick your brain on your process!

     

    Thank you,

    Amanda

     

     

    Amanda L. Haney

    Director of Gift & Data Management

    Gift & Data Management

     

     

    University Advancement I New England Center I 15 Strafford Ave I Durham, NH 03824

    Office: 603-862-2041 I amanda.haney@unh.edu

     

    CONFIDENTIALITY NOTICE:  If you have received this email in error, please immediately notify the sender by e-mail at the address shown.  This e-mail transmission may contain confidential information.  This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly.  Please delete it from your files if you are not the intended recipient.  Thank you for your compliance.

     



  • 2.  RE: Address appends

    Posted 10-02-2020 03:59 PM

    We have done appends through DatabaseUSA for years and have gotten great data for such a great price. A lot of our data gets confirmed through our annual giving phoneathon. We get confirmations when information needs to be inactivated or updated. I find that for most of the phone numbers and addresses it is pretty spot on. I don't see many inactivation's happening. The databaseUSA data has a comment attached to it from where it came from so that when I come across it I see how accurate the append was.

     

    Nancy M. Ramirez

    Prospect Researcher and Biographical Data Analyst

    University of La Verne

    University Advancement

    (909)448-4688

    Nramirez2@laverne.edu

     

    ULV_Signature-01

     

    The University of La Verne is following best practices in response to the novel coronavirus. Classes have been moved online and employees are working remotely. We are committed to providing a high level of service during this time, and university operations are continuing through email, telephone, and online. Please check our coronavirus website regularly for the most up-to-date information: laverne.edu/coronavirus.

     

     

     

     

     

     






  • 3.  RE: Address appends

    Posted 10-29-2020 07:02 AM

    Morning Amanda,

     

    My institution has struggled over the years with data quality from vendor appends (addresses included).

     

    So we made a few operational changes this past year –

    1)      We went with a "Best of Breed" approach to appends.
    So for address appends – we sent test files to all of the vendors in play and checked their accuracy (especially with some of the "Gotcha" cases that we knew about.

    2)      After selecting that vendor who had the highest accuracy and best features  –
    We still reviewed the data and the confidence.   If we weren't confident, that data was kicked over for further review in AlumniFinder or FastPeopleSearch

     

    For us – testing our vendors with known data before the append and being transparent with them on the testing results was critical for us to establish what our expectations are.

     

    (I will note in current COVID-19 reality – we halted our appends for now.
    For addresses, we are going to start doing a non-mailing quarterly NCOA screening with our full address pool, which might help us find some of the people who don't have an active home address anymore)

     

    Hope that helps!

    Chris

     

     

    Christopher Amherst (he, him, his)

    Assistant Director of Advancement Information Systems

    University Advancement

    M 240.412.7929 P 585.475.2959 F 585.475.7004

     

    Rochester Institute of Technology
    116 Lomb Memorial Drive, USC 03401/Rochester, NY 14623

     

    Connect with us:      

     

    CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to
    which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other
    use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.
    If you received this in error, please contact the sender and destroy any copies of this information.

     

     






  • 4.  RE: Address appends

    Posted 10-29-2020 08:20 AM
    I strongly support the approach taken by Chris and RIT.  I also tend to take two additional steps:
    1. I do not put all my eggs in one basket.  I will conduct the same evaluation suggested by Chris for each substantially different type of append - mail, email, phone, cell phone, employment.  While it can be ideal to go with one vendor for everything, not all vendors do everything great.  And some who do, do so at a higher price point.  It is not unreasonable to work with 2-3 different vendors at the same time.
    2. Keep the vendors on their toes.  I revisit my vendor selections every couple of years - and I let my current vendors know that I will be shopping around that often.  It is almost like working with my cable company.  I call them up every so often, threatening to move to another provider - and pretty much every time I do, I get a better deal :-).
    John

    John H. Taylor
    Principal
    John H. Taylor Consulting, LLC
    2604 Sevier St.
    Durham, NC   27705
    919.816.5903 (cell/text)

    Serving the Advancement Community Since 1987







  • 5.  RE: Address appends

    Posted 10-29-2020 10:58 AM

    I like the approach as well. 

     

    A few years ago, we sent a test population out to several vendors, and then researched the records the way we would research them on a one-off basis, compared the work that we were confident in with the results returned by the vendors, and compiled statistics (paying particular attention to identifying information from the vendors that we were confident was about the wrong person!).

     

    In that process, we sent out the same 5,000 records to each of the vendors, but manually checked about 500 of those.  We decided not to send just the 500 records because we wanted to get the scale up past the point where a vendor might, if they were so inclined, do additional manual cleanup that they wouldn't do if we scaled up to the intended six-figure-record-count project.

     

    My US$0.02 worth; the usual disclaimers apply.

     

    Good luck!

     

    Alan

     

    Alan S. Hejnal   

    Data Quality Manager

     

    SNAGHTML5cbfa34

     

    Smithsonian Institution - Office of Advancement

    600 Maryland Ave SW Ste 600E

    PO Box 37012, MRC 527

    Washington, DC 20013-7012

    Voice: 202-633-8754 | Email: HejnalA@si.edu