Hi all,
We're in the process of working with Experian to do our first NCOA in many years. For our first pass at this process, we've opted to NCOA as many records as possible in 4 rounds. We have roughly 3,000,000 records in our database and I'm curious if any of you have insight/experience/advice about the following things:
1. How many years back should we consider casting the net for lapsed ticket buyers? Is there a standard number of years that acts as a reasonable cut off point?
2. As a follow up, what if we exclude certain ticket buyers based on our cutoff who engage with the museum post- NCOA, and don't have an updated address? How common is this and any recommendations for dealing with that?
3. Any further recommendations about how to segment records for an NCOA of this scope?
Thank you!
Kristin
John A. Moskal II said:I also dislike overwriting existing data for the reasons you state.
Agreed. Like some of you, I think, I also run custom SQL for the NCOA "process" step, and move addresses that that process would overwrite to a new, inactive address set to a custom "Bad Address (fr. NCOA)" address type. Overwriting address data is bizarre and unacceptable.