Retrieves a comprehensive list of all contacts in Salesforce Marketing Cloud. Each contact represents a unique individual with associated communication preferences and subscription data. This view is used to review or export contact records for segmentation, personalization, or compliance reporting.

Table Specific Information

Select

Retrieve all contacts:

SELECT * FROM Contacts

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
GroupConnect LINE Demographics.Address ID	String		Stores the unique identifier (Id) that represents the physical or account-level address that is associated with a LINE contact in the GroupConnect field. This Id links demographic details with the contact's LINE profile and is used to support localized targeting and message delivery.
GroupConnect LINE Demographics.Contact ID	Long		Specifies the system-defined Id that uniquely represents the contact within GroupConnect for LINE. This value enables Salesforce Marketing Cloud to associate LINE message interactions and subscription preferences with the unified contact profile in Contact Builder.
GroupConnect LINE Demographics.Contact Key	String		Specifies the user-defined contact key that links the LINE contact to the unified customer record in Contact Builder. Maintaining a consistent contact key across channels ensures that LINE activity, preferences, and subscription status are reflected accurately in cross-channel reports.
Contact.Contact ID [KEY]	Int		Specifies the system-defined Id that uniquely represents the contact in Salesforce Marketing Cloud. This identifier is automatically generated when the contact is created and provides the primary linkage point for all contact data extensions and engagement activities.
Contact.Contact Key	String		Specifies the user-defined contact key that is assigned to the contact record. This key acts as the cross-channel Id that is used to unify profile data and behavioral tracking across Email, MobileConnect, MobilePush, and GroupConnect interactions.
Email Demographics.Contacts ID	Long		Specifies the system-defined Id that represents the contact within the Email Demographics data set. This Id links each contact to their email send, open, and click activities that are tracked for personalization and reporting.
Email Demographics.NewAttrTest	String		Represents a test attribute that is used for validating new or custom demographic fields in Email Demographics. This column serves as an example or placeholder for custom attributes that are added during development or data model extension testing.
Email Demographics.NewAttrTest1	String		Represents a secondary test attribute that demonstrates how additional demographic fields can be incorporated into the Email Demographics data set. It allows users to verify schema mapping and integration logic.
Email Demographics.NewAttrTest 2	String		Represents a tertiary test attribute that is used for evaluating new attribute behavior and ensuring compatibility with email segmentation or personalization logic.
Email Demographics.tet	String		Represents a temporary test column that is used for data validation or sandbox testing purposes in the Email Demographics data extension.
Email Addresses.Email Address	String		Stores the primary email address that is associated with the contact record. This value is used for message delivery, subscription management, and identity resolution across Marketing Cloud email activities.
Email Addresses.HTML Enabled	Bool		A Boolean field that returns a value of 'true' when the contact prefers to receive HTML-formatted emails. It returns a value of 'false' when the contact prefers plain-text messages. This preference is referenced during message compilation to determine which version of an email to send.
MobileConnect Demographics.Contact ID	Long		Specifies the system-defined Id that uniquely represents the contact within the MobileConnect Demographics data set. This identifier links Short Message Service (SMS) activity, opt-in status, and message response data to the unified contact record.
MobileConnect Demographics.Locale	String		Specifies the language or regional setting that is associated with the contact's MobileConnect profile. Locale data supports personalized SMS messaging and compliance with local language requirements.
MobileConnect Demographics.Mobile Number	String		Stores the mobile phone number that is associated with the contact's MobileConnect profile. This number is validated during opt-in workflows and is used for message targeting, delivery tracking, and compliance reporting.
MobilePush Demographics.Application	String		Specifies the mobile application that is registered with Salesforce Marketing Cloud MobilePush and linked to the contact. This value identifies which application instance is used for push notifications and supports segmentation by application or platform.
MobilePush Demographics.Contact ID	Long		Specifies the system-defined Id that represents the contact within the MobilePush Demographics data set. This Id links push notification activity and subscription status to the unified contact profile.
MobilePush Demographics.Device ID	String		Stores the unique Id of the mobile device that is registered for receiving push notifications. This value supports device-level targeting, frequency capping, and troubleshooting for mobile engagement campaigns.
Contact.Business Unit ID	Int		Specifies the business unit Id that defines the organizational context for the contact record. This field determines which business unit owns or manages the contact's data and permissions within the enterprise hierarchy.
Email Addresses.Member ID	Int		Stores the Marketing Cloud Member Id (MID) that identifies the business unit responsible for managing the contact's email address and associated subscription data. This linkage ensures that opt-in preferences are properly enforced within each unit.
Email Addresses.List ID	Int		Specifies the list identifier (Id) that represents the subscriber list or audience segment that includes the contact's email address. This value is used to associate the contact with specific mailing lists and supports list-level subscription management.