ContactIdentityProfiles
Displays identity profiles associated with contacts, helping track multiple identities linked to a single contact.
Table Specific Information
A list of objects representing the identities of the contact. Each identity represents an identifier for the object, many records will only have a single identity, but merged records may have multiple.
SELECT
Contact identity profiles can only be filtered by the unique contact id. For example:
SELECT * FROM ContactIdentityProfiles SELECT * FROM ContactIdentityProfiles WHERE ContactVID = '123456'
Columns
| Name | Type | References | Description |
| ContactVID | Long |
Contacts.VID | Unique identifier (visitor ID) of the contact associated with the identity profile. |
| Type | String | Specifies the type of identity, such as EMAIL or LEAD_GUID. | |
| Value | String | Actual value of the identity, like the email address or lead GUID. | |
| Timestamp | Datetime | Timestamp indicating when the identity profile was first created. | |
| SavedAt | Datetime | Timestamp indicating when the identity profile was last updated. |