I have a report that shows a list of a signature name, company name, account lead, and account director. There are a lot of duplicates with these records because signature name comes from a ticket property. I am trying to figure out a way to only pull in the contract request ticket against the most recently Closed Won deal. I tried to use the BreezeAI feature to create a filter, but it didn’t work. Anyone have luck with removing duplicates in a list view like this?
Hey @BRegan4 Thanks for your post!
First, you can check this community thread with a workaround to your issue: https://community.hubspot.com/t5/Sales-Hub-Tools/Workflow-on-most-recently-closed-deal/m-p/675904#:~:text=Workflow%201:%20Update%20Product%20Activated,I%20hope%20this%20is%20helpful!
Also I’m tagging a few community experts who may lend a hand here: Hey @karstenkoehler @Jonathan_Vaz @danmoyle I hope you’re having a great day! Any thoughts or resources you can share with us?
Thanks!
Victor
Thank you Victor for the response. Unfortunately that workaround doesn’t fit for my scenario, as this is for report filtering and not pipeline filtering. Hopefully I can pull some ideas from it though!
Hey @BRegan4
I believe association labels could help you here. For example, you could have a Company-to-Deal or Ticket-to-Deal association labeled “Most Recent Closed Won”. You’ll need to set up a workflow to handle this association automatically (to remove the label from older deals and apply it to the newest one). Then you could filter the data sources in your custom report to only include the deals associated with this label (see this article for more details).
Thanks Eugene! We do already have these tickets associated to deals and companies. I do not follow what the next step from the workflow would be. Are you suggesting I create a workflow where the trigger is a ticket with a signature is created and then the next step is to make this the most recently closed deal won? How should I remove this label from the other tickets as well? Thanks!
Hey @BRegan4! Let me clarify the idea a bit.
What I’m suggesting is creating an association label called “Most Recent Closed Won” between the Company and Deal records. Since a company can have multiple deals, this setup ensures that only one deal is marked as the most recent Closed Won at any time.
To make this work automatically, you’d need a Company property such as “Latest Closed Won Deal ID” and two workflows:
Workflow 1 (Deal):
- Triggered when a deal enters Closed Won
- Updates the Latest Closed Won Deal ID on the associated company (optionally includes a short delay)
- Stops after updating the property
Workflow 2 (Company):
- Triggered when Latest Closed Won Deal ID is updated on a company record
- Removes association labels (Most Recent Closed Won) from all associated deals
- Applies association labels (Most Recent Closed Won) to the deal whose ID matches Latest Closed Won Deal ID via Create Association action
@BRegan4 I agree with @EugeneAtKiwi here on association labels possibly working. I also want to call out a third party tool I’ve used in the past that may help. Insycle is a tool that helps with bulk dedupes tickets/deals by custom rules (like signature + latest deal close date). There’s a cost (I think it’s like $100 per month for lots of data) but it’s a great tool.