A data field is essentially the column header in your spreadsheet when you import subscribers. Data fields tell WordFly which data you’re importing with your subscriber list. Data fields can also be used for email personalization and segmentation. Some data fields already exist for you in WordFly. You can also add your own custom fields.
WordFly data fields
These fields are included in your account by default.
| City | A subscriber’s city |
| Country | A subscriber’s country |
| CrmSubscriberId | A subscriber’s unique customer number from your WordFly integrated CRM |
| A subscriber’s unique email address, only one email per subscriber | |
| EmailFormatPreference | A subscriber’s email format preference (HTML vs Text) |
| First Name | A subscriber’s first name |
| Last Name | A subscriber’s last name |
| Phone | A subscriber’s phone number |
| PostalCode | A subscriber’s postal code (zip code) |
| SMS Number | A subscriber’s mobile number (use for accounts with SMS enabled) |
| State/Province | A subscriber’s home state |
| Street | A subscriber’s street address 1 |
| DownloadNumber | (Tessitura CRM accounts) A promotion number from Tessitura |
| SourceNumber | (Tessitura/Centaman CRM accounts) A promotion number from the CRM database |
There are also a few additional data fields used for subscriber profiles. They are only updated by WordFly and not by list imports.
| WordFlySubscribeDate | Date subscriber was created in WordFly |
| WordFlyOrigin | How subscriber was added to WordFly: WordFly Signup, WordFly Lightbox, or Import (list import) |
| EngagementRating |
Gold star rating based on engagement score |
|
EngagementScore |
Calculated based on user activity |
Learn more about Subscriber Profile data
List and Subscriber data fields
There are two types of data fields: List and Subscriber data fields. Most WordFly data fields (except two) are subscriber data fields.
| List Data | Data that is specific to a list and changes often, e.g., Performance Name. List data fields are not saved to a subscriber’s record in WordFly because the data is based on a list by list import. |
| Subscriber Data | Data that is specific to a subscriber and rarely changes, e.g., Email address, First Name. Subscriber data is saved to subscriber records in WordFly. You could import First Name in one list and WordFly can use that data for future emails without it being imported on the list again. |
Create a new custom field
If you have a field header in your list and there isn’t a correct match for it in WordFly, you’ll need to create a new Data Field in WordFly before you import your list.
1. Go to Subscribers > Data Fields
2. Click 'Create a custom field'
3. Start customizing your Data Field...
- Type a descriptive name for your data field into the Name field.
- Select a Field Type from the drop-down: List or Subscriber (note the definitions to the right in this window)
- Select a Data Type from the drop-down: Text, Number, or Date. If you select either Number or Date another drop-down will appear to customize the format for this type of data.
- (Optional) Type a brief description of the data field.
- Important: Be sure to only use alphanumeric characters for your data fields. Special characters such as parentheses, commas, and quotes can break your list imports. Dashes, spaces and underscores are acceptable.
4. Click Save to add the data field to your library
Edit a custom field
Descriptions on any data field can be updated. To edit a data field go to Subscribers > Data Fields and find the data field you would like to edit. Click the name of the data field on the left side. Then select View/Edit to edit the data field description.
Delete a custom field
Important: When a data field is deleted any emails that use that data field will no longer be able to pull data into the view email as webpage version of the email which is dynamically created when loaded.
To delete a data field, go to Subscribers > Data Fields and find the data field you would like to edit. Click the name of the data field on the left side. Then select Delete from the two available options.
