We've encountered an issue where some companies are appearing with 4x the expected records and certain users with up to 12x. After investigating, we discovered that our system was assigning different userIDs to the same email addresses and, in some cases, associating the same company name with multiple companyIDs. Additionally, we found instances where data was being overwritten, causing users' names to change mid-chat.

I noticed there are options to either delete or archive companies, but I'm unsure which approach would be best in this situation. Has anyone experienced something similar or have recommendations and best practices for handling this kind of data duplication or conflict?