Creating table fields

Use this page to enter the field names and set the corresponding types for your new table.

Note: To modify the schema of the data source later, click An image of the down arrow next to its name on the Manage Lists page, and select Change Schema.

Field name requirements and recommendations

  • System Generated fields (EMAIL_ADDRESS_, CUSTOMER_ID_, RIID_,MOBILE_NUMBER_) cannot be added manually into a Profile Extension Table.
  • Field names cannot contain the single letters A, E, G, K, M P, T and U. These letters are reserved by the application.
  • Field names must start with a letter.
  • The Filter Designer does not support profile extension table fields of the Maximum Text Field (to 4000 chars*) data type.
  • We recommend that field names contain at least two characters.
  • System field names end with an underscore. To avoid duplication of system fields, we recommend that custom table field names do not end with a trailing underscore.
  • It's best practice to use the Text, Number or Integer field specific to the field content. Example: numerical field names should use Number or Integer as opposed to text fields to improve query performance.