What are the character limits for standard contact data fields?

What are the character limits for standard contact data fields?

When working with contact data in Delivra, it's important to understand how much information can be stored in each type of contact field. Character limits vary by field type, and entering data that exceeds these limits may result in truncation or errors during import or automation.

Field Types and Character Limits

Below is a breakdown of the most common field types and their respective character capacities:

Standard Text Fields

  • Limit: Up to 50 characters
  • Note: Some exceptions apply. For example, Phone Number fields are limited to 15 characters.

Text Fields

  • Limit: Up to 200 characters each
  • These fields provide more flexibility than standard fields for storing longer text strings.

Comment Fields

  • Limit: Up to 1,000 characters
  • Ideal for storing moderately long notes or internal details.

Unicode Fields

  • Limit: Up to 4,000 characters
  • Useful for supporting non-Latin character sets or extended text.

Long Text Fields

  • Limit: At least 120,022 characters, potentially unlimited
  • Only two standard long text fields exist: Additional_ and Comment_
  • These are best suited for logging large data entries such as customer histories or detailed notes.

Other Field Considerations

Some field types are more restrictive regarding the kind of data they can store:

  • Number Fields: Accept only whole numbers. Decimal values are not supported.
  • Date Fields: Must follow valid date formatting (e.g., MM/DD/YYYY).

Best Practices and Tips

  • Match data to field types during import or API integration to avoid errors.
  • Use long text fields strategically, as there are only two available in the standard contact field set.
  • Store numeric data in number fields only if calculations or sorting are needed; otherwise, consider a text field for things like account numbers or zip codes.
  • Use Unicode fields when storing data with special characters, such as international names or addresses.

Practical Use Cases

  • A Standard Text Field might store a job title like "Marketing Manager".
  • A Text Field could be used to capture a 140-character tweet for social integration tracking.
  • A Comment Field may hold a summary of recent customer interactions.
  • A Unicode Field can support names like "Renée O’Connor" or "李小龙".
  • A Long Text Field might be used to store full call transcripts or survey responses.