The 4 Digital Trends Driving the Future of Healthcare
Jun 21, 2021 • 4 Minute Read • Ross Lucivero, Chief Product Officer
Healthcare manufacturers that sell through distribution often treat master data management (MDM) as a record-cleanup exercise. But that creates a blind spot and doesn't explain how customers relate to one another across the business.
For an individual hospital, clinic, or site of care, customer data returns to the manufacturer from multiple sources in different formats, and the same facility may appear in several ways. Matching those records is important, but it only solves part of the problem. That facility may belong to a larger health system, purchased through a Group Purchasing Organization (GPO) agreement, and sit inside separate sales, finance, and marketing views at the same time.
That gap becomes especially obvious when an executive asks a simple question: How much did we sell to this health system in total?
The account may be accurate to the penny, but if orders aren't consistently tied to the facilities that received them, and those facilities aren't tied to the health system that owns them, the answer isn't easy to find. In one case, it took two weeks, three people, and a spreadsheet to piece it together. But because the answer came from manual analysis rather than from a maintained customer structure, the process didn't become easier the next time. Six months later, when the same question came up again, the team had to redo the work.
While the question was answered once, the company didn't fix the underlying structure that connects transactions to customers and the relationships behind them.
Resolving customer identities is the starting point for understanding customer relationships. If the same hospital appears under several different names, matching those records can establish that they represent the same facility and create a trusted record for it.
But the decisions manufacturers need to make rarely stop at the individual customer. Sales, contracting, compensation, and reporting may each depend on understanding that customer within a different set of relationships, and in almost every business, those relationships overlap and change over time.
That’s where the limits of a single golden record become apparent. It can establish a trusted version of the customer, but it doesn’t, by itself, capture all the ways the customer needs to be understood across the business.
This is why the real MDM challenge isn’t simply establishing who the customer is, but also understanding how that customer relates to the rest of the business.
The goal of MDM is to establish a common customer structure that supports multiple legitimate views that different teams need:
Trying to force all of those needs into a single hierarchy is extraordinarily complex, if not impossible.
It also creates another problem in which one team's requirements inevitably begin to shape the master record. At the same time, other teams create spreadsheets and workarounds to get the views they need.
The better approach is to establish a canonical spine: a shared structure that defines the core customer entities and relationships the business can agree on while allowing different business views to then be mapped back to that common structure.
For example, the canonical spine might establish that Hospital A is a facility owned by Health System B. Sales can then map that facility to its territory, contracting to its GPO relationship, what distributor sold to the facility, and finance to the compensation structure it uses, without any one of those views having to become the master. In so doing, Sales can reorganize territories without changing how contracting, finance, or marketing understands the customer.
Building this canonical spine requires more than cleaning up records, but it’s also well within reach with the right strategy and tools. Here are a few steps to take MDM to the next level:
Document the different ways customers are grouped today, such as by corporate ownership, purchasing organization, territory, compensation structure, or other business need, and identify who owns each definition. This exercise often exposes duplicate, conflicting, or outdated views before any technology changes are made.
Determine which entities and relationships need to form the shared foundation. Remember: the goal of the canonical spine isn’t to make one hierarchy serve every purpose, but to establish a stable structure that different business views can reference.
Sales, finance, contracting, and marketing can retain the groupings they legitimately need, but those views should connect to the same underlying customer structure. This is what allows teams to answer different questions without creating different versions of the customer.
New distributor data will continue to arrive, facilities will change ownership, and business requirements will shift. Designated owners should manage how those changes are reflected in the structure and ensure updates flow through to the systems and processes that depend on it.
For manufacturers selling through distribution, customer relationships aren’t something to be cleaned up once. Their business infrastructure needs to be actively managed continuously. As more organizations come to that realization, MDM is likely to become an ongoing commercial function.
Pricing followed a similar path, evolving from spreadsheets and ad hoc decisions into a recognized business discipline with dedicated ownership, processes, and governance. As customer relationships become more complex, and more commercial decisions depend on understanding them, MDM will require the same kind of sustained attention.
The shift from managing records to managing relationships can close a longstanding blind spot, giving manufacturers a clearer view of who their customers are, how they relate, and where the opportunities lie.
If you need to move beyond record matching and build a clearer view of customer relationships across your business, Verndale's Data & Analytics team can help you define the right structure and put it into practice. Talk with our experts.