Need Description Currently, HubSpot offers a deduplication tool that works well for identifying duplicate contacts, companies, and deals based on standard properties. However, many businesses need to identify duplicates based on specific custom fields, such as contract numbers, customer codes, or other unique business identifiers. Current Problem When an organization needs to identify duplicate records based on a custom field (like "Contract Number"), the only available option is to export the data to external tools such as Excel or Google Sheets and use functions like VLOOKUP to manually identify duplicates. This process is: Inefficient and time-consuming Prone to human error Does not allow for real-time proactive actions Makes data cleaning automation difficult Proposed Solution We would like to suggest creating a functionality that allows: Configuring deduplication rules based on custom fields Creating dashboard cards that display records with duplicate values in specific fields Applying additional filters (such as "Active" status) to refine the view Offering quick actions to resolve duplicates directly from the dashboard Implementation Benefits Improved data quality for all HubSpot users Reduction of manual processes and increased operational efficiency Proactive prevention of problems related to duplicate records Greater integrity of business-critical data Reduction of operational costs related to data cleaning Broad Use Cases This functionality would be useful for various HubSpot customer segments: SaaS companies that manage subscriptions with contract numbers Financial service companies that need to ensure uniqueness of records by customer codes Retailers who need to identify duplicates in orders or promotional codes Healthcare organizations that need to ensure patient records are not duplicated Any business that uses unique codes or numbers to identify customer relationships Thank you for considering this functionality in future versions of the HubSpot platform, as it would benefit a wide spectrum of users across different industries.
...read more