Each business has different data points that are relevant to its market. Campaign Studio supports several standard fields that are generic to any businesses. However, as the requirements for each business are unique, Campaign Studio also allows you to create custom fields. By creating custom fields, you can define the information that is important to you and your business and leverage such data points to personalize messaging, segment contacts, and run reports that can indicate which types of contacts are worth spending the most time and money targeting.
Acquia recommends that you create your own custom fields in Campaign Studio before importing your contact list through CSV or API.
To access the Custom Fields page in Campaign Studio, click the Settings icon in the top right corner and select Custom Fields.
The Custom Fields page shows all the existing contact fields, including standard fields and any custom contact fields that you’ve created earlier.
The various columns on this page are:
Data Type: Indicates the data type that Campaign Studio leverages to validate data in this field. Once you have saved the new custom field, you cannot update this value. For more information, see Data types.
Campaign Studio has a limit on the maximum number of characters allowed for all contact fields combined. The effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to:
The internal representation of a table has a maximum row size of 65,535 bytes even if the storage engine is capable of supporting larger rows. This figure excludes BLOB or TEXT columns, which contribute only 9 to 12 bytes toward this size. For BLOB and TEXT data, the information is stored internally in a different area of memory than the row buffer.
Text and Longtext require only 4 bytes to store. For more information, see MySQL.
If an instance reaches the character limit, you cannot create any new custom fields. To avoid reaching the character limit, Acquia recommends you to create a data mapping document that includes field lengths for tracking purposes.
Additionally, Campaign Studio displays the following indicators that show various properties of the custom fields:
To publish a specific custom field, toggle the bar (adjacent to the label of the field) to the left until it appears in green. Alternatively, to unpublish a specific custom field, toggle the bar to the right until it appears in red.
You can create additional custom fields and define the data type you want that field to hold.
To create a custom field:
Object: Select either of the following options:
Once you’ve saved the new custom field, you can’t update this value.
Default Value: Specify a default value for the custom field so that all the new contacts created have that value.
Publicly updatable: Set this option to Yes so that you can update the custom field based on a tracking script event. If you’re tracking events behind the login of your SaaS platform or want to otherwise update a field based on some activity, you can use this option.
This is a technical feature and you may use other features as well to achieve a similar result.
Indexable: Make this field indexable to improve search performance.
Duplicate contacts with the same unique identifier are merged only if the contacts were created or updated through the API or a CSV import.
| Field type | Data type | Size | Maximum character limit | Additional details |
|---|
| Boolean | tinyint | 1 byte | N/A | N/A |
| Date | date | 3 bytes | N/A | N/A |
| Date/Time | datetime | 8 bytes | N/A | N/A |
| varchar | 4x the maximum character length | 191 | N/A | |
| List - Country | varchar | 4x the maximum character length | 191 | N/A |
| Locale | varchar | 4x the maximum character length | 191 | N/A |
| Lookup | varchar | 4x the maximum character length | 191 | N/A |
| Number | double | 8 bytes | N/A | N/A |
| Phone | varchar | 4x the maximum character length | 191 | N/A |
| Select | varchar | 4x the maximum character length | 191 | N/A |
| Select - Multiple | TEXT | N/A | N/A | For TEXT type: A TEXT column with a maximum length of 65,535 bytes. utf8mb4: A UTF-8 encoding of the Unicode character set using 1 to 4 bytes per character. For example, the string “”Hello”” with 5 characters occupies 5 bytes and the string “”こんにちは”” with 5 characters occupies 10 bytes. |
| Text | varchar | 4x the maximum character length | 191 | N/A |
| Textarea | longtext | N/A | N/A | For LONGTEXT type: A TEXT column with a maximum length of 4,294,967,295 bytes. utf8mb4: A UTF-8 encoding of the Unicode character set using 1 to 4 bytes per character. For example, the string “”Hello”” with 5 characters occupies 5 bytes and the string “”こんにちは”” with 5 characters occupies 10 bytes. |
| HTML | longtext | N/A | N/A | N/A |
| Time | time | 3 bytes | N/A | N/A |
| Timezone | varchar | 4x the maximum character length | 191 | N/A |
| URL | varchar | 4x the maximum character length | 191 | N/A |
Default values can only be applied to custom fields that are not used as unique identifiers.
The following limitations apply to indexing custom fields:
The maximum number of custom fields that can be indexed in Campaign Studio is 64.
The total length of all indexed fields in Campaign Studio must be less than or equal to 3072.
Maximum character length: The maximum permissible length for new custom fields is 191 characters. The default length is 64 characters.
If this content did not answer your questions, try searching or contacting our support team for further assistance.
If an instance reaches the character limit, you cannot create any new custom fields. To avoid reaching the character limit, Acquia recommends you to create a data mapping document that includes field lengths for tracking purposes.
| Field type | Data type | Size | Maximum character limit | Additional details |
|---|---|---|---|---|
| Boolean | tinyint | 1 byte | N/A | N/A |
| Date | date | 3 bytes | N/A | N/A |
| Date/Time | datetime | 8 bytes | N/A | N/A |
| varchar | 4x the maximum character length | 191 | N/A | |
| List - Country | varchar | 4x the maximum character length | 191 | N/A |
| Locale | varchar | 4x the maximum character length | 191 | N/A |
| Lookup | varchar | 4x the maximum character length | 191 | N/A |
| Number | double | 8 bytes | N/A | N/A |
| Phone | varchar | 4x the maximum character length | 191 | N/A |
| Select | varchar | 4x the maximum character length | 191 | N/A |
| Select - Multiple | TEXT | N/A | N/A | For TEXT type: A TEXT column with a maximum length of 65,535 bytes. utf8mb4: A UTF-8 encoding of the Unicode character set using 1 to 4 bytes per character. For example, the string “”Hello”” with 5 characters occupies 5 bytes and the string “”こんにちは”” with 5 characters occupies 10 bytes. |
| Text | varchar | 4x the maximum character length | 191 | N/A |
| Textarea | longtext | N/A | N/A | For LONGTEXT type: A TEXT column with a maximum length of 4,294,967,295 bytes. utf8mb4: A UTF-8 encoding of the Unicode character set using 1 to 4 bytes per character. For example, the string “”Hello”” with 5 characters occupies 5 bytes and the string “”こんにちは”” with 5 characters occupies 10 bytes. |
| HTML | longtext | N/A | N/A | N/A |
| Time | time | 3 bytes | N/A | N/A |
| Timezone | varchar | 4x the maximum character length | 191 | N/A |
| URL | varchar | 4x the maximum character length | 191 | N/A |
Default values can only be applied to custom fields that are not used as unique identifiers.
The following limitations apply to indexing custom fields:
The maximum number of custom fields that can be indexed in Campaign Studio is 64.
The total length of all indexed fields in Campaign Studio must be less than or equal to 3072.
Maximum character length: The maximum permissible length for new custom fields is 191 characters. The default length is 64 characters.
If this content did not answer your questions, try searching or contacting our support team for further assistance.