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.

    • Related Articles

    • Hiding Standard Contact Fields

      Sometimes, less is more when managing contact data. Delivra allows administrators to hide demographic fields that aren't currently in use. This helps streamline your account by preventing unused fields from being accidentally included in segments, ...

    • Customizing SMS Data Fields

      Please note this feature is only available in Legacy for now, but it is coming to Air soon! Delivra makes it easy to manage and personalize your SMS communications by supporting a range of custom fields on SMS contact records. These fields can store ...

    • How do I import a list of unsubscribed contacts to my account?

      If you have previously used an email service provider like Delivra, we recommend that you migrate any email subscribers that opted-out of campaigns you sent through that system. This way, you're ensuring that you don't all of a sudden start emailing ...

    • The SMS Contact Record

      This article covers how to find the contact's profile record and how to make manual changes to your contacts. What is the Contact Profile Your contacts' Profiles are located in the Contacts dashboard and accessed by clicking the 'Edit' button that ...

    • Auditing Changes to Contact

      The Contact Audit Log is a helpful tool for administrators to track changes made to individual contact records. Whether updates come from internal teams or integrated systems, the audit log provides visibility into when and how a contact’s data was ...