Mindbody and HubSpot: Run 9 Locations From One System Without the Chaos

The Fork Every Franchise Hits
Every franchise running on Mindbody hits the same fork in the road around the third or fourth location.
Option A: give corporate one system and pour every location’s clients into it. Marketing gets centralized reporting. Franchisees lose access to their own data, and they revolt when corporate emails their members an offer for a service that location does not even sell.
Option B: give every franchisee their own separate system. Franchisees are happy. Corporate has nothing. Cross-location reporting becomes nine exports stitched together in a spreadsheet every Monday.
Both options are wrong. The right setup is one system, with strict per-location data boundaries, and reporting that respects both views at once.
Hypothetical: Iron Lantern Fitness (illustrative) is a 9-location boutique gym franchise across three regions with 6,400 total members. They were running Option A, and three franchisees were openly threatening to leave the network over it. This post is how they got to a setup that works.
What the Wrong Setup Costs You
The wrong setup costs you the network itself. Under full centralization, franchisees feel like tenants in their own business and start looking for the exit, and a franchisee who leaves takes their members and their location revenue with them. Under full fragmentation, corporate flies blind: no view of which regions are healthy, no early warning on churn, no idea how members move between locations. And the cross-location traffic that nobody can see is real money, members you could be nurturing and are not.
Per-Location Boundaries Without Losing the Big Picture
CRMConnect Mindbody to HubSpot supports clean per-location data boundaries. You can control which users and which parts of your organization see which clients and deals, so client data is visible only to the right team. That is exactly what a franchise network needs.
In practice, you set up one division per region, or per franchisee, depending on how you want to slice it. Each Mindbody location is mapped to the right division, and every client and deal that syncs in is sorted accordingly. A franchisee logs in and sees only their own location’s members. Corporate logs in with full access and sees the rollup. The friction over who can see what simply disappears.

Location Tagging: How Cross-Site Reporting Works
Per-location boundaries alone do not solve cross-location reporting. They actually make it slightly harder, because corporate now has to ask the right questions across those boundaries.
Location tagging is the answer. CRMConnect automatically tags each client based on the specific locations where they book, visit, or buy, and keeps that record consistent across every site. Each member carries a list of every location they have ever used, plus a single primary location for the one they use most.
So a member who joined at Iron Lantern Downtown and started visiting Iron Lantern Eastside three months later carries both tags. Corporate can ask “how many of our members use two locations?” and get an answer with one filter. This is the feature that sounds dull on paper and becomes the single most-used view in the whole account once franchisees see it.
Cross-Location Reporting Corporate Will Actually Use
The corporate marketing dashboard at Iron Lantern ended up with five reports, none of them requiring any custom work.
Member overlap. Primary location compared against every location a member has used. Surfaces cross-location usage and helps plan staffing for busy cross-traffic times.
Lapsed members per location. The same lapsed-member logic, grouped by primary location, so each franchisee sees their own at-risk list inside the shared system without seeing anyone else’s members.
Regional revenue by service. Sales grouped by location and service type, which surfaces patterns like “Eastside is winning on intro packs, Downtown is winning on memberships” and tells corporate what to promote where.
Membership status by location. A count of membership status per location, which is the cleanest early warning for churn at the network level.
Cross-regional report card. A single comprehensive report across every location, so corporate can compare locations fairly and spot what is driving network-wide growth.
When a member updates their email at one location, that change propagates to every location they appear at, so corporate is not sitting on stale data in eight of nine locations.

Representative Results at 6,400 Members
These are illustrative composites, not a real customer. In a deployment at this scale, the first month usually surfaces 8 to 14 percent of members touching more than one location. Corporate marketing almost always assumes cross-traffic is a rounding error. It is not, and once it is visible, it changes how regional promotions are designed. You stop sending Downtown-only offers to members who also use Eastside.
Franchisee satisfaction is harder to put a number on, but the shift is consistent. Complaints about “corporate emailing my members the wrong stuff” drop to roughly zero within 60 days, because the per-location boundaries prevent the wrong-list problem at the source. Iron Lantern’s cross-traffic ran at 11 percent, roughly 700 members. The first cross-location campaign they built, a “try our second location” sequence, converted about 12 percent of those into actual visits, adding roughly 80 incremental monthly visits across the network with no new ad spend.
What This Means for Your Network
Use both layers together. Per-location boundaries control access. Location tags drive reporting. You need both. Sync sales and visits to the central rollup, not just per location, or corporate cannot run network reports.
One honest limit: franchises with completely independent ownership and no data-sharing agreement often cannot legally centralize at all. In that case each franchisee runs their own setup and corporate gets nothing, so the contract has to be solved before the systems can be. But for a network that can share data, this setup ends the fork in the road. Corporate gets the reporting it needs to grow the brand, franchisees keep control of their own members, and nobody is threatening to leave.
Want to see CRMConnect Mindbody to HubSpot in action? View the API App page.


