File Usage Guidelines, Data Elements and Formats

Purpose and Usage

The data included in this Customer file is incremental.

The New and Updated Customer Export File. Only the records with new data or updated data are extracted and included in this file. TIBCO Reward generates this file by extracting information from its database for each customer whose “profile information” was updated between the current time and the previous time of extract. To be more specific, an update in any one of the following profile information fields in a customer’s record will cause that customer’s record to be included in the next Customer export file:

  • ShopperStatus
  • ShopperName
  • ShopperAddress
  • Email
  • CustomerPrivacy
  • PhoneNumber
  • Change in point balance
  • Tier Movement (if applicable)
Note: If a Customer export file includes custom attributes, then a change in one of the following fields in a customer's record will cause that record to be included in the extract:
  • CustomDateTimeValueLastChangedDateTime DateRange
  • CustomNumericValueLastChangedDateTime
  • CustomLookupValueLastChangedDateTime
  • CustomTextValueLastChangedDateTime