Profile Export Fields with Custom Attributes

Custom attributes are extensions to the customer or product record. They are additional data fields that can be used to store non-standard data.

The customer attribute data exports in pairs -- custom attribute name followed by the value. This format holds for each of the four types of attributes:

  • Data/Time
  • Numeric
  • Lookup
  • Text

The following table shows Custom Attribute Headers and their description for a sample client. (Custom attributes and profile data vary based on client customization.)

Custom Attribute Header Description
CustomDateTimeValueLastChangedDateTime

The last time a custom date field was changed for this customer, cumulative across all custom date/time fields.

CustomDateTimeName1

CustomDateTimeValue1

to

CustomDateTimeName20

CustomDateTimeValue20

The name of the date/time custom attribute

and

The value of the date/time custom attribute.

CustomNumericValueLastChangedDateTime

The last time a custom numeric field was changed for this customer, cumulative across all custom numeric fields.

CustomNumericName1

CustomNumericValue1

to

CustomNumericName20

CustomNumericValue20

The name of the numeric custom attribute.

and

the value of the numeric custom attribute for this customer.

CustomLookupValueLastChangedDateTime

The last time a custom lookup field was changed for this customer, cumulative across all custom lookup fields.

CustomLookupName1

CustomLookupValue1

to

CustomLookupName20

CustomLookupValue20

The name of the lookup custom attribute

and

the value of the lookup custom attribute.

CustomTextValueLastChangedDateTime

The last time a custom text field was changed for this customer, cumulative across all custom text fields.

CustomTextName1

CustomTextValue1

to

CustomTextName20

CustomTextValue20

The name of the text custom attribute for this customer

and

the value of the text custom attribute for this customer.

Note: Even if the client is not using all attributes, the name and value pair are displayed in the table.