I’m doing some database cleanup and have a number of accounts that were tagged with an incorrect constituent type when they were converted during the Tessitura integration. For example, id 12345 “Mr & Mrs Smith” is tagged as a corporate constituent type, but should really be a household. However, I have no idea what first name or even first initials are, so I can’t change the type in the front end of the client. (I should mention that all of the accounts I've checked are ancient and have no recent activity on them).
What is the harm/is there harm in me changing the type in SQL so that I have a more accurate count of constituent types? Or would you choose a placeholder letter/name? Or is this one of those things I should just live with?
All really good points. I sometimes feel like I'm on an episode of Hoarders and people are reluctant to give up (inactivate) anything. I may try to persuade people to let me inactivate one more time because I have SO MANY dirty old records.
Thanks for letting me bounce thoughts around.
At one point, I went and inactivated 10K+ accounts without asking anyone and waited for someone to complain. There was a brief question in e-mail about our marketing e-mail counts going down a little which I pretended to not see. Beyond that, I never heard a single word.
Just ask your staff if those old records are sparking joy. ;)
Beyond inactivation, my consortium has started merging constituent records that have no contact info and have had no activity in X years into our General Public account and then purging that record on a regular basis. Of course that's just one approach to cleaning, but the idea is that as these records age they become less useful (if they ever were) and cleaning them up (i.e. inactivating, consolidating) makes the remaining constituent records more valuable.
To your initial question about changing the constituent type to Household, though, while it's simple enough to change the cust type in the backend, like others have mentioned, creating affiliations, etc. adds another layer of complexity. Also, once those records are households, merging and data cleanup become a little more complicated as well. You could instead convert these records to the Individual customer type and either set the prefix or fname to "Mr & Mrs". Then, if your staff do have more info on these constituents they can manually switch the record to a household from the front-end and update the records as appropriate. Maybe after an agreed-upon amount of time the records that are still individuals could be inactivated en masse.