Hello, @Andrew-CI thank you for your feedback, I would like to apologize for the frustrations, data issues, and business impact this has caused. Have you connected with our technical support about this matter? I would recommend connecting with HubSpot Technical Support, as Support is included in your subscription and they will be able to provide real-time assistance for this matter, including hopping on a screen share if necessary. This way they can check your case specifically with more information you will be able to provide.
Thank you,
Pam