I’ve seen that thread and tried that approach. Here’s why it doesn’t work:
- It returns records who have EVER had multiple email addresses, rather than the ones who currently have multiples. There’s no way that I can see to distinguish between the two circumstances, meaning this approach gives us at best a more limited set of records to have to dig through manually.
- This is itself a manual approach, requiring us to export the data regularly, massage it, and winnow down the list before more manual work begins. Having to pull data out of a software platform to manipulate it on another platform just to get at information that is VISIBLE IN THE ORIGINAL PLATFORM is mind-numbing.
HubSpot does a lot of cool stuff, but some of these decisions are just bafflingly ill-conceived.