Logo Help Portal
  • Başlarken

    Introduction

    • Onboarding overview
    • Project Initiation
    • Email compliance
    • Hesap Yönetimi

    Veri

    • Veri Alışverişi
    • Veri Uyumlamasına
    • Web data collection
    • Entegrasyonlar

    Channels

    • Email onboarding
    • Smart Insight
    • Predict
  • Eğitim Videoları

    Resources

    • Introduction
    • Online Self-learning
    • Onboarding Videoları

    Events

    • Instructor-led Training
    • Webinars
    • Seminars
    • Training Calendar
  • Kullanıcı Klavuzu

    Strateji

    • Kişiselleştirme
    • Otomasyon
    • Data Monitoring

    Channels

    • Email
    • Mobil Uygulamalar
    • Web
    • Ads
    • SMS

    Add-ons

    • Smart Insight
    • Predict
    • Incentive Recommendation
    • AIM
    • Relational Data
  • Destek Dokümanları
    Forrester Wave CCCM (Independent Platforms) Report Q4 2019

    Haberler

    • Emarsys Platformundaki Yenilikler
    • Updates from the CSA
    • Pilot özellikler
    • Verilerin Korunması ve GDPR Hakkında Makaleler

    Support

    • Nasıl yardım alabilirim?
    • Bir Kullanıcı Profilini Düzenleme
    • Preparing for Black Friday 2019
    • Black Friday 2019 - Best practices
  • |
  • Partners

    Enhance Partners

    • Getting Started as an Emarsys Partner
    • The Emarsys Integration Platform
    • Automation Center Integrations
  • Yazılımcılar
  • Sistem Durumu
Destek Hakkında
Türkçe Deutsch English Español Français Русский 简体中文 Test New Chat
Oturum aç
  • Veri Yönetimi
  • Data Management
  • 0 Veri Yönetimi Data Management

Bu bölümde:

  • Overview:: Contact data fields - Overview
  • Overview:: The Emarsys system fields
  • End-user guides:: Creating custom fields
  • Overview:: Available field types
  • Overview:: Single-choice fields and their values
EDIT
Expand all

Overview:: The Emarsys system fields

Updated: 14 Kasım 2019 01:00
115004637665
Overview:: The Emarsys system fields

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.

Contents

  • Introduction
  • Emarsys System Fields and their IDs
  • Admin fields
    • Web behavior fields - basic fields
    • Web behavior fields - e-commerce fields
    • Web behavior fields - opt-out for data privacy

Specific field details

  • Opt-in field
  • Interests field
  • Newsletter field
  • Do not track me field

Introduction

The ID and the string ID of the system fields are also displayed on the left of the table in the Field Editor.

You can create your own custom fields from the application interface or via the API. With the API you can also query the list of fields.

  • When using the API to update fields, you cannot update any of the fields marked as read-only in the table below.
  • Do not add emojis to the Emarsys System Fields. These are not supported and will lead to loss of data for those fields.
  • Click here for a list of the available field types.
  • Click here for a list of the IDs and values for single-choice fields.

Emarsys System Fields and their IDs

Field Name ID Values Type Example Read-only
Interests
0
interests (multi-choice) shoes Yes
First Name 1
short text Max No
Last Name 2
short text Mustermann No
E-Mail 3
long text Max.Mustermann@mustermann.at No
Date of Birth 4
date (birthdate) 1970-05-26* No
Gender 5 yes single choice Male No
Marital Status 6 yes single-choice Married No
Children 7 yes single-choice 0 No
Education 8 yes single-choice Bachelor No
Title 9 yes single-choice Dr. No
Address 10
long text 12 Straight Street No
City 11
short text Hometown No
State 12
short text Home State No
ZIP Code 13
numeric (short text) 1234 No
Country 14 yes single-choice Austria No
Phone 15
short text +123454445 No
Fax 16
short text (fax) +123454446 No
Job Position 17 yes single-choice Management No
Company 18
long text Emarsys No
Department 19 yes single-choice e-commerce No
Industry 20 yes single-choice Marketing 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
URL 25
URL www.emarsys.com 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
Registration language 35 yes single-choice English No
Newsletter 36
multi-choice (special) (Newsletter names) Yes
Mobile 37
short text +6801111122 No
First Name of Partner 38
short text Maria No
Birth date of Partner 39
date (birthdate) 1975-09-01* No
Anniversary 40
date 2001-06-30* 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
Country (office) 45 yes single-choice Austria No
Salutation 46 yes single-choice Ms. No
Email-valid 47 yes single-choice (special) Yes Yes
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.

Admin fields

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.

Basic 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).

E-Commerce fields

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.

Data privacy

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

Opt-in field

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 FALSE to TRUE via an import, only via the API or manually.

Interests field

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.

Newsletter field

The system field Newsletter (ID = 36) is a special multi-choice field which lists as its values all the Newsletter forms that you have created. When a contact subscribes to a newsletter through such a form, that value is automatically checked for them. If they unsubscribe, the same value is unchecked.

In this way you can keep your subscriptions to individual newsletters independent, both of each other and of the general opt-in.

When you create a newsletter email campaign, you can select Generated through a multi opt-in form as the Recipient source, and then select the opt-in form that collects the subscriptions.

The Newsletter field is not available for segmentation. If you want to create a segment based on one of the newsletter opt-in values, you must create an email campaign for that newsletter form, generate the launch list and save that as a contact list.

You can then segment based on that contact list.

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 TRUE.  

Important notes:

  • 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.
Bu makale yardımcı oldu mu?

Başka sorularınız var mı? Bir talep gönder
Üste dön

Emarsys is a Leader

You may also be interested in:

İlgili makaleler

  • Overview:: Single-choice fields and their values
  • Emarsys Scripting Language
  • Introduction to the Emarsys API
  • End-user guides:: Open Data - Datasets
  • Automated double opt-in program
Copyright © 2019 Emarsys eMarketing Systems. All rights reserved
Legal Notice Privacy Policy Master Services Agreement Anti-spam Policy