Contact_Salesforce
Synchronized Contact object. Join to Account_Salesforce on AccountId for account-level attributes.
Schema last reviewed 2026-06-17
Opens Contact_Salesforce in the interactive canvas with SQL Sandbox.
Synchronized Contact object. Join to Account_Salesforce on AccountId for account-level attributes.
Schema last reviewed 2026-06-17
Opens Contact_Salesforce in the interactive canvas with SQL Sandbox.
| Field | Type | Flags | Relations | Description |
|---|---|---|---|---|
Id |
Text(18) | PK | — | Salesforce Contact Id (18-char). |
AccountId |
Text(18) | FK, NULL | Account_Salesforce.Id | Parent Account Id. |
Email |
Text(254) | — | — | Primary email address — map to SubscriberKey in sends. |
FirstName |
Text(80) | NULL | — | Contact first name. |
LastName |
Text(80) | — | — | Contact last name. |
Title |
Text(128) | NULL | — | Job title. |
Phone |
Text(40) | NULL | — | Business phone. |
MobilePhone |
Text(40) | NULL | — | Mobile phone. |
MailingCity |
Text(100) | NULL | — | Mailing city. |
MailingState |
Text(100) | NULL | — | Mailing state or province. |
MailingCountry |
Text(100) | NULL | — | Mailing country. |
HasOptedOutOfEmail |
Boolean | — | — | Email opt-out flag from Salesforce. |
CreatedDate |
Date | — | — | Record created timestamp in Salesforce. |
LastModifiedDate |
Date | — | — | Last modified timestamp in Salesforce. |
IsDeleted |
Boolean | — | — | Soft-delete flag from Salesforce replication. |
SELECT TOP 100
Id, AccountId, Email, FirstName, LastName, Title
FROM Contact_Salesforce
WHERE CreatedDate >= DATEADD(day, -30, GETDATE())
ORDER BY CreatedDate DESCValid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.