Each Emarsys account comes with a number of predefined system fields in the database. Here you can find a list of these fields, their type and ID, as well as a complete list of the single-choice fields and their respective values. These may be required when setting up automated data transfer between the Emarsys application and another application or web resource.
- Emarsys System Fields and their IDs
- Admin fields
Specific field details
The ID and the string ID of the system fields are also displayed on the left of the table in the Field Editor.
Important Note: When using the API to update fields, you cannot update any of the fields marked as read-only in the table below.
Emarsys System Fields and their IDs
|First Name||1||short text||Max||No|
|Last Name||2||short text||Mustermann||No|
|Date of Birth||4||date (birthdate)||1970-05-26*||No|
|Address||10||long text||12 Straight Street||No|
|State||12||short text||Home State||No|
|ZIP Code||13||numeric (short text)||1234||No|
|Fax||16||short text (fax)||+123454446||No|
|Phone (office)||21||short text||+123454447||No|
|Fax (office)||22||short text (fax)||+123454448||No|
|Number of Employees||23||yes||single-choice||10-49||No|
|Annual Revenue (in 000 EUR)||24||yes||single-choice||250-499||No|
|Preferred e-mail format||26||yes||single-choice||HTML||No|
|Avg. length of visit (minutes)**||27||numeric (special)||5||Yes|
|Page views per day**||28||numeric (special)||1,000||Yes|
|Days since last email sent**||29||numeric (special)||30||Yes|
|Response rate**||30||numeric (special)||30%||Yes|
|Opt-in||31||yes||single-choice (special)||Using the API: 1 (True), 2 (False) Empty string (NULL)||No|
|Using Forms: y (True), n (False), Empty string (NULL)|
|Contact source||33||yes||single-choice (special)||Manual||Yes|
|Contact form||34||yes||multi-choice (special)||Newsletter 1||Yes|
|Newsletter||36||multi-choice (special)||(Newsletter names)||Yes|
|First Name of Partner||38||short text||Maria||No|
|Birth date of Partner||39||date (birthdate)||1975-09-01*||No|
|Company Address||41||long text||1 Company House||No|
|Zip Code (office)||42||short text (numeric)||X4567||No|
|City (office)||43||short text||Vienna||No|
|State (office)||44||short text||Vienna||No|
|Date of first registration||48||date (special)||2015-05-22*||Yes|
* The only date format supported by the System fields is YYYY-MM-DD.
** These fields are deprecated.
These fields are added to your account when you enable or purchase a specific product. Their IDs are different for each account and can be found on the Field Editor page (Admin menu).
Web behavior fields
The Web Extend data collection scripts update a set of custom fields in your Emarsys account with data related to the activity of your contacts on your website. These fields are updated every few hours.
Although not as extensive in scope as the metrics uploaded to Smart Insight, this data can be used by you to launch targeted product campaigns, such as cart abandonment or stock clearance. We have provided some examples of Automation Center programs using these fields.
If you have only the basic Web Extend setup (not including the e-commerce commands), you will have the following fields updated in your Emarsys account.
|Field Name||Field Type||Description|
|predict last session date||date||The last time the contact interacted with the website, expressed in YYYY-MM-DD format.|
|predict last session time spent||numeric||The duration of the last session, in seconds, maximum 1800 (30 minutes).|
If you have the full Web Extend setup, you will also have the following fields updated.
|Field Name||Field Type||Description|
|predict last session products||long text||The products viewed in the last session, maximum 10.|
|predict last session categories||long text||The categories of the products viewed in the last session, maximum 10.|
|predict last session tags||long text||This field is used to store the most recent parameters passed by the Web Extend Tag command, maximum 10. Parameters are not deleted and remain until overwritten by new values. The same values can be written multiple times (no deduplication).|
|This field must be created manually by you if you are using the Tag command.|
|predict last abandoned date||Date||The date when a product was last abandoned, expressed in YYYY-MM-DD format.|
|predict last abandoned products||long text||The products abandoned in the cart, maximum 10.|
|predict last abandoned categories||long text||Categories of products abandoned in the cart, maximum 10.|
|predict last abandoned total price||numeric||Total price of all products left in the cart, expressed in the currency of the website.|
|predict last purchase date||date||The date of the last purchase, expressed in YYYY-MM-DD format.|
|predict last purchase products||long text||The products bought in the last purchase, maximum 10.|
|predict last purchase categories||long text||The categories of products bought in the last purchase, maximum 10.|
|predict last purchase total price||numeric||Total price spent in the last purchase.|
|predict top categories||long text||For this Predict calculates category preferences based on the most recent categories browsed, but with long-term preferences also taken into account.
For new users its usually the same as predict last session categories.
|Field name||String name||Field type||Description|
|Do not track me||do_not_track_me||single-choice||This allows you to offer your customers an opt-out for tracking their browse behavior.|
Specific field details
The system field Opt-in (ID = 31) stores the opt-in for email campaigns. The value should only be set to
TRUE via a double opt-in process.
Any form of unsubscription by the recipient of an email will set this to
FALSE. In cases where email subscription is unknown, the value
NULL should be used. This field should not contain an empty string.
For normal marketing emails, only contacts with the value
TRUE will receive the email, unless the option Ignore opt-in has been enabled for your account by Emarsys Support.
Some transactional email types will ignore this field, see: Ignoring opt-in for certain transactional emails.
You cannot set the value of this field from
TRUE via an import, only via the API or manually.
The system field Interests (ID = 0) is a special multi-choice field which is automatically added to your Emarsys forms. You can use this to collect a standard set of preference information on your new registrations, for example. To create and edit the available options, go to Contacts > Form Settings > Opt-in invitation and interests.
You can also update the Interests of existing contacts either by exporting them and adding the values externally, or by editing the contacts individually.
The language selected for these options is the Form default language that is selected in your Profile page. If you use forms in multiple languages, you can provide translations of these options. Simply select the target Language, then the Interest field and click Translate.
When you have done this, these translations will appear when you change the language of the form.
Do not track me field
This field prevents Web Extend from including the contact ID when tracking browse and purchase events on your web shop. It should be used to offer customers the chance to opt-out of this tracking, in accordance with GDPR (for more information, see: GDPR and Web Extend - all you need to know).
Web Extend will still track behavior and send that data to the Predict servers, but there will be no hashed email address or any form of contact ID associated with it. This data will be used to build the statistical models that underpin the Predict product recommendations.
Remember, this field is a 'negative' field, that is, the default value is
FALSE, meaning that a contact will be tracked. To opt a contact out of Web Extend tracking, you must change the value to
- This field stops Web Extend from tracking a visitor as they browse your store. It will not stop any cookies you have implemented from doing the same, nor will it stop your contacts' preferences or sales data being synced to Emarsys if you are uploading that data through another route. If you really want to implement an end-to-end 'do not track me' scenario, you will have to take care of all these other touchpoints as well.
- Opting a contact out of tracking will not mean that they will never receive relevant recommendations. Depending on your business, it can easily happen that an opted-out contact behaves in a predictable way and therefore will continue to see products they have recently viewed. But that is based on Predict's intelligence, not on Web Extend's tracking.