Lead_Salesforce

Synchronized Lead object for prospect records before conversion to Contact/Account.

Schema last reviewed 2026-06-17

Open Interactive Workspace All data views

Opens Lead_Salesforce in the interactive canvas with SQL Sandbox.

Fields (17)

Field	Type	Flags	Relations	Description
`Id`	Text(18)	PK	—	Salesforce Lead Id (18-char).
`Email`	Text(254)	NULL	—	Lead email address.
`FirstName`	Text(80)	NULL	—	Lead first name.
`LastName`	Text(80)	—	—	Lead last name.
`Company`	Text(255)	—	—	Company name on the lead.
`Status`	Text(100)	—	—	Lead status picklist value.
`Rating`	Text(50)	NULL	—	Lead rating (Hot/Warm/Cold).
`LeadSource`	Text(100)	NULL	—	Original lead source.
`Industry`	Text(100)	NULL	—	Industry classification.
`Phone`	Text(40)	NULL	—	Primary phone.
`HasOptedOutOfEmail`	Boolean	—	—	Email opt-out flag from Salesforce.
`IsConverted`	Boolean	—	—	Whether the lead converted to Contact/Account.
`ConvertedContactId`	Text(18)	FK, NULL	Contact_Salesforce.Id	Resulting Contact Id after conversion.
`ConvertedAccountId`	Text(18)	FK, NULL	Account_Salesforce.Id	Resulting Account Id after conversion.
`CreatedDate`	Date	—	—	Record created timestamp in Salesforce.
`LastModifiedDate`	Date	—	—	Last modified timestamp in Salesforce.
`IsDeleted`	Boolean	—	—	Soft-delete flag from Salesforce replication.

Example query

SELECT TOP 100
  Id, Email, FirstName, LastName, Company, Status
FROM Lead_Salesforce
WHERE CreatedDate >= DATEADD(day, -30, GETDATE())
ORDER BY CreatedDate DESC

Valid 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.