Hubspot add is-merged field to (deal) table
Answered
When a deal is merged, the deal that remains will have these fields like this:
Deal id: 4011798071
hs_merged_object_ids: 3988824107;3983739007;
However, the deals 3988824107 and 3983739007 are still in the deal table.
This is an example from my warehouse.
Would it be possible to add a boolean is_merged field to the deals table so I can filter them out like you have an is_deleted field on many tables?
Now I have to create a view by listing all ids that can be found in hs_merged_object_ids and joining it back to the raw deal table which was a very complex query to write.
0
-
Official comment
Hi Florian, Drew from the Product Team here! Thanks for submitting this request.
While we don't have anything planned immediately, I will look into potential strategies to address the challenge of identifying merged deals. I will update here when anything changes.
Please sign in to leave a comment.
Comments
1 comment