Salesforce → HubSpot

Bi-directional CRM sync · 482,310 records · last sync 2m ago

Salesforce
Source · Production
HubSpot
Destination · Marketing

Data mapping

Source field → target field with type & transformation

SourceTargetTypeTransform
Account.Namecompany.namestringtrim + titleCase
Account.BillingAddresscompany.addressobjectflatten
Contact.Emailcontact.emailemaillowercase
Contact.Phonecontact.phonephoneE.164 normalize
Opportunity.Amountdeal.amountcurrencyUSD → cents
Opportunity.CloseDatedeal.close_datedateISO 8601
Opportunity.StageNamedeal.stageenumstage map
User.Idowner.external_idstringprefix sf_

Sync history

Last 5 sync runs

  • 11:02:14 UTC Success
    Full sync completed
    48,210 records · 1m 12s
  • 10:57:01 UTC Success
    Incremental delta
    12,940 records · 42s
  • 10:52:33 UTC Partial
    3 records skipped (validation)
    8,712 records · 1m 04s
  • 10:47:09 UTC Success
    Incremental delta
    21,440 records · 58s
  • 10:42:48 UTC Failed
    HubSpot API rate limit (429)
    0 records · 6s

Field transformation rules

Applied during sync

  • company.name
    Trim whitespace, convert to Title Case
    acme corp → Acme Corp
  • contact.email
    Lowercase, validate RFC 5322
    Jane@Acme.com → jane@acme.com
  • contact.phone
    Convert to E.164 with US default country code
    (415) 555-1234 → +14155551234
  • deal.amount
    Convert USD float to integer cents
    1,299.99 → 129999
  • deal.stage
    Map Salesforce stage → HubSpot stage
    Closed Won → closedwon

Error log

Recent sync failures & warnings

  • 10:42:48429
    HubSpot API rate limit exceeded — retrying with exponential backoff
  • 10:18:22VALIDATION
    Record sf_0034: contact.email failed RFC 5322 check — skipped
  • 09:51:09TIMEOUT
    Source query exceeded 30s budget — partial batch committed
  • 09:14:55409
    Duplicate company.name 'Acme Corp' — merged into existing record