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.