CustomerLists (Partial Update)
Description
See the Aerial Spec for more details.
File Naming Convention
TGEN_customerLists_partialupdate_2025-12_<optionalSuffix>.csv
importType:partialupdateapiVersion:2025-12
Columns
| Column Header | Description | Key Information | Type | Required |
|---|---|---|---|---|
uuid | UUID of the resource that can be expressed using a value as defined in its types. | string | No | |
externalId | External ID of the resource that can be expressed using “SET_AS_NULL” (to reset the existing value) or a value as defined in its types. | string | No | |
status | Status of the customer list that can be expressed using a value as defined in its types. | string | No | |
type | Type of the customer list that can be expressed using a value as defined in its types. | Allowed: corporate, dynamic, dynamic_default | string | No |
startDate | Datetime of when the Customer List will begin to be visible in the application. When null, will always be visible before the endDate. that can be expressed using “SET_AS_NULL” (to reset the existing value) or a value as defined in its types. | string | No | |
endDate | Datetime of when the Customer List will no longer be visible in the application. When null, will always be visible after the startDate. that can be expressed using “SET_AS_NULL” (to reset the existing value) or a value as defined in its types. | string | No | |
secondaryMetric | A customer field or attribute to display alongside loyalty tier information on the customer list UI. Must be a top-level field on the Customer resource or an attribute. | Pattern: /^customer\.(uuid|externalId|firstName|lastName|prefix|suffix|disabled|excludeFromCampaigns|image|dateCreated|dateModified|lastPurchaseOrderId|lastPurchaseStatusId|lastPurchaseDate|lastRefundOrderId|lastRefundDate|numberOfPossibleDuplicates|lastOutreachDate|lastOutreachType|createdStoreUuid|createdStoreExternalId|attributes(\.\w+))/$ | string | No |
anchoringMetric | Anchoring metric for the customer list that can be expressed using “SET_AS_NULL” (to reset the existing value) or a value as defined in its types. | string | No | |
visibility | Visibility level for the customer list that can be expressed using a value as defined in its types. | Allowed: all, associate, manager | string | No |
position | Sort position within type (lower values appear first) that can be expressed using a value as defined in its types. | integer | No | |
source | N/A | mixed | No | |
source.sourceType | Type of the source | Allowed: segment | string | Yes |
source.sourceExternalId | External ID of the source | string | Yes | |
source.sourceCacheTtl | Cache TTL in seconds. When null, defaults to 24 hours (86400 seconds) | Min: 0 | integer | No |
customers | A collection of customers that can be expressed using “SET_AS_NULL” (to reset all existing values), uuids or external ids. | array | No | |
customers[0] | Array element | mixed | No | |
stores | A collection of stores that can be expressed using “SET_AS_NULL” (to reset all existing values), uuids or external ids. | array | No | |
stores[0] | Array element | mixed | No | |
associates | A collection of associates that can be expressed using “SET_AS_NULL” (to reset all existing values), uuids or external ids. | array | No | |
associates[0] | Array element | mixed | No | |
localizations | Contains the different localizations for strings associated to this resource. Resolve the best known language on the client based on available languages, not all languages are always provided. | array | No | |
localizations[0] | Array element | mixed | No | |
localizations[0].title | Title of the customer list in the current language | string | Yes | |
localizations[0].description | Description of the customer list in the current language | string | No | |
localizations[0].languageCode | Language this localization pertains to, follows a pattern of 2 letters and can then have multiple other groups of 2 letters or more. Each block separated by an hyphen. | Max Length: 32 Min Length: 2 Pattern: ^[a-z]{2}(-[a-z]{2,})*$ | string | No |
Sample CSV
See the following customerLists CSV sample file.
Note: The sample CSV may contain sample ID fields which reference other resources that do not match the data in your environment. You may omit any non-required fields from the sample CSV, reference the table above for required fields.