TTI - Ecommerce Support (Retainer)
project
8ad81fd52ad65f42
Normalized: tti ecommerce support retainer
hubspot
moreland_dashboard
quickbooks_make
toggl
Entity Properties (gold project table)
project_id
8ad81fd52ad65f42
name
TTI - Ecommerce Support (Retainer)
client_id
—
canonical_metadata
—
created_at
2026-02-12 05:36:13.625127+00:00
updated_at
2026-02-12 05:36:13.625127+00:00
status
—
billable
—
recurring
—
squad
—
qa_partner
—
project_manager
—
lead_dev
—
description
—
state
—
team_name
—
closedate
2025-12-31 19:32:26.592000+00:00
dealstage
990408365
contract_type
—
contract_hourly_rate
—
contract_estimated_hours
—
contract_total_fee
—
44%
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.
Moderate — a somewhat similar entity exists
84%
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 (34)
| Source | Source ID | Display Name | Confidence | Method | Status | Actions | |
|---|---|---|---|---|---|---|---|
| hubspot | 52069896196 | TTI - Support Retainer | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_hubspot_deals
id
52069896196
created_at
2025-12-18 19:33:30.791000+00:00
updated_at
2025-12-22 14:50:22.827000+00:00
archived
No
amount
91000
closedate
2025-12-31 19:32:26.592000+00:00
createdate
2025-12-18 19:33:30.791000+00:00
dealname
TTI - Support Retainer
dealstage
990408365
hs_lastmodifieddate
2025-12-22 14:50:22.827000+00:00
hs_object_id
52069896196
hubspot_owner_id
26186329
pipeline
default
associated_company_id
4135034425
associated_companies_ids
4135034425
associated_contact_id
553851
associated_contacts_ids
553851
|
|||||||
| moreland_dashboard | 5EEwlCBH55UEFw | TTI - Ecommerce Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | bKZ6NzOjTi32og | TTI - Ecommerce Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | 5mtOguOoGJUiAg | TTI - Ecommerce Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | GlhZRybCtSRjSA | TTI - Ecommerce Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | joCeJHyy4jD2kQ | TTI - Ecommerce Support (Retainer) | 1.00 | exact | Active |
|
|
|
Source Record
bronze_moreland_dashboard_md_timetoqb
toggl
TTI - Ecommerce Support (Retainer)
quickbooks
TTI Floor Care
sg_a_spread
False
project_type
Support
billing_type
Retainer
squad
Slate
qa_partner
Jeff
project_manager
Steve
lead_dev
Jeremy
|
|||||||
| moreland_dashboard | A4Pw4GXULxjncw | TTI - Ecommerce Support (Retainer) | 1.00 | exact | Active |
|
|
| quickbooks_make | 22384 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
22384
balance
0
due_date
2025-07-31 04:00:00+00:00
txn_date
2025-06-01 04:00:00+00:00
total_amt
7200
doc_number
22599
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 20712 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
20712
balance
0
due_date
2025-01-30 05:00:00+00:00
txn_date
2024-12-01 05:00:00+00:00
total_amt
7200
doc_number
22445
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 22644 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
22644
balance
0
due_date
2025-08-30 04:00:00+00:00
txn_date
2025-07-01 04:00:00+00:00
total_amt
7200
doc_number
22637
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 20437 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
20437
balance
0
due_date
2024-12-31 05:00:00+00:00
txn_date
2024-11-01 04:00:00+00:00
total_amt
7200
doc_number
22422
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 18083 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
18083
balance
0
due_date
2024-04-01 04:00:00+00:00
txn_date
2024-02-01 05:00:00+00:00
total_amt
7200
doc_number
22183
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 21827 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
21827
balance
0
due_date
2025-05-31 04:00:00+00:00
txn_date
2025-04-01 04:00:00+00:00
total_amt
7200
doc_number
22537
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 25263 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
25263
balance
7200
due_date
2026-03-02 05:00:00+00:00
txn_date
2026-01-01 05:00:00+00:00
total_amt
7200
doc_number
22850
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 23300 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
23300
balance
0
due_date
2025-10-31 04:00:00+00:00
txn_date
2025-09-01 04:00:00+00:00
total_amt
7200
doc_number
22686
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 25465 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
25465
balance
7200
due_date
2026-04-02 04:00:00+00:00
txn_date
2026-02-01 05:00:00+00:00
total_amt
7200
doc_number
22875
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 23605 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
23605
balance
0
due_date
2025-11-30 05:00:00+00:00
txn_date
2025-10-01 04:00:00+00:00
total_amt
7200
doc_number
22730
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 18542 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
18542
balance
0
due_date
2024-05-31 04:00:00+00:00
txn_date
2024-04-01 04:00:00+00:00
total_amt
7200
doc_number
22238
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 20120 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
20120
balance
0
due_date
2024-11-30 05:00:00+00:00
txn_date
2024-10-01 04:00:00+00:00
total_amt
7200
doc_number
22393
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 22979 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
22979
balance
0
due_date
2025-09-30 04:00:00+00:00
txn_date
2025-08-01 04:00:00+00:00
total_amt
7200
doc_number
22665
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 19569 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
19569
balance
0
due_date
2024-09-30 04:00:00+00:00
txn_date
2024-08-01 04:00:00+00:00
total_amt
7200
doc_number
22326
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 19156 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
19156
balance
0
due_date
2024-07-31 04:00:00+00:00
txn_date
2024-06-01 04:00:00+00:00
total_amt
7200
doc_number
22292
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 23819 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
23819
balance
0
due_date
2025-12-31 05:00:00+00:00
txn_date
2025-11-01 04:00:00+00:00
total_amt
7200
doc_number
22755
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 20994 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
20994
balance
0
due_date
2025-03-02 05:00:00+00:00
txn_date
2025-01-01 05:00:00+00:00
total_amt
7200
doc_number
22463
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 21488 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
21488
balance
0
due_date
2025-04-30 04:00:00+00:00
txn_date
2025-03-01 05:00:00+00:00
total_amt
7200
doc_number
22507
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 25647 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
25647
balance
7200
due_date
2026-04-30 04:00:00+00:00
txn_date
2026-03-01 05:00:00+00:00
total_amt
7200
doc_number
22893
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 19847 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
19847
balance
0
due_date
2024-10-31 04:00:00+00:00
txn_date
2024-09-01 04:00:00+00:00
total_amt
7200
doc_number
22368
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 18777 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
18777
balance
0
due_date
2024-06-30 04:00:00+00:00
txn_date
2024-05-01 04:00:00+00:00
total_amt
7200
doc_number
22265
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 21309 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
21309
balance
0
due_date
2025-04-02 04:00:00+00:00
txn_date
2025-02-01 05:00:00+00:00
total_amt
7200
doc_number
22496
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 18322 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
18322
balance
0
due_date
2024-04-30 04:00:00+00:00
txn_date
2024-03-01 05:00:00+00:00
total_amt
7200
doc_number
22216
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 22111 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
22111
balance
0
due_date
2025-06-30 04:00:00+00:00
txn_date
2025-05-01 04:00:00+00:00
total_amt
7200
doc_number
22581
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 19276 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
19276
balance
0
due_date
2024-08-30 04:00:00+00:00
txn_date
2024-07-01 04:00:00+00:00
total_amt
7200
doc_number
22301
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| quickbooks_make | 24304 | ecommerce support | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
24304
balance
0
due_date
2026-01-30 05:00:00+00:00
txn_date
2025-12-01 05:00:00+00:00
total_amt
7200
doc_number
22810
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
2
customer_ref__name
TTI Floor Care
private_note
ecommerce support
sales_term_ref__value
4
sales_term_ref__name
Net 60
total_amt__v_double
—
balance__v_double
—
|
|||||||
| toggl | 175058389 | TTI - Ecommerce Support (Retainer) | 1.00 | fuzzy+embedding | Active |
|
|