External customer IDs history
A dataset of customer external ID change history. Each change to an external ID is recorded as a separate entry in the dataset.
exports.CDP.ExternalCustomerIdsHistory
| Column | Type | Description | Example |
|---|---|---|---|
| id | int64 | The unique identifier of a record in the customer ID history. | 25 |
| unmergedCustomerId | int64 | The customer's internal ID at the time of the event. | 12381 |
| customfieldKindInternalId | String | The external ID of the custom field. | cf21fdb5-b7d8-4fe9-b3c8-2d995fc3a90f |
| value | String | The encrypted value of the customer's external ID. | |
| historicalCustomerId | int64 | The ID of the customer snapshot. | 15 |
| historicalCustomerCreationDateTimeUtc | datetime | The date the customer snapshot was created, in UTC. | 2024-08-21 10:10:10.000 |
| _isDeleted | bool | A flag indicating that the external ID has been deleted. | True |
| _database_version | int64 | A system field for tracking the record version on each update. | 5 |
Updated 5 months ago