Retrieves detailed information for a specific contact in Salesforce Marketing Cloud. A contact represents an individual subscriber or customer who interacts with your marketing campaigns. This view provides insights into contact attributes, engagement status, and associated data extensions.

Table Specific Information

Select

Retrieve all contacts:

SELECT * FROM Contact

Note: Most columns for this table are dynamic so they may not be the same as the columns specified below because you can have a different Contact schema in your Salesforce marketing cloud account.
Contacts that are in a deleted, deleting, or restricted state are not retrieved.

Columns

Name	Type	References	Description
ContactID [KEY]	Int		Identifies the system-defined identifier (Id) that uniquely represents the contact within Salesforce Marketing Cloud. This Id is automatically generated when the contact record is created and remains immutable across all channels and data extensions. It serves as the master reference for contact relationships, event tracking, and subscription management within the Contact Builder module.
ContactKey	String		Specifies the user-defined Id that is assigned to the contact. This value acts as a cross-channel key that links contact records across email, mobile, and other customer engagement data sources. Maintaining a consistent contact key ensures that profile attributes, preferences, and engagement history are accurately unified within the contact model.