Account_Salesforce

Synchronized Account object from Salesforce CRM. Primary key is the 18-character Salesforce Id.

Schema last reviewed 2026-06-17

Open Interactive Workspace All data views

Opens Account_Salesforce in the interactive canvas with SQL Sandbox.

Fields (13)

Field	Type	Flags	Relations	Description
`Id`	Text(18)	PK	—	Salesforce Account Id (18-char).
`Name`	Text(255)	—	—	Account name.
`Type`	Text(100)	NULL	—	Account type picklist value.
`Industry`	Text(100)	NULL	—	Industry classification.
`BillingCity`	Text(100)	NULL	—	Billing city.
`BillingState`	Text(100)	NULL	—	Billing state or province.
`BillingCountry`	Text(100)	NULL	—	Billing country.
`Phone`	Text(40)	NULL	—	Main phone number.
`Website`	Text(255)	NULL	—	Corporate website URL.
`OwnerId`	Text(18)	NULL	—	Owning user Id in Salesforce.
`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, Name, Type, Industry, BillingCity, BillingState
FROM Account_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.