Struggling with account-level visibility in HubSpot when your "customer" is a multi-location business — anyone solved this?
RevOps at a marketplace/delivery logistics platform (B2B, non-SaaS, transactional revenue model). Looking for how other people have architected this because I think I'm missing a pattern.
The core problem:
Our customers are enterprise accounts with multiple locations — think a regional or national brand with a headquarters and dozens of individual branches. In HubSpot, Company records are tied to backend warehouse data (orders, activity, revenue) at both the HQ level and the individual location level.
Here's where it breaks: when leadership asks "what's happening with this account," they mean the account as a whole — HQ relationship plus every location combined. But our actual motion is split. Reps work individual locations directly. A separate group works the corporate/HQ relationship in parallel. Two conversations, two levels of the hierarchy, nothing rolls them up into one coherent account view.
One nuance that matters here: our "total number of locations" per account isn't fully trustworthy — years of history means locations that closed or reopened are still sitting in records. But active locations — the ones with current rep activity or recent revenue — are accurate, because that engagement is a live signal. So I'm not trying to fix a data quality problem. I'm trying to figure out how to build a reliable "active/engaged account" rollup that leadership can trust, separate from the messy historical location count. Basically trying to provide visibility into the conversations happening at the account potentially across the locations from a branch level and then at the enterprise level as well to tell a total "account context" story. For the most part, we have a list of main "named accounts" or target accounts we care about. Probably no more than 100. Again thats total accounts, they have locations within that.
Secondary context (not the main ask): we're also building out a three-pipeline structure — systems integration, MSA/pilot, and expansion — to support revenue forecasting, which is genuinely hard in a marketplace model. That's a forward-looking project, not something I need solved today. Mentioning it in case it's relevant to how you think about the account rollup, but the pipeline forecasting question is a separate thread for me.
What I'm actually looking for:
Anyone dealt with parent/child account hierarchies in HubSpot where engagement happens at the child level but the relationship needs to be reported at the parent level?
How are you providing visibility into the activity and conversations of the account as a whole and surfacing signals?
Any patterns (custom objects, associations, dashboards, non-HubSpot tools) for a single "state of the account" view when the account spans multiple locations and multiple relationship layers?
We are investing HEAVILY into Claude so I have been looking at that as part of the main tool/solution.