Latest / MBA Training Data / Identity resolution in pharma: one HCP, six records
Transcript
- 0:00Host: This is Leader's Insights. On the table, 1 HCP, 6 records. Why identity resolution is
- 0:10Host: pharma's most expensive data problem. 6 records for 1 cardiologist. That's the number that
- 0:16Host: stopped me.
- 0:17Expert: 6 is the average I see when I audit a mid-sized pharma's systems. I've seen 11. 1 cardiologist
- 0:23Expert: in Ohio spelled 4 ways, 2 license numbers, 3 addresses because she moved practices twice
- 0:29Expert: and a middle initial that shows up in the claims feed but not the CRM, the customer system
- 0:35Expert: where reps log their visits.
- 0:37Host: And none of them talk to each other.
- 0:39Expert: None. They can't. The CRM knows Dr. J. Ramirez, 400 Elm. The claims data, the record of what
- 0:47Expert: she actually prescribed, bought from a data broker, knows Jennifer Ramirez, MD, NPI,
- 0:54Expert: and the NPI.
- 0:56Expert: The NPI is the National Provider Identifier, the federal 10-digit number every prescriber
- 1:01Expert: gets. And the Analytics Warehouse has a third version built by a vendor 5 years ago that
- 1:07Expert: nobody remembers configuring.
- 1:09Host: So what breaks first?
- 1:11Expert: Sampling. You send free drug samples based on who's a high prescriber. If your cardiologist
- 1:16Expert: is split across 6 records, each one looks like a low prescriber. So you under-sample
- 1:22Expert: your best customer and over-sample 4 ghosts.
- 1:25Expert: I watched a company waste roughly a third of a sample budget that way. That's real product,
- 1:30Expert: temperature controlled, expiring on shelves.
- 1:32Host: A third. Is that your number or someone's marketing deck?
- 1:36Expert: That one's mine, from the audit. But there's a related figure from DBT Labs. They sell
- 1:41Expert: data tooling, so read it with one eyebrow up. Claiming companies spend a huge share
- 1:46Expert: of analyst time just reconciling identities before any actual analysis.
- 1:51Expert: Directionally, I believe it. Cross-check against MIT Sloan Management Review, which has written
- 1:57Expert: for years that data quality, not data volume, is where the money leaks.
- 2:02Host: Let me push on the scary part. You said pharmacovigilance.
- 2:06Expert: Pharmacovigilance. Safety monitoring, tracking adverse events after a drug ships. If a
- 2:11Expert: patient has a bad reaction and the report ties to record number 3, but the prescriber's
- 2:15Expert: actual history lives in record 1, you might miss a pattern. Regulators don't accept
- 2:21Expert: our systems didn't match. As an excuse.
- 2:25Host: Has anyone actually been burned by that on the record?
- 2:28Expert: Nobody puts our identity resolution failed in a press release. What you see is the downstream
- 2:34Expert: symptom. A delayed signal. A warning letter about incomplete reporting. I've sat in the
- 2:39Expert: room after one. The root cause traced back to duplicate prescriber records nobody had
- 2:44Expert: merged. So the lesson the good operators already learned isn't by a matching tool.
- 2:49Expert: Its identity is infrastructure. Treat it like plumbing.
- 2:53Host: Explain the plumbing thing because every vendor says by their tool.
- 2:56Expert: A tool matches records once. Plumbing means you decide permanently which system is the
- 3:02Expert: source of truth for a prescriber's identity, usually the NPI registry because it's federal
- 3:07Expert: and stable. And every other system bends to it. Novartis and a few others move to
- 3:13Expert: what people call a master data approach years ago. One golden record. Everything else points
- 3:19Expert: at it. Boring. Unsexy. Works.
- 3:23Host: But NPI changes. People move, retire, change specialties.
- 3:26Expert: Right. So you don't do it once. You run a match every night against the federal file,
- 3:32Expert: and you keep a survivorship rule. Wania, plain terms. When two records disagree on
- 3:36Expert: her address, which one wins? You write that rule down. Most companies never do.
- 3:43Expert: They match once in a big project. Declare victory. And 18 months later, they're back
- 3:48Expert: to six records because the plumbing had no maintenance.
- 3:51Host: So the failure isn't technical. It's that nobody owns it.
- 3:55Expert: Exactly. Identity has no natural owner. Sales wants their CRM. Analytics wants their warehouse.
- 4:02Expert: Safety wants theirs. Everybody assumes someone else deduplicated. I tell every board, name
- 4:08Expert: one person accountable for the prescriber master record with budget. Or don't bother
- 4:12Expert: buying anything. Give me the one thing a listener does Monday
- 4:15Host: morning. Pick your top 10 prescribers by revenue. Pull
- 4:19Expert: every record for each across your systems by hand. Count them.
- 4:24Expert: If any of those 10 shows up more than once, and they will, you now have the exact dollar
- 4:29Expert: figure your board needs to fund the fix. Don't theorize the problem.
- 4:34Host: Photograph it. Photograph it. That's the takeaway. What we
- 4:38Host: read for this one, DBT Labs vendor data tooling MIT Sloan Management Review.
- 4:44Host: We'll stop there. The whole CDO track and order is waiting at MBA-training.com.