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
When we transitioned to Tessitura in 2020, we decided that we only needed to put three years of ticket buyer data into scope. Our thoughts were, if you hadn't transacted with us in the past three years, we didn't need to invest in ensuring that transaction data that was older than three years was included in marketing communications. We continue to use this metric when targeting lapsed ticket buyers.
As for NCOA, we put all constituents into scope for NCOA. All to us means all constituents that are not deceased, inactive or in a special category (i.e. - VIP donors). We handle VIP donors and the like, manually.
As for your follow up, as I said above, we don't base our NCOA on engagement per se. That said, your file is quite large. Segmenting by year or by some other metric might be a good way to ensure things run smoothly. Maybe segment by calendar or fiscal year and start with constituents that have not transacted in X years (oldest engagement to newest engagement) and progress year by year. For instance, start with constituents whose most recent transaction was five years ago for the first file. Next, create a file with constituents whose most recent transactions were four years. Continue this until you get to the current year. Doing this will ensure you have a chance to understand the sizes of the data sets and how the process is affecting the data once you get to the most recent. By this time, you'll know if you want to segment the files into a smaller set or if you need to use a different selection criteria.
I will also recommend that you do ALL of this in your TEST (or similar) environment first. We always run our NCOA process in DEV first before we run it in PROD (we use DEV because we use it as a volatile environment for development, our TEST environment is used for stable development releases and we don't consider NCOA a stable process). We QA the process in DEV by taking a standard deviation of records after the vendor has completed the NCOA process on them and review them. This is usually around 1,000 records. Our data team scrutinizes the records to ensure things look proper.
Good luck and feel free to reach out with any other questions.