HubSpot Tickets & Deals: Unlocking Customer Insights with Roll-Up Properties

Hey ESHOPMAN community! Ever found yourself wondering how to get a complete picture of your customer's journey, especially when they have an active service ticket but also multiple open deals with your sales team? It's a common challenge, and one that highlights the power of a well-configured HubSpot CRM.

Recently, a fascinating discussion popped up in the HubSpot Community that really hit home for anyone trying to bridge the gap between service and sales. The original poster asked a crucial question: "Is it possible for a ticket to keep track of all the deals it's associated with? If a ticket is associated to 3 deals and all 3 deals are in the same stage, then do something with the ticket?"

This isn't just a hypothetical scenario; it's a real-world need for RevOps teams, marketers, and anyone running an online store. Imagine a customer submits a support ticket about an existing product. Wouldn't it be incredibly valuable for the service agent to immediately see that this customer also has two new sales deals in the 'Proposal Sent' stage? Or perhaps that all their deals are currently 'Stuck in Negotiation'? This level of insight can transform reactive service into proactive customer success.

The HubSpot Challenge: Out-of-the-Box Limitations

As one helpful community member, a seasoned HubSpot expert, pointed out, this specific functionality isn't available "out of the box." HubSpot is incredibly powerful, but directly aggregating the status of multiple associated deals onto a single ticket isn't a native feature that just appears when you associate records. This is where many businesses, especially those who might have started with a simpler online store creator or a basic CRM, often hit a wall when trying to scale their operations and gain deeper insights.

However, HubSpot's flexibility shines through with its custom property capabilities. The solution proposed by the community member is elegant and leverages one of HubSpot's most powerful, yet sometimes underutilized, features: roll-up properties (a type of calculation property).

The Solution: Mastering Roll-Up Properties for Deal Status Tracking

So, how do you make a ticket 'aware' of its associated deals' statuses? Here's the step-by-step approach, broken down from the community expert's advice:

1. Count the Total Associated Deals: First, you need a property on your Ticket object that simply tells you how many deals are linked to it.
2. Count Deals Meeting Specific Criteria: Next, create another property that counts only the deals associated with the ticket that meet your specific criteria – for example, deals in the 'Proposal Sent' stage, or 'Closed Won', or any other stage you're interested in tracking.
3. Compare and Trigger with a Boolean Property: Finally, use a boolean (true/false) calculation property to compare the two counts. If they match, it means all associated deals are in that specific stage, allowing you to trigger workflows or surface vital information on the ticket itself.

Step-by-Step Guide to Setting Up Your Roll-Up Properties

Let's walk through how to implement this in your HubSpot portal:

1. Create a Roll-Up Property to Count All Associated Deals

• Navigate to Settings > Properties.
• Select the Ticket object.
• Click Create property.
• Object type: Ticket
• Group: Ticket information (or a custom group like 'Deal Tracking')
• Label: Number of Associated Deals
• Field type: Calculation
• Choose Custom equation.
• Select Rollup.
• Associated record: Deal
• Property to calculate: Count all associated records.
• Click Create.

2. Create a Roll-Up Property to Count Deals in a Specific Stage

• Repeat the steps above to create a new Ticket property.
• Label: Deals in 'Proposal Sent' Stage (or whatever stage you're tracking)
• Field type: Calculation
• Choose Custom equation.
• Select Rollup.
• Associated record: Deal
• Property to calculate: Count all associated records that meet certain criteria.
• Click Add criteria.
• Select Deal stage > is any of > Proposal Sent (or your desired stage).
• Click Create.

3. Create a Boolean Calculation Property to Compare Counts

• Again, create a new Ticket property.
• Label: All Deals in 'Proposal Sent' Stage?
• Field type: Calculation
• Choose Custom equation.
• Enter the following formula, replacing the bracketed property names with the internal names of the two properties you just created:

IF( "[Number of Associated Deals]" == "[Deals in 'Proposal Sent' Stage]", TRUE, FALSE )

• Click Create.

Now, this new boolean property will show TRUE if all deals associated with that ticket are in the 'Proposal Sent' stage, and FALSE otherwise. You can use this TRUE/FALSE status to trigger workflows, send internal notifications, or simply highlight important context on the ticket itself. This kind of advanced configuration goes far beyond what a simple wix online store builder or basic CRM can offer, providing deep, actionable insights for your team.

Why This Matters for ESHOPMAN Users and RevOps Teams

For ESHOPMAN users, who are deeply integrated with HubSpot's CRM and sales tools, this type of cross-object data visibility is gold. Imagine a customer has multiple subscriptions or high-value repeat purchases managed as separate deals. A service ticket comes in for one of their products. By implementing these roll-up properties, your service team immediately knows if there are other critical deals in progress or at risk. This enables:

• Proactive Customer Success: Identify customers who might be experiencing issues across multiple products or services.
• Sales Alignment: Service agents can be empowered with sales context, knowing when to escalate or when to reassure a customer based on their overall deal status.
• Improved Data Accuracy: Ensures a single source of truth for customer status, avoiding silos between departments.
• Automated Workflows: Trigger follow-up tasks, internal alerts, or personalized communications based on the combined status of tickets and deals.

ESHOPMAN Team Comment

We absolutely love this solution from the HubSpot Community. It's a prime example of how HubSpot's robust customizability can solve complex business challenges that aren't addressed by out-of-the-box features. Leveraging roll-up properties for cross-object insights like tracking deal status from tickets is a powerful strategy. For ESHOPMAN users, this means a more unified view of your e-commerce customers, allowing you to provide smarter service and drive more informed sales conversations, ultimately enhancing the entire customer lifecycle.

The ability to connect service interactions directly to sales opportunities, and vice-versa, is what truly differentiates a powerful platform like HubSpot (especially when paired with ESHOPMAN for your storefront) from basic stand-alone solutions. Don't just track individual records; build connections that tell the whole customer story. Your RevOps team, your sales team, and most importantly, your customers will thank you for it.