Seeking Solutions for Identifying Merged Deals in Exports

Hello HubSpot Community,

I’m reaching out to gather insights or potential solutions for a challenge we’re facing related to deal merges in HubSpot.

The Challenge: In our CRM operations, we often merge duplicate deals. While the primary deal is updated, secondary deals (those merged into the primary) become inaccessible. This is manageable within HubSpot, but it becomes problematic when exporting data to external systems, like Google Sheets, for reporting purposes. The export includes all deals, including merged ones, leading to discrepancies and inflated metrics compared to reports generated within HubSpot.

The Core Issue: We need a way to identify which deals have been merged into others in the exported data. This identification is crucial for maintaining the accuracy and integrity of our reporting and analysis in external systems.

Specific Questions:

  1. Tracking Merged Deals: Does anyone know if HubSpot internally marks secondary deals as merged? If so, how can this information be accessed, especially via API or in exported data?
  2. API or Export Strategies: Has anyone successfully used the API or any export strategies to distinguish merged deals in external data analysis?
  3. Workarounds or Best Practices: Are there any workarounds or best practices that you have found effective in dealing with this issue?

I am aware of the “Merged Deal IDs” property in HubSpot, that helps provide a list of record IDs of secondary deals, which allows us to indirectly identify them. But we are looking for a direct way to identify secondary deals. I’m thinking there has to be a property or status that secondary deals have when they get merged into primary deals.

Our goal is to ensure our external reporting reflects the same accuracy and integrity as our internal HubSpot reports. Any insights, experiences, or suggestions from this knowledgeable community would be greatly appreciated.
Thanks in advance!

Hi @BooleanReview,

“Merged Deal IDs” is, as far as I know, the only way to identify which records have been merged. You’re mentioning that this can only be used to indirectly identify the secondary deal: that’s because (after merging) the secondary deal technically does not exist anymore. If there isn’t any way to search and find it in HubSpot, there isn’t any way to directly identify it.

In other words, you would either have to use “Merged Deal IDs” or rethink your integration with Google Sheets.

Best regards!