Lead Data Warehouse worked example

Two labels for one service: agree on the record before mapping it

A fictional field-mapping walkthrough covering consistent values, unknown data and delivery exceptions in inbound call records.

← All resources

The situation

Fictional planning example. These are sample decisions, not customer results or a demonstration of a live configuration.

Two teams at a fictional business capture the same caller need using different labels. One uses “service type,” while the other uses “request category.” Operations needs a usable common record without losing what the caller actually said.

Sample intake record

Use the distinction between reported information and confirmed outcomes when reviewing your own process.

Illustrative intake details and boundaries
FieldSample entryHow to use it
Source fieldService type / request category.Compare definitions before assuming the labels mean the same thing.
Caller wordingCaller requests maintenance for existing equipment.Preserve useful original context alongside any agreed category.
Proposed categoryMaintenance request.An illustrative value to review, not an assumed production schema.
Missing detailEquipment identifier not supplied.Use the agreed unknown representation; do not invent an identifier.
Review ownerOperations field-definition owner.Approve mapping choices and handle ambiguous values.

Walk through the decisions

  1. Compare meaning before renaming. Write down what each source field represents, who uses it and whether it combines multiple concepts.
  2. Agree a common representation. Choose the destination field and allowed values with the owning team. Keep the sample category provisional until approved.
  3. Preserve uncertainty and provenance. Retain the caller’s relevant wording and mark the absent identifier as unknown. Do not make a record appear independently verified through normalization.
  4. Review delivery and exceptions. Confirm supported destination behavior, required fields and ownership for rejected or incomplete records before configuring a live handoff.

Example handoff note

Mapping proposal: compare service type and request category for a common request-category field. Sample caller wording retained. Maintenance category proposed for owner review. Equipment identifier unknown. Destination requirements and exception handling still need agreement.

When the routine path does not fit

Use this with your team

Who defines each field? Which values are permitted? How are unknowns represented? Who reviews mapping ambiguity or a record that does not reach its destination?

Replace the fictional choices with your approved process before configuring service. This page does not collect or send your answers.

Plan your version

Try the related planning tool →

Read the related guide →

Discuss your call flow →