Technology Enterprise Software & IT Data Platforms & Analytics

Master Data Management

Platform decisions with deep integration complexity, organizational change, and long-term data stakes.

Informatica SAP IBM Reltio
Inside this journey
  1. Pre-Discovery

    Align decision-makers, timelines, and constraints to prevent scope creep and political roadblocks.

    1. Stakeholder Alignment

      Confirm decision roles, timelines, risk tolerances, and what ‘good’ looks like to prevent political roadblocks and scope creep.

      Alignment Questions

      Starting Together: What's at Stake for Your Team

      • Briefly: what single event or trigger brought you to consider a master data pilot today? Options: Merger/Acquisition, Revenue reporting discrepancy, Regulatory requirement, Operational pain (duplicates), New executive mandate, Other
      • Tell us in one short sentence: what outcome would make this conversation worth your time?
      • How severe is the business impact today—are we looking at lost revenue, regulatory risk, operational cost, or reputational exposure (choose the best fit)? Options: Material revenue impact, Regulatory/compliance risk, High operational cost / inefficiency, Reputational risk, Multiple of the above, Unclear
      • Who in your org feels the pain most acutely today (names/titles are fine)?
      • Have you tried to fix this before (e.g., spreadsheets, scripts, existing MDM, ERP/CRM native tools)? If yes, what stopped it from scaling? Options: Spreadsheets/manual work, Homegrown scripts/tools, ERP/CRM native features, Legacy MDM vendor, Governance/political resistance, Never tried before, Other
      • How quickly do you need proof that a phased MDM approach can deliver value? Options: Within 2 weeks, 2–6 weeks, 6–12 weeks, 3+ months, Unsure

      If This Keeps Going, What Breaks First?

      • If duplicate records and inconsistent IDs continue unchecked, what is the first measurable thing that will fail—reports, billing, regulatory filing, or executive trust? Options: Financial reporting, Customer billing/collection, Regulatory submissions, Sales/forecast accuracy, Customer experience, Executive confidence
      • How often do you discover material errors (e.g., overstated revenue, duplicate accounts) in your regular reports? Options: Weekly, Monthly, Quarterly, Rarely, Don't know
      • Can you share a recent example where master data issues caused a costly or embarrassing outcome? What happened and who was impacted?
      • When data-driven teams distrust reports, what workaround do they use (manual reconciliation, ad-hoc queries, avoid using system)? Options: Manual spreadsheets, Ad-hoc SQL queries, Avoiding the system / siloed work, Rely on single source app (CRM/ERP), Other
      • How would continued distrust in golden records affect upcoming strategic initiatives (M&A, new product launch, regulatory audit)?
      • On an emotional level, how confident do executives feel about the numbers they make decisions from today? Options: Very confident, Somewhat confident, Wary / anxious, Not confident at all, They avoid making decisions

      Who's Actually Driving the Decision—and Who Can Stop It?

      • If governance were a tug-of-war, who are the teammates pulling you forward—and who could pull the rope the other way? Options: CDAO/Chief Data Officer, VP Data Management, CFO/Finance, Head of Sales/Revenue Ops, Legal/Compliance, IT/Platform, Line-of-business owners, Other
      • Which role must sign off on a pilot (technical, business, legal, procurement)? Please list titles and decision criteria if known.
      • How tolerant is your executive team of risk and experimentation—are pilots encouraged to fail fast, or do they require near-perfect results from day one? Options: High tolerance (experiment freely), Moderate (controlled experiments), Low tolerance (need predictable outcomes), Zero tolerance
      • Who is likely to resist a neutral MDM hub governing records, and what are their main concerns? Options: Application owners (CRM/ERP), Regional data stewards, Legal/Privacy, Business unit leaders, Other
      • If political resistance arises, what escalation path or sponsor exists to resolve it? Options: CDAO/CDO sponsor, CFO sponsor, CEO/Board escalation, No clear sponsor, Other
      • What would convince your skeptical stakeholders that a single-domain pilot won't become a three-year enterprise rewrite?

      Where Does the Data Live—and Where Is It Broken?

      • If you had to hand us the single worst system for customer data right now, which system would that be and why? Options: Legacy CRM, ERP/Finance, Billing system, E-commerce platform, Custom application, Data warehouse/BI, Other
      • Which systems contain the same entity (customer/product/supplier) that you want to reconcile for the pilot? Options: CRM, ERP, Billing/Payments, E-commerce, Marketing platforms, Data warehouse/BI, Third-party lists, Other
      • Do you have a representative sample available for the pilot (e.g., 100K customer records across two systems)? If yes, where is it stored and who owns access? Options: Ready in DB/CSV, Ready but requires masking, Needs extraction, Not available yet, Unknown
      • Describe the most common data quality problems you see (missing IDs, name variations, address inconsistencies, outdated contacts, duplicate account hierarchies). Options: Missing IDs, Inconsistent names/spellings, Address variations, Stale contact info, Duplicate hierarchies/parent-child issues, Incorrect account types, Other
      • Approximately what portion of records do you suspect are duplicates or near-duplicates today? Options: <5%, 5–15%, 15–30%, 30–60%, >60%, Don't know
      • Are there regulatory or contractual restrictions (PII handling, residency, masking) that would affect data extraction or processing for a pilot? Options: Yes—strict, Yes—manageable, No restrictions, Unsure
      • Who currently owns the canonical identifiers or 'source of truth' for this entity (team/title)?

      What Would a Trusted Golden Record Actually Enable?

      • Imagine analysts stopped manually verifying merged records—what business activity would change first and most meaningfully? Options: Revenue reporting, Regulatory reporting, Customer service accuracy, Sales targeting/upsell, Billing reconciliation, Other
      • What acceptance thresholds would convince business users to trust golden records without manual checks (e.g., match precision, recall, golden-record completeness)? Options: >95% precision, >90% recall, X% field completeness, Business-rule validation pass rate, User sign-off/trial period, Other
      • Which KPIs will you use to judge pilot success (pick up to three)? Options: Reduction in duplicate accounts, Improved revenue accuracy, Time saved in reconciliations, Fewer regulatory exceptions, User trust / adoption rate, Reduced support tickets, Other
      • What level of automation vs. human review is acceptable during pilot validation (fully automated merge, rule-based with human audit, human-in-the-loop for edge cases)? Options: Fully automated, Rule-based with sample audits, Human-in-the-loop for merges, Hybrid depending on confidence score, Prefer manual initially
      • If we deliver golden records for one entity/domain, which downstream system should receive synchronized results first to demonstrate value? Options: CRM, Billing/Finance, Data warehouse/BI, Customer service platform, Marketing system, Other
      • What would be the smallest, most convincing success signal you'd accept to greenlight scaling (example: 100K records matched with X% accuracy and stakeholder sign-off)?

      What Could Scuttle a Pilot Before It Starts?

      • If this pilot fails internally, what's the single most likely reason it would be killed? Options: Data access delays, Political/blocking by app owners, Poor match quality, Scope creep / shifting goals, Budget cuts, Legal/privacy issues, Other
      • Which of the following is your team's biggest constraint right now (pick one)? Options: Limited engineering/ETL time, Legal/privacy review backlog, No clear sponsor, Unclear scope, Insufficient sample data, Competing priorities
      • What mitigation already exists or could be mobilized quickly if we hit resistance (executive sponsor, technical champion, legal signoff template)? Options: Executive sponsor identified, Technical champion committed, Pre-approved data handling, Fast-track procurement, No mitigation currently, Other
      • How comfortable are you with a phased pilot that intentionally limits scope to one entity/domain and one target system? Options: Very comfortable, Somewhat comfortable, Hesitant—prefer broader scope, Opposed
      • What absolute non-starter constraints must we know now (e.g., cannot move PII off-prem, budget ceiling, legal non-negotiables)?
      • Who needs to be looped in immediately to avoid delays (names/titles/email preference)?

      Next Steps: Small Commitments That Prove Big Value

      • Which pilot boundary feels most realistic to you for a first proof (pick one)? Options: Customer domain across 2 systems (100K records), Product domain in one system (50K SKUs), Supplier domain for a single region, Account hierarchies for one business unit, Other
      • What sample size do you feel comfortable committing to load for initial evaluation? Options: 10–25K, 25–100K, 100–250K, 250K+, Unsure / want guidance
      • How quickly could your team provide an extract or read-only access to the chosen systems? Options: Within 1 week, 1–3 weeks, 3–6 weeks, Longer than 6 weeks, Need approval
      • Who would be the day-to-day owner for the pilot on your side (name/title), and who is the executive sponsor we should reference in our plan?
      • Which acceptance milestone would trigger a commercial/phased expansion conversation (e.g., user sign-off, KPI hit, reconciliation reduction)? Options: Business user sign-off, KPI threshold met, Successful sync to target system, Risk/regulatory acceptance, Other
      • What outstanding questions or hesitations should we address in the first week to keep momentum?
      • Finally: what would you like to see in a one-page pilot plan from us by the end of next week? Options: Scope and timeline, Data access checklist, Acceptance criteria and KPIs, Roles and responsibilities, Commercial terms / phased pricing, All of the above
    2. Current State Mapping

      Inventory systems, sample availability, duplicate pain points, and reporting/regulatory gaps that the pilot must address.

      Current State

      Where Does This Live Today?

      • Which systems do you believe currently contain customer records we should consider for the pilot? (select all that apply) Options: CRM (Sales/Service), Billing/Finance system, ERP, Data warehouse / lake, Marketing automation, Order management, Support/Case system, Analytics/BI, Proprietary/line-of-business app, Other (list below)
      • Which two source systems would you prioritize for sampling if we had to pick a focused pilot pair? Options: CRM, Billing/Finance, ERP, Data warehouse, Marketing, Support/Case, Custom app, Other (specify)
      • Roughly how many customer records exist in each prioritized source (estimate per system)? Options: <10k, 10k–50k, 50k–100k, 100k–500k, 500k–1M, >1M, Unknown / need to investigate
      • Who are the technical contacts or teams that own extracts for these systems? Please list names and roles.
      • Are automated extracts permitted from these systems, or do we need manual exports/approvals? Options: Full automated extracts permitted, Extracts allowed with approvals, Only manual exports allowed, Extracts restricted for certain fields (PII), Unsure — need to confirm
      • How often do those systems currently synchronize customer information with each other, if at all? Options: Real-time sync, Daily batch, Weekly, Ad-hoc/manual, No synchronization today, Unsure

      Are We Counting Duplicates as Real Customers?

      • If a month-end revenue report overstated sales because duplicates were treated as separate customers, how would that change how your leadership prioritizes this work? Options: Immediate top priority, High priority but needs proof, Back-burner until compliance forces it, Not a priority / skeptical, Unsure
      • Can you describe a recent incident where duplicates or inconsistent customer records caused a measurable business problem (revenue, regulatory filing, customer experience)? Tell us what happened and who noticed it.
      • How frequently do downstream teams request manual reconciliations or spreadsheets to resolve customer identity issues? Options: Daily, Weekly, Monthly, Quarterly, Rarely, Never
      • Which business processes suffer most when customer identity is unclear (select top three)? Options: Revenue recognition / billing, Regulatory reporting / compliance, Customer service / case routing, Sales pipeline accuracy, Fraud detection, Marketing segmentation, Credit/limits/collections, Other
      • When duplicates are found today, how are they resolved and how long does resolution typically take? Options: Automated merge rules, Manual analyst reconciliation, Business owner adjudication, Left unresolved, Other — describe
      • How does the existence of duplicates make your stakeholders feel—frustrated, distrustful of reports, anxious about audits, or something else? Options: Frustrated, Distrustful of data, Anxious about audits, Indifferent, Other — describe

      What's Hidden in the Data?

      • If we pulled a random sample of 10,000 records from your prioritized systems today, roughly how many would you expect to be missing critical matching attributes (email, phone, postal address, tax ID)? Options: <10%, 10–25%, 25–50%, 50–75%, >75%, Don't know
      • Which fields do you view as essential for reliable matching in your environment (pick all that apply)? Options: Full name, Email, Phone, Postal address, Company registration / tax ID, Account number, External identifiers (CRM ID), Other — specify
      • Are global or authoritative identifiers available and consistent (tax ID, national ID, vendor codes), and for what proportion of records? Options: Yes, for most records, Partial coverage (20–50%), Rarely available, Never available, Unsure
      • Describe the most common data quality patterns you've noticed (formatting issues, transposed fields, legacy codes, merged accounts). How often do these patterns repeat?
      • Do you have PII, residency, or regulatory rules that limit which fields we can copy or process for a pilot? If so, which ones? Options: No restrictions, PII allowed with anonymization, PII restricted (cannot be moved), Cross-border residency restrictions, Need legal sign-off, Unsure
      • How long would your team need to assemble and secure a 100k-record sample (including approvals and anonymization if needed)? Options: <1 week, 1–2 weeks, 2–4 weeks, >4 weeks, Depends on approvals

      Who Holds the Keys—and Who Says No?

      • Who in your organization could effectively block a pilot because they fear losing control or ownership of their system’s data—and what is their primary concern?
      • Which stakeholders must be engaged or sign off before we proceed (pick all that apply)? Options: VP Data Management, CDO / Head of Data, IT Ops / Platform team, Application owners (CRM/ERP), Legal / Privacy, Finance, Business unit leaders, Other — specify
      • How have system owners responded to past centralization or shared-governance efforts—were they cooperative, resistant, or conditionally supportive? Options: Cooperative, Resistant, Conditionally supportive, Indifferent, No past interactions
      • What governance model is currently in place for master data (centralized, federated, business-unit owned, none)? Options: Centralized, Federated, Business-unit owned with informal rules, Ad hoc / no formal governance, Hybrid
      • When there’s disagreement about a golden record, what decision mechanism would your organization trust most—technical rules, business owner adjudication, or an executive sponsor? Options: Technical deterministic rules, Business owner adjudication, Executive sponsor decision, Third-party arbitration, Combination
      • How long has governance been an active agenda item, and what internal politics should we be mindful of during a pilot?

      If We Ran a Pilot Tomorrow—Would You Trust the Results?

      • What minimum golden record accuracy or trust threshold would let your analysts stop manual verification (select one)? Options: ~90%, ~92–94%, ~95–96%, ~97–98%, ≥99%, Need different metric / unsure
      • Which acceptance KPIs matter most to your team for pilot success (pick up to three)? Options: Precision / false-positive rate, Recall / false-negative rate, F1 or composite match score, Reduction in manual reconciliations, Time-to-resolution for duplicates, Downstream reconciliation errors, Regulatory accuracy metrics, Other — specify
      • What sample size do you feel is persuasive for evaluation: 10k, 50k, 100k, 500k, or something else? Options: 10k, 50k, 100k, 500k, Other — specify
      • Are there acceptance constraints tied to external auditors or regulators that would affect whether a pilot's results are deemed valid? Options: Yes — specific auditor/regulator rules apply, Possibly — needs legal review, No external constraints, Unsure
      • Who in your organization will formally accept pilot results and what practical criteria will they use (names/roles and criteria)?
      • If we demonstrate golden records that meet your thresholds, what would you consider an appropriate next step to scale (expand systems, add entity types, governance ramp)? Options: Expand to second system pair, Add one new entity domain, Move to phased roll-out, Create center-of-excellence, Other — describe

      What Could Break This Before It Starts?

      • What's the one failure mode that would make this pilot feel like 'another failed MDM project' in your organization?
      • Do you face legal, privacy, or data residency constraints that could prevent us from copying or processing data for matching? Options: Strict constraints — additional approvals required, Allowed with anonymization, No constraints for pilot data, Unsure — need legal review
      • What internal resourcing limitations (people, time, connectivity) are most likely to delay a sample extract or the pilot itself? Options: Lack of engineering time, Security/legal approval delays, Business owner bandwidth, Network / access issues, Other — specify
      • Are there competing initiatives or change fatigue that could cause stakeholders to deprioritize this work? If yes, which projects?
      • What budget or procurement risks could cause the pilot to be paused, and how have you mitigated similar risks before?
      • If issues appear during the pilot, what escalation path would keep the work alive (who do we call and what authority do they have)?

      Fast Wins or Long Wars—Which Path Do You Prefer?

      • If nothing changes in six months, which metric or process will be noticeably worse—and why should we act now?
      • Which quick win would deliver visible, business-facing value in weeks rather than months (pick one)? Options: De-duping billing lists to fix revenue reporting, Matching CRM and billing records for single-customer view, Cleaning top revenue-generating customer records, Synchronizing golden records to one target system, Other — specify
      • Are you open to a phased delivery that starts with one entity domain and expands only after business trust is established? Options: Yes — prefer phased approach, Maybe — depends on scope, No — prefer broader scope, Unsure
      • How would you like progress and confidence reported during the pilot (select all that would be useful)? Options: Interactive dashboard, Weekly executive summary, Working sessions with analysts, Automated quality metrics, Milestone sign-offs, Ad-hoc workshops
      • What timeline feels realistic to produce trusted golden records for a pilot pair (from sample receipt to validated results)? Options: <2 weeks, 2–4 weeks, 4–8 weeks, 2–3 months, >3 months
      • What is the next concrete decision or meeting we should schedule to move this pilot forward, and who needs to attend?
  2. Customer Discovery

    Clarify target outcomes, acceptance thresholds (e.g., golden record accuracy), pilot constraints, and success signals for phased delivery.

    Discovery Questions

    Quick Start: Tell Us What Brought You Here

    • In one sentence, what triggered this MDM evaluation right now?
    • Who are the core people on your side we should involve in the pilot (titles, teams)? Options: VP Data Management, Chief Data Officer, Head of CRM, Head of Finance/FP&A, Legal/Compliance, IT/Engineering, Business Unit Leader, Other
    • How urgent is a working golden record for the business—what timeline does leadership expect? Options: Immediately (weeks), Short-term (1–3 months), Quarterly (3–6 months), Longer term (6+ months)
    • What single business question do you hope a golden record will finally answer for you?
    • Can you point to a recent example (report, regulatory ask, merger pain) that made this problem impossible to ignore?

    What if a 'Single Customer View' Wasn’t Optional?

    • If an executive demanded a single view of customer exposure tomorrow, how confident would you be in delivering it? Options: Completely confident, Partially confident, Not confident, Unsure
    • Which systems contain the majority of your customer records today, and which two should we prioritize for a pilot? Options: CRM A, CRM B, Billing/ERP, Marketing platform, Data warehouse, Custom apps, Other
    • How many distinct customer identifiers do you estimate exist across your landscape (ballpark)? Options: <10, 10–50, 51–200, 201–1,000, 1,000+
    • What happens in the business when duplicate or fragmented customer records are used—give a concrete consequence (e.g., missed revenue, overstated sales, compliance gap).
    • When you’ve tried to reconcile customers before, what approach did you take and why didn’t it stick? Options: Spreadsheets/manual dedupe, Homegrown rules in CRM, Point-to-point integrations, Legacy MDM attempt, Other

    When the Numbers Don’t Match the Story

    • Have you experienced a concrete financial or regulatory impact tied to inconsistent master data? If so, what was it and how long has it affected you? Options: Yes—financial impact, Yes—regulatory/compliance impact, Yes—operational/analytical impact, No clear impact yet
    • How often do your revenue/segment reports require manual reconciliation before they’re shareable? Options: Every report, Most reports, Occasionally, Rarely, Never
    • Tell us about a recent audit, filing, or board discussion where master data quality was called into question—what was at stake?
    • Which downstream teams (finance, sales ops, risk, marketing) currently refuse to trust system-provided customer lists without manual checks? Options: Finance, Sales Operations, Risk/Compliance, Marketing, Customer Success, Other
    • How does this mistrust manifest in day-to-day work—extra meetings, manual spreadsheets, missed deadlines? Give one vivid example.

    Who's Holding the Keys — and Who's Blocking the Door?

    • If a centralized golden record started changing data in systems, which team would most likely push back—and why? Options: CRM owners, ERP/Finance owners, Marketing ops, IT/Integration team, Legal/Privacy, Other
    • How are ownership and stewardship of customer data formally assigned today (roles, RACI, or none)? Options: Clearly assigned (RACI), Informal owners, No clear ownership, Distributed/controversial
    • Describe a time when a system owner resisted a change that later proved necessary—what made the resistance effective?
    • What political or commercial incentives keep teams from letting go of duplicate records in their systems? Options: Revenue attribution concerns, Territory/ownership, Fear of losing control, Integration dependency, No incentives to change, Other
    • Who would be the executive sponsor that can resolve cross-team disagreements during the pilot?
    • How quickly does that sponsor act when risks surface—days, weeks, or months? Options: Days, Weeks, Months, Depends on issue

    What Would Trust in a Golden Record Actually Feel Like?

    • If analysts stopped manually verifying records, what specific behaviors or outcomes would you expect to change?
    • Which accuracy or confidence signals do your teams need to stop manual checks (examples: field-level match rates, link audits, manual review percentage)? Options: Field-level accuracy metrics, Sample audited matches, Automated confidence score thresholds, Reduced manual review %, Business approvals
    • How would you prioritize the attributes that must be correct in a golden record (name, address, tax ID, account owner, revenue attribution)? Options: Name, Address, Tax ID/Legal ID, Primary contact, Account ownership/segmentation, Revenue linked fields
    • What tolerance do your business users have for occasional merge errors during a pilot—are they comfortable with a review queue or is zero-error demanded? Options: Comfortable with review queue, Need <1% error, Require near-zero errors, Unsure
    • How would downstream systems prefer to receive golden records—push updates, pull APIs, or batched exports? Options: Push (real-time), Pull API, Scheduled batch export, Manual export/import, Hybrid

    Let’s Talk Acceptance: The Numbers That Make or Break This Pilot

    • What single quantitative threshold would make the pilot a clear success to you (e.g., duplicate reduction %, precision/recall, manual review rate)? Options: >90% precision, >95% precision, >90% recall, >80% duplicate reduction, <5% manual review
    • Which metric(s) do you want us to report weekly during the pilot? Options: Match precision, Match recall, Number of merges, Manual review queue size, Time to reconcile, Downstream sync success
    • Would you accept a phased acceptance where initial accuracy thresholds are lower but improve over phases? Options: Yes—phased acceptance, No—single pass acceptance, Maybe—need constraints
    • Who on your team will sign off on pilot acceptance, and do they require a written criteria checklist?
    • If acceptance is delayed due to unexpected data quality issues, what remediation window would you consider reasonable? Options: 1–2 weeks, 3–4 weeks, 1–2 months, Longer
    • Are there regulatory or audit artifacts we must produce to demonstrate acceptance (audit logs, reconciliation reports, approver signatures)? Options: Audit logs, Reconciliation reports, Approver signatures, None required, Other

    Pilot Reality Check — Constraints We Must Respect

    • If we said the pilot requires a 100k-row sample from two systems, can you provide that within your current data access and security rules? Options: Yes—ready, Yes—with support, No—not yet, Unsure
    • Which of these constraints are non-negotiable for the pilot (pick all that apply)? Options: Data cannot leave environment, Masked PII only, No production writes, Limited API access, Only anonymized samples, Other
    • How long does it typically take your teams to provision extract access for a vendor or partner? Options: <1 week, 1–2 weeks, 2–4 weeks, 4+ weeks
    • Do you have preferred sample selection criteria (random, high-value customers, recently active, by region)? Options: Random sample, High-revenue accounts, Most active, Recently created records, By region/segment, Other
    • Are there legal/data residency/privacy rules we must follow during the pilot (e.g., EU data, masked SSNs)? Options: GDPR/EEA, Local privacy rules, Internal policy only, No special rules, Other
    • Who on your security/compliance team will need to review our data handling plan?

    How We'll Measure Success and Decide to Scale

    • If the pilot achieves the agreed accuracy and reduces manual effort, will you commit to a phased rollout or require an additional business case? Options: Commit to phased rollout, Require additional business case, Depends on ROI, Unsure
    • What downstream owners must be convinced before you expand beyond the pilot (list teams and one main question each would ask)?
    • How do you prefer progress and risk to be communicated during the pilot (weekly email, dashboard access, executive checkpoint calls)? Options: Weekly email, Dashboard access, Bi-weekly calls, Ad-hoc updates, Other
    • What short-term wins would make the organization believe this is worth scaling (e.g., reconciled $X revenue, eliminated Y% duplicates, audit cleared)?
    • If we hit the pilot targets, what budget or authority is likely to be available to expand next quarter? Options: Dedicated expansion budget, Reallocated funds per ROI, Requires new approval, Unknown
  3. Solution Experience

    Run the match-and-merge on customer samples and walk through results in the customer’s context to validate trust in golden records.

    Experience Meetings

    • Solution Experience — Pre-Run Alignment
    • Match-and-Merge Execution — Live Run
    • Results Walkthrough — Business Context Validation
    • Technical Deep-Dive — Edge Cases & Data Quality Remediation
    • Introductions & Objectives
    • Create a prioritized list of rule adjustments and data fixes based on spotted anomalies.
    • Schedule the re-run window (if needed) and assign run owner.
    • Tag records requiring manual review and assign reviewers.
    • One-sentence Recap (State, Consequence, Future)
    • Business stakeholders explicitly validate that golden records resolve the stated consequence in representative scenarios.
    • A clearly prioritized list of exceptions with owners and remediation paths.
    • Formal acceptance decision for the sample run (proceed, iterate, or reject) documented.
    • Document business approvals and exception rationale for the run artifact.
    • Assign owners for manual reconciliation of flagged records.
    • If required, update acceptance criteria or matching rules and schedule re-run.
    • Produce a short impact note mapping how validated records change downstream reports or controls.
    • Top Anomalies Recap
    • A clear root-cause mapping from anomaly to corrective action for the top issues.
    • A committed remediation plan with owners, timeline, and criteria for a successful re-run.
    • Confidence that data quality and matching rule changes will materially improve accuracy to meet acceptance.
    • Implement agreed transformation or cleansing rules in source or staging pipelines.
    • Apply rule adjustments in the matching engine and prepare a re-run dataset.
    • Schedule and execute the targeted re-run, then deliver updated metrics and artifacts.
    • Update documentation for any new business rules discovered during analysis.
    • A single, agreed one-sentence current state that drives the experience.
    • A quantified statement of consequence that creates urgency for accurate golden records.
    • A one-sentence future-state outcome the run must prove.
    • Signed agreement on sample, metrics, and data access required to execute the live run.
    • Deliver sample extract(s) to the platform in the agreed schema and location.
    • Provide read/write credentials and any mapping documentation for source systems.
    • Stakeholder sign-off on acceptance criteria and run schedule.
    • List of known edge cases or business rules to highlight during the run.
    • Recap Objectives & Acceptance Criteria
    • Complete an auditable match-and-merge run on the agreed sample.
    • Produce initial metrics (match rate, merge rate, precision/recall proxies) for review.
    • Identify and prioritize anomalies needing rule changes or data remediation.
    • Provide the run output artifact and system logs to stakeholders.
    • Top-level Metrics & Acceptance Status
    • Crystal-clear Current State
    • Run Kickoff & Environment Check
    • Root Cause Analysis per Anomaly Type
    • Before/After Business Scenarios
    • Define Remediation Actions
    • Consequence Quantification
    • Live Monitoring of Pipeline & Key Metrics
    • Record Validation & Business Voting
    • Define Future State (success in operational terms)
    • Test & Re-run Plan
    • Spot-check Matches & Merge Decisions
    • Sample Selection & Acceptance Criteria
    • Capture Issues, False Positives/Negatives
    • Data Steward Sign-off & Handoff
    • Exception Triage & Acceptance Decisions
    • Data & Access Readiness Checklist
    • Run Summary & Next Steps
    • Run Plan, Roles & Risks
  4. Solution Scope

    Define the pilot boundary: entity domain, source systems, sample size, matching rules, governance roles, and acceptance criteria.

    Scope Configuration

    • Load and Normalize Source Records
    • Standardize Addresses and Contact Fields
    • Run Match-and-Merge Engine and Persist Golden Records
    • Deploy Human-in-the-Loop Merge Interface
    • Configure Survivorship and Attribute Resolution Rules
    • Apply Data Quality Rules and Automated Cleansing
    • Provide Audit Trail and Record Lineage
    • Publish Golden Records via REST APIs and Connectors
    • Activate Bidirectional Synchronization to Source Systems
    • Deploy Real-Time Change Data Capture (CDC)
    • Enforce Role-Based Access and Data Governance
    • Implement Single-Entity Phased MDM Deployment

    Scope Questions

    Load and Normalize Source Records

    • Which source systems should be included in the pilot? Options: CRM, ERP, Billing/Finance, Marketing/Engagement, Data Warehouse, Custom Database, Other
    • Approximately how many records per source will you load for the pilot? Options: Less than 10,000, 10,000-50,000, 50,000-100,000, 100,000-500,000, More than 500,000
    • Are extracts available as full dumps, incremental feeds, or both? Options: Full dump, Incremental (delta), Both, Unsure / need to confirm
    • What extract delivery mechanisms/formats can you provide? Options: CSV/Flat files, JSON, Database connection (JDBC/ODBC), API, Message queue, Other
    • Do records include system-level unique identifiers that can be mapped across sources? Options: Yes — consistent cross-system IDs, Partially — in some systems, No — identifiers differ per system, Unsure
    • Are there data residency, encryption, or compliance restrictions that affect extraction or normalization? Options: Yes — strict restrictions, Yes — moderate restrictions, No, Unsure
    • Describe any non-standard fields or special normalization rules we must apply during load (e.g., custom codes, legacy formats).

    Standardize Addresses and Contact Fields

    • Which address standards do you require (e.g., USPS, international, country-specific)? Options: US/USPS, International (mixed countries), EU standards, Country-specific (will specify), No standard required
    • Do you require third-party address validation / geocoding during standardization? Options: Yes — geocoding & validation, Yes — validation only, No, Unsure
    • Which contact fields need canonical formats (e.g., phone, email, name parsing)? Options: Phone normalization, Email normalization/verification, Personal name parsing, Job title normalization, Other
    • Are there country-specific formatting rules or multiple locales to support? Options: Single country, Multiple countries — similar formats, Multiple countries — diverse formats, Unsure
    • Do you want automatic correction of likely address errors (e.g., misspellings) or only flagging for review? Options: Auto-correct where high confidence, Flag for manual review only, Combination by confidence threshold, Unsure
    • Are there business rules for preferred contact channels (e.g., prioritize mobile over landline)? Options: Yes — have defined rules, No — choose defaults, Need help defining rules
    • List any special contact fields or attributes that require bespoke normalization (e.g., multiple address types, contact role).

    Run Match-and-Merge Engine and Persist Golden Records

    • Which entity types will the matching target in the pilot (select primary)? Options: Customer/Party, Account, Product, Supplier/Vendor, Other
    • What matching approach do you prefer for the pilot? Options: Deterministic (rule-based), Probabilistic / scoring, Hybrid (rules + scoring), Unsure — need recommendation
    • What matching confidence thresholds should be used to auto-merge vs. send for review? Options: High auto-merge / medium review / low block, Only exact matches auto-merge, All matches require review, Unsure — want recommended defaults
    • Where should golden records be persisted for the pilot? Options: MDM hub database, Customer's data lake/warehouse, Both (hub + copy), Other
    • Do golden records require canonical identifiers (new IDs) or should existing source IDs be linked as references? Options: Create new canonical IDs, Keep source IDs and link, Hybrid — canonical plus source references, Unsure
    • What fields/attributes are critical in the golden record and must be preserved/validated?
    • Are there expected merge rates or business rules that would materially affect auto-merging (e.g., never merge across legal entities)? Options: Yes — specific rules, No special rules, Unsure — need help identifying

    Deploy Human-in-the-Loop Merge Interface

    • Who are the intended reviewers for manual merges (roles/titles)? Options: Data stewards, Business analysts, System owners, Third-party vendor, Other
    • What is the expected manual review volume (percent of matched pairs) during the pilot? Options: <1%, 1-5%, 5-15%, 15-30%, 30%+
    • Which UX capabilities are required for reviewers? Options: Side-by-side comparison, Bulk merge/unmerge, Custom attribute weighting, Commenting / escalation, Audit view
    • Do reviewers require role-specific permissions or limited field edit rights in the interface? Options: Yes — restricted edits, No — full edit access, Mixed by role
    • What SLA do you expect for reviewer actions (e.g., approve/reject within X days)? Options: Same day, 1-3 business days, 3-7 business days, No SLA
    • Do you require integration of the review interface with existing ticketing or workflow tools? Options: Yes — integrate with ticketing, No — standalone interface, Unsure
    • Describe any approval or escalation workflows that must be enforced during manual review.

    Configure Survivorship and Attribute Resolution Rules

    • Which source should be authoritative for each critical attribute (e.g., address from System A, email from System B)? Options: Prefer specific systems (will specify), Most-recent update wins, Highest-quality source wins, Custom rule per attribute
    • Do you require attribute-level survivorship strategies (e.g., longest, most recent, highest confidence)? Options: Yes — by attribute, No — global rule, Unsure — need recommendation
    • Are there attributes that must never be overwritten without manual approval? Options: Yes — specify attributes, No
    • Do you need conditional rules (e.g., prefer system X for region Y)? Options: Yes, No, Unsure
    • Should historical values and change history be retained for resolved attributes? Options: Yes — keep full history, Keep limited history, No
    • Will business users need a UI to edit survivorship rules during/after the pilot? Options: Yes — business-facing UI, No — only admin configuration, Unsure
    • Provide examples of attribute conflicts you've observed that must be handled by survivorship rules.

    Apply Data Quality Rules and Automated Cleansing

    • What are the top data quality issues to address in the pilot (select all that apply)? Options: Duplicates, Missing critical attributes, Invalid emails/phones, Incorrect addresses, Incorrect legal entity mapping, Other
    • What acceptance thresholds do you require for data quality (e.g., % valid emails, % complete records)? Options: Strict (95%+), Moderate (85-95%), Baseline (70-85%), No set threshold
    • Do you want automated cleansing (auto-correct) or flagging only? Options: Auto-correct high-confidence issues, Flag for review only, Combination by rule
    • Are there domain-specific validation rules we should apply (e.g., tax IDs, contract numbers)? Options: Yes — will provide rules, No, Unsure
    • How should poor-quality source records be handled (quarantine, drop, route for remediation)? Options: Quarantine with remediation workflow, Drop from golden record, Include with flag, Other
    • Do you have existing data quality scorecards or KPIs to align against? Options: Yes — will share, No — need templates
    • Describe any regulatory or reporting validations that cleansing must satisfy.

    Provide Audit Trail and Record Lineage

    • What retention period is required for audit logs and lineage metadata? Options: 90 days, 1 year, 3 years, 7+ years, Custom
    • Which events must be captured in the audit trail (e.g., merges, attribute changes, user approvals)? Options: Merges/unmerges, Attribute updates, User reviews/approvals, Sync events to sources, All of the above
    • Do you require immutable audit records for compliance (tamper-evident storage)? Options: Yes, No, Unsure
    • What level of lineage detail do you need (field-level provenance, source system and record IDs, timestamped events)? Options: Field-level provenance, Record-level source mapping, Basic source attribution only, Other
    • Should audit and lineage data be available via APIs or exportable reports? Options: APIs, Scheduled reports/exports, Both, No requirement
    • Are there internal stakeholders or external auditors who will require access to audit/lineage data? Options: Yes — internal only, Yes — external auditors included, No
    • Describe any legal/regulatory constraints influencing audit retention or access.

    Publish Golden Records via REST APIs and Connectors

    • Which target systems need access to golden records during the pilot? Options: CRM, ERP, Billing/Finance, Analytics/Warehouse, Custom application, Other
    • Do you need real-time API access or scheduled batch exports to targets? Options: Real-time APIs, Scheduled batch exports, Both, Unsure
    • Which authentication and security models are required for APIs/connectors? Options: OAuth2, API key, Mutual TLS, SAML/SSO, Other
    • Are there field-level publish rules (e.g., mask SSN, omit internal fields) when exposing golden records? Options: Yes — specify fields, No — publish full record, Unsure
    • Do consuming systems require a specific schema or a configurable mapping layer? Options: Standardized schema required, Configurable mapping per target, Both options supported
    • What throughput and latency expectations exist for API calls to the golden record service? Options: Low latency real-time, Near real-time (seconds-minutes), Batch (hourly/daily), Unsure
    • List any pre-built connectors required (e.g., Salesforce, SAP, Snowflake) or note custom connector needs.

    Activate Bidirectional Synchronization to Source Systems

    • Which source systems must accept updates from the MDM hub (select all that apply)? Options: CRM, ERP, Billing/Finance, Marketing systems, Custom applications, None — one-way only
    • Do source systems permit external updates or are some read-only? Options: All allow updates, Some allow updates, some read-only, All read-only, Unsure
    • What conflict resolution strategy should govern hub-to-source updates (hub authoritative, source authoritative, timestamp-based, manual approval)? Options: Hub authoritative, Source authoritative, Timestamp/most recent wins, Manual/approval workflow, Hybrid
    • Are there transactional constraints (e.g., business hours, blackout windows) for writing back to source systems? Options: Yes — specify windows, No constraints, Unsure
  5. Mutual Commit

    Finalize commercial terms, phased milestones, data access commitments, and governance/escalation agreements for the pilot.

    Agreement Modules

    • Statement of Work (SOW)
    • Commercial Order Form & Pricing
    • Payment Schedule & Acceptance-Based Invoicing
    • Data Access & Security Agreement (DPA)
    • Pilot Milestones & Acceptance Criteria
    • Governance & Escalation Agreement
    • Roles & Responsibilities (RACI)
    • Source System Extract & Onboarding Plan
    • Change Control / Change Order Agreement
    • Support & Pilot SLA
    • Termination, Data Return & IP Rights
  6. Deployment

    Operationalize the pilot with readiness checks, sequencing, and acceptance validation.

    1. Pre-Deployment Readiness

      Confirm extract readiness, data quality fixes, access rights, and stakeholder sign-offs required to execute the pilot.

      Readiness Questions

      Quick Win Snapshot

      • In one sentence, what single outcome must this pilot prove for your organization to call it a success?
      • Which primary business metric will be used to judge pilot success? Options: Duplicate rate reduction, Revenue reconciliation improvement, Ability to produce single-customer regulatory report, Reduction in manual reconciliation effort, Time-to-identity (median), Other
      • Which sample size and system pair would you consider persuasive for a vote to scale? Options: 10,000 records from two systems, 50,000 records from two systems, 100,000 records from two systems, A specific cohort or geography (specify below), Other
      • Who must sign off on pilot success before funding or scaling is approved (list roles/titles)? Options: CDAO / Head of Data, VP Data Management, Head of Finance, Head of Risk & Compliance, Business Unit Lead, Other
      • Ideally, how soon would you like the pilot to start once data access is confirmed? Options: Immediately (within 2 weeks), 2–4 weeks, 1–2 months, 3+ months, Unsure

      If This Fails, Who Will Notice?

      • If the pilot doesn't deliver as expected, whose credibility or KPIs are most at risk—what makes that person vulnerable?
      • Which teams will feel operational pain first if we cannot produce a reliable golden record? Options: Finance/Revenue Reporting, Risk & Compliance, Sales / RevOps, Customer Support, M&A / Integration Team, Other
      • Do you have a formal escalation path or rapid decision forum that can resolve pilot blockers in days rather than weeks? Options: Executive steering committee, Program manager + SMEs, Ad-hoc escalation via sponsor, No formal escalation path
      • What political or ownership conflicts have blocked previous cross-system data efforts in your organization?
      • How would a failed pilot change sponsorship, budget, or the appetite for phased MDM approaches? Options: Pause further funding, Require larger proof before next phase, Shift to a different vendor/approach, No change, Unsure

      Where Are Your Best — and Worst — Records Hiding?

      • Which system(s) do you currently treat as the most 'trusted' source, and why might that trust be misplaced?
      • List the source systems we plan to include in this pilot (system name, primary owner, and contact) — start with top two.
      • Are sample extracts for those systems available now, or will extract work be required? Options: Ready and accessible, Extracts exist but need rework, No extracts yet—access pending, Extracts blocked by security/legal
      • What percentage of records in-scope contain the minimum fields we need (name, address, customer ID, contact methods)? Options: <50%, 50–75%, 75–90%, >90%, Unknown
      • Describe the three most common data quality problems you see (e.g., misspellings, merged accounts, placeholder IDs) and how long they've existed.
      • Are there regulatory cohorts or constrained data subsets we must include or explicitly exclude from pilot extracts? Options: Include specific regulated cohorts, Exclude regulated PII, No constraints, Unsure—need legal input

      Who Actually Needs Keys to the Castle?

      • Who claims they need full access today but would be satisfied with read-only, sampled, or tokenized views?
      • Which data extraction patterns are acceptable for the pilot? Options: Database replicas/DB dumps, SFTP CSV extracts, API connections (REST/GraphQL), ETL/ELT handoff (Informatica, Fivetran), Manual exports
      • What level of PII masking or tokenization is required before data can leave the source environment? Options: Full masking of PII, Partial masking (tokenize IDs), No masking—raw data allowed, Depends on dataset
      • Who approves credential or connection requests (system owner, IT Sec, data governance)—please list names/roles for each source system.
      • Are there network constraints (firewalls, VPN windows, maintenance windows) that limit our extract times? Options: Yes—strict maintenance windows, Yes—some restrictions, No constraints, Unknown—need IT confirmation
      • Which communication channel do you prefer for extract requests and status tracking? Options: Shared tracking board (Jira/Confluence), Weekly status email, Daily standups, Ad-hoc via Slack/Teams

      What Would Block Even a Perfect Extract?

      • What tiny, technical detail keeps you awake at night because it could derail the first extract?
      • Have you provided a data dictionary or schema for the systems in scope? Options: Complete and up-to-date, Partial or outdated, No, Work in progress
      • Are there known schema mismatches (field types, encodings, multi-value fields) we should plan to reconcile? Options: Many mismatches, A few known mismatches, No significant mismatches, Unknown
      • Do any source systems impose API rate limits, export quotas, or performance limits that could throttle our extract? Options: Yes—strict limits, Yes—manageable limits, No limits, Unknown—need confirmation
      • Which approach do you prefer for field mapping and transformation during the pilot? Options: You provide mappings, Vendor proposes mappings and we review, Collaborative mapping workshops, Use default mappings and adjust
      • If our match-and-merge needs a derived field (e.g., normalized address score), who approves creating that field upstream?

      When Will We Fix the Mess You Already Know About?

      • Are you willing to accept imperfect source data for faster time-to-value, or do remediation tasks need to be completed first? Options: Accept imperfect and iterate, Fix critical issues before start, Require near-perfect before pilot, Unsure—need discussion
      • List the top three data quality issues you want addressed during the pilot and name the owning team for each (owner + rough ETA).
      • Which remediation levers are you willing to include in pilot scope? Options: Automated standardization (addresses/names), Rule-based deduplication, Manual review queues, Third-party enrichment (phone/address), None—pilot must avoid remediation
      • Do you have data stewards or SMEs available to support manual review and triage, and if so, how many hours/week can they commit? Options: >20 hours/week, 8–20 hours/week, 4–8 hours/week, <4 hours/week, None available
      • If we surface systemic upstream issues that require schema or process changes, what is your preferred remediation cadence? Options: Immediate exec notification + stop/hold, Weekly remediation meeting, Triage via ticketing and SLA, Ad-hoc based on severity
      • Which data fixes are absolute 'musts' versus 'nice-to-haves' for the pilot to deliver credible results?

      How Will We Know the Golden Record Is Trustworthy?

      • What would make business users refuse to adopt the golden record even if our algorithms show high accuracy?
      • Define the minimum acceptance thresholds you expect for match/merge quality (choose closest). Options: Precision >= 95%, Precision >= 90%, Precision >= 85%, No firm numeric threshold—need business validation
      • Which validation methods should we use during the pilot to build trust? Options: Business user manual review, Statistical sampling and reports, Automated scoring with thresholds, Reconciliation vs financial/regulatory reports, Other
      • Who will act as the business validators and how will their feedback be captured and prioritized?
      • How many manual reviews or what percentage of matched records will make you comfortable signing off (specify absolute or percent)? Options: 100 records, 500 records, 1,000 records, Specify a percentage in the next field, Other
      • Which downstream targets must receive synchronized golden records during the pilot and how will we confirm successful ingestion?

      Final Approvals, Timelines & What 'Go' Looks Like

      • If someone is poised to veto the pilot at the last minute, what evidence or artifact would convince them to change their mind?
      • Which artifacts are required for pilot kick-off and sign-off? Options: Signed scope document, Data access approvals, Security assessment/SAQ, Commercial agreement, Governance & escalation plan, Other
      • Who holds final go/no-go authority and how do they prefer to sign off (email, ticket, steering committee)? Options: CDAO / Exec Sponsor, VP Data Management, Program Sponsor via email, Steering committee decision, Other
      • Which pilot timeline do you prefer for extract → run → validation → signoff? Options: 2–3 weeks (rapid), 4–6 weeks (standard), 8–12 weeks (thorough), Custom timeline—specify below
      • Is there contingency budget or backup resources available if the pilot requires additional engineering/time? Options: Allocated contingency budget, No contingency—must stay on plan, Can request additional funding, Unsure
      • What are the non-negotiable 'must-haves' we should list in the pilot charter to prevent scope creep and political pushback?
    2. Pilot Deployment

      Execute sample load and match-and-merge, synchronize golden records to the target system, and track tasks and owners.

    3. Validation & Acceptance

      Measure results against acceptance criteria, document discrepancies, and agree go/no-go for scale based on business trust signals.

      Validation Questions

      Quick hello: What brought you into this conversation today?

      • In one sentence, what is the immediate trigger (e.g., post-merger duplicates, audit/regulatory request, revenue discrepancy)? Options: Post-merger integration, Regulatory request, Revenue/reporting discrepancy, Operational pain (support/ops), Other
      • Which entity domain is highest priority right now? Options: Customer/Account, Product/Catalog, Supplier/Vendor, Financial/GL Accounts, Other
      • Which source systems contain the overlapping records we should evaluate? Options: CRM (Salesforce), CRM (Dynamics), ERP (SAP/Oracle), Billing/Revenue system, Marketing database, Data warehouse / lake, Custom application, Other
      • Approximately how many records exist across the combined systems for this domain? Options: <10k, 10k–100k, 100k–1M, 1M–10M, >10M, Unsure / need to estimate
      • Who on your team will most care about the outcome of the pilot (title or role)?
      • How soon do you need a demonstrable result that the business can trust? Options: Within days, 1–2 weeks, 3–4 weeks, 1–3 months, Unsure

      Are you comfortable running blind?

      • How often have duplicate or inconsistent master records led to decisions you later had to reverse or apologize for? Options: Almost always, Often, Sometimes, Rarely, Never
      • Tell us about a recent decision or report that felt risky because the underlying master data was untrusted—what happened and who noticed?
      • When incorrect master data impacts a decision, which teams feel the pain most acutely? Options: Finance / Revenue Ops, Sales / Account Management, Compliance / Legal, Customer Support, Supply Chain / Ops, Executive leadership, Other
      • How does unresolved master data uncertainty usually show up in day-to-day work (manual reconciliations, duplicate invoices, inaccurate targets, etc.)?
      • If we fixed the single biggest source of confusion in your master data, what immediate change would you expect to see in the next quarter?
      • Which of these feelings best describes how your team approaches master data today? Options: Resigned and workaround-driven, Cautious and experimental, Eager but under-resourced, Optimistic — ready to commit, Skeptical — seen failures before

      Where the numbers break your heart

      • Has a report, financial statement, regulatory filing, or customer interaction been materially wrong because of master data? What was the outcome? Options: Yes — financial impact, Yes — regulatory/penalty, Yes — customer impact, Yes — internal operational failure, No clear incident, Prefer not to say
      • If there was a financial or regulatory impact, can you estimate the scale (order of magnitude) or describe the downstream consequence?
      • Which KPIs or reports do you distrust today because of master data issues? Options: Revenue by customer, Customer lifetime value, Risk exposure / credit limits, Product sales mix, Supply chain inventory, Other
      • How often do you have to run manual reconciliations or supplemental checks to validate a single report? Options: Every report, Often, Sometimes, Rarely, Never
      • When those reconciliations occur, who is accountable for the manual work and how long does it typically take?
      • If we could remove that manual reconciliation workload, what would your team do with the freed time? Options: Strategic analysis, Faster closes/reporting, Customer outreach, Process improvements, Other

      Who's actually calling the shots?

      • Who will sign off on pilot acceptance and who holds veto power for scaling MDM? Options: VP Data / CDO, CIO, Finance Controller, Head of Sales Ops, Legal/Compliance, Business Unit Leader, Other
      • Describe any political or organizational tensions that could block a neutral master record hub (system owners, domain stewards, regional leads)?
      • Have there been previous MDM or data governance initiatives here that failed or stalled? What was the main reason? Options: Scope creep / too big, Lack of executive sponsorship, Insufficient resources, Resistance from system owners, Technology mismatch, Other
      • What does the ideal sponsor look like for this pilot — title, appetite for change, and level of involvement?
      • Which stakeholders must be kept informed throughout the pilot (and how often)? Options: Weekly email/status, Bi-weekly review, Monthly steering committee, Ad-hoc updates, Only at milestones
      • If someone resists centralizing a golden record, what would convince them to try a phased approach instead of saying no?

      If we could snap our fingers and produce one trusted golden record, what would change?

      • What acceptance threshold would make your analysts stop manual verification — e.g., a percentage accuracy, types of automated checks, or user confidence signals? Options: >=99% accuracy, >=97% accuracy, >=95% accuracy, Business sign-off required, Automated reconciliation passes, Other
      • Which data elements absolutely must be correct in a golden record for you to feel confident (e.g., legal name, tax ID, billing address, consolidated revenue)?
      • How should we show provenance and explainability so your team can trust every automated merge? Options: Record-level audit trail, Merge rationale / match score, Side-by-side sample comparisons, Ability to easily revert merges, Automated reconciliation reports, Other
      • What business tests should we run against golden records during the pilot to demonstrate trust (e.g., revenue reconciliation, AR cleanup, duplicate reduction)?
      • Which user workflows would need to change when golden records are synchronized to downstream systems? Options: Data steward reviews, Automated syncs to apps, Exception handling by business users, New governance approvals, No workflow changes
      • Beyond accuracy, what emotional proof point will convince stakeholders—reduced firefighting, fewer audit findings, faster closes, or something else? Options: Reduced firefighting, Fewer audit findings, Faster month-end close, Less finger-pointing, Improved customer experience, Other

      What would a safe, non-boil-the-ocean pilot actually look like?

      • If we had to prove value in a single phase, which scope would you prefer we lock to start? Options: Single entity type (e.g., Customer), Single system pair (CRM→ERP), Top revenue accounts only, High-risk regulatory segment, Other
      • Which sample selection approach do you trust for evaluating match-and-merge quality? Options: Random sample, Top revenue customers, High-risk / flagged records, Representative by region or BU, Other
      • What sample size do you consider sufficient for an initial demo that the business can rely on? Options: 5k–10k, 10k–50k, 50k–100k, 100k–500k, 100k specifically (industry benchmark)
      • Which matching rules or tolerances are non-negotiable (e.g., exact tax ID match, fuzzy name tolerance level)?
      • Who will be the day-to-day point person on your side for pilot execution (data engineer, steward, project manager)? Options: Data engineer, Data steward, Project manager, Business analyst, Other
      • What is the minimal success criteria for this pilot that would make you greenlight phased scale? Options: Accuracy threshold met, Business sign-off on reconciliations, Operational syncs validated, No critical issues in audit, Other

      Data's dirty little secrets — what are we going to discover?

      • What's the worst-case data issue we might uncover in the sample that would surprise your team? Options: Missing critical IDs, Systemically incorrect addresses, Multiple IDs for same customer, Conflicting legal entities, Legacy merges gone wrong, Other
      • Which of these data quality problems are present today? Select all that apply. Options: Missing/blank fields, Inconsistent formatting, Stale/outdated records, Duplicate records across systems, Conflicting attribute values, Incorrect IDs (SSN/Tax ID), Other
      • Do you have representative sample extracts ready or will extracts require engineering effort and approvals? Options: Extracts ready, Extracts need engineering work, Requires legal/security approval, Unsure
      • If extracts require approval, what security or compliance constraints must we observe (data masking, on-prem processing, VPN, anonymization)? Options: Anonymize PII, Masked fields, On-prem deployment only, Encrypted transfer (SFTP/VPN), SOC2 or ISO-only vendors, Other
      • Who owns data quality remediation in your org and how much runway do they have to do pre-pilot fixes? Options: Data quality team, System owners, Business units, Shared responsibility, No dedicated owner
      • What do you fear most we’ll find in the sample, from a people or politics perspective (blame, budget fights, exposure)?

      Red lines, escalations, and success signals — how will we know it's safe to scale?

      • What explicit go/no‑go criteria would force you to pause scaling after the pilot? Options: Accuracy below threshold, Critical data lineage gaps, Unresolved compliance issues, Business user rejection, Integration failures, Other
      • Who must sign the go/no-go and what level of evidence do they require (demo, reconciliation report, executive summary)? Options: VP Data / CDO, CIO, Finance Controller, Business Unit Leader, Legal/Compliance, Other
      • What monitoring or post-pilot dashboards would give you comfort after go-live (duplicate counts over time, sync success rate, exception queue length)? Options: Duplicate rate trend, Sync success/failed counts, Exception backlog size, Audit trail of merges, Business reconciliation KPIs, Other
      • If we hit an unexpected data issue during pilot execution, what escalation path should we use and who is the emergency contact? Options: Project manager escalation, Weekly steering committee, Direct exec escalation, Security/legal escalation, Other
      • What rollback or remediation controls must be in place before you will accept automated merges into any production system? Options: One-click revert, Staging sync only, Manual steward approval, Versioned golden record with audit, Other
      • What post-pilot governance cadence would you prefer for phased rollout decisions? Options: Weekly for first month, then monthly, Bi-weekly through 90 days, Monthly steering committee, Ad-hoc as issues arise

      Commitment and next steps — the minimum you need to feel safe to start

      • What is the smallest, non-negotiable commitment your organization must make to enable a truthful pilot (people, access, budget)?
      • Which of these resources can you commit immediately to the pilot? Options: Data engineer (part-time), Data steward (part-time), Business SME (weekly reviews), Project manager, Security/legal reviewer
      • How long will it take to produce the sample extracts once approvals are in place? Options: <3 business days, 3–7 business days, 1–2 weeks, 2–4 weeks, Longer / unsure
      • Which timeline feels realistic for a sample run and initial results your business can review? Options: 3–7 days, 1–2 weeks, 3–4 weeks, 1–3 months
      • What are the primary blockers we should help you remove before kickoff (select all that apply)? Options: Legal/data access, System owner approval, Resource availability, Budget approval, Data quality cleanup, Other
      • What's the single next meeting or decision you want from us to make it easy to move forward?
      • Any final concerns or unspoken risks you'd like us to explicitly address before we schedule the pilot?
  7. Success

    Review pilot outcomes, capture lessons learned, and maintain a shared issues & enhancements backlog for scaling the MDM program.

    Success Reviews

    • Pilot Outcomes Review — Customer Readout
    • Lessons Learned Retrospective — Cross‑Functional
    • Issue & Enhancements Backlog Workshop
    • Governance & Handoff — Stewardship Council
    • Executive Success Review & Scale Decision

    Issues & Enhancements

    • Ensure readiness of operational runbooks and confirm stewardship onboarding plan.
    • Draft the Lessons Learned document and updated pilot playbook incorporating agreed changes.
    • Assign remediation and playbook update owners with due dates and verification checkpoints.
    • Publish retrospective findings to stakeholders and schedule a 30-day follow-up to verify adoption.
    • Backlog Inventory & Categorization
    • Produce a prioritized, size-estimated backlog with acceptance criteria for the top items.
    • Agree on which issues are critical for go-to-scale vs which can be scheduled later.
    • Identify owners and dependencies so implementation planning can begin immediately.
    • Populate prioritized backlog in the shared Jira/Backlog tool with descriptions, impact scores, and owners.
    • Define acceptance criteria and test cases for the top 5 backlog items.
    • Schedule implementation sprints for quick wins and align resourcing.
    • Governance Model Overview
    • Secure agreement and formal sign-off on governance model and steward roles for MDM operations.
    • Define monitoring metrics, SLAs, and escalation paths to ensure operational reliability.
    • Introductions & Objectives
    • Publish the governance charter and RACI to all stakeholders and store in the shared repository.
    • Create monitoring dashboards and configure alerts tied to agreed SLAs.
    • Schedule stewardship onboarding sessions and record training materials.
    • Executive Summary & One‑Page Outcome
    • Obtain an explicit executive decision to fund and authorize the phased scale plan or document required gating conditions.
    • Secure sponsor commitments for resource and change management support needed for successful scale.
    • Agree on executive-level reporting cadence and success metrics for the scale program.
    • Produce and circulate the executive decision memo including approved budget, timeline, and conditions.
    • Schedule program kickoff and align PMO, engineering, and steward leads for Phase 1.
    • Publish sponsor-approved communications to impacted stakeholder groups.
    • Confirm whether pilot met documented acceptance criteria and secure an explicit accept/reject decision.
    • Ensure business stakeholders understand business impact and residual risk in tangible terms (dollars, hours, compliance exposure).
    • Capture immediate remediation tasks with owners and timelines when acceptance is conditional.
    • Produce a one-page executive summary with measured metrics and a clear accept/reject recommendation.
    • Document all discrepancies and assign remediation owners with target due dates.
    • Schedule a follow-up validation check after remediations are applied.
    • Framing & Prework Review
    • Create a prioritized list of process and technical improvements that will reduce pilot friction going forward.
    • Produce concrete updates to the pilot playbook and pre-flight checklist.
    • Assign owners and success metrics for each improvement to ensure follow-through.
    • Pilot Scope & Method Recap
    • Impact & Effort Scoring
    • Timeline Walkthrough
    • Business Impact, Risk & Urgency
    • Roles, RACI & Accountabilities
    • Acceptance Criteria Results
    • Prioritization Exercise
    • What Worked — Evidence & Patterns
    • SLA, Monitoring & Data Quality Thresholds
    • Proposed Phased Scale Plan & Costs
    • Define Acceptance Criteria & Success Signals
    • Escalation Paths & Change Control
    • Decision Point & Conditions
    • What Didn't Work & Root Cause Analysis
    • Business Impact & Consequences
    • Improvement Opportunities & Playbook Updates
    • Roadmap Placement & Dependencies
    • Handoff Checklist & Operational Onboarding
    • Communications & Sponsor Commitments
    • Exceptions, Residual Issues & Root Causes
    • Decision: Acceptance & Next Steps
    • Action Ownership & Metrics
    • Sign-offs & Next Governance Cadence
    • Q&A and Customer Validation
First-Party AI

1-2 minutes please — Your AI agent is working

First-Party AI™ can make mistakes. Always check important information.