ODOT - Retainer (clone)
project
01f10b002bda2219
Normalized: odot retainer clone
hubspot
Entity Properties (gold project table)
project_id
01f10b002bda2219
name
ODOT - Retainer (clone)
client_id
—
canonical_metadata
—
created_at
2026-02-12 16:10:50.021967+00:00
updated_at
2026-02-12 16:10:50.021967+00:00
status
—
billable
—
recurring
—
squad
—
qa_partner
—
project_manager
—
lead_dev
—
description
—
state
—
team_name
—
closedate
2026-01-22 21:51:04.178000+00:00
dealstage
1268501096
contract_type
—
contract_hourly_rate
—
contract_estimated_hours
—
contract_total_fee
—
30%
Separation Confidence
How distinct this entity is from others. Higher means no close matches existed when it was created. Lower means a near-match was rejected just below the 80% threshold — worth reviewing.
Low — a near-match was rejected, review recommended
90%
Avg Match Confidence
The average confidence score across all active source mappings. Shows overall quality of linkage between source records and this canonical entity.
Good match quality
Source Mappings (2)
| Source | Source ID | Display Name | Confidence | Method | Status | Actions | |
|---|---|---|---|---|---|---|---|
| hubspot | 54347281932 | ODOT - Retainer (clone) | 1.00 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_hubspot_deals
id
54347281932
created_at
2026-01-22 21:51:12.800000+00:00
updated_at
2026-01-27 19:37:07.370000+00:00
archived
No
amount
504000
closedate
2026-01-22 21:51:04.178000+00:00
createdate
2026-01-22 21:51:12.800000+00:00
dealname
ODOT - Retainer (clone)
dealstage
1268501096
hs_lastmodifieddate
2026-01-27 19:37:07.370000+00:00
hs_object_id
54347281932
hubspot_owner_id
30735443
pipeline
default
associated_company_id
772872182
associated_companies_ids
772872182
associated_contact_id
185438381824
associated_contacts_ids
185438381824
|
|||||||
| hubspot | 51926104399 | ODOT - Retainer | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_hubspot_deals
id
51926104399
created_at
2025-12-16 16:24:00.457000+00:00
updated_at
2025-12-18 19:24:26.841000+00:00
archived
No
amount
899000
closedate
2025-12-31 16:23:14.211000+00:00
createdate
2025-12-16 16:24:00.457000+00:00
dealname
ODOT - Retainer
dealstage
990408365
hs_lastmodifieddate
2025-12-18 19:24:26.841000+00:00
hs_object_id
51926104399
hubspot_owner_id
30735443
pipeline
default
associated_company_id
772872182
associated_companies_ids
772872182
associated_contact_id
185438381824
associated_contacts_ids
185438381824
|
|||||||