Contact

Presented below are the standard fields for this export. The contact export also allows clients to choose which fields to be included in the export. Note that additional custom fields can be created and exported from Customer Engagement depending on client requirements.

Pay attention with the fields of type “datetime” below as several formats are used.

Field	Data type	Description
id Example: “0C1216A2-E0F2-4682-A377-A982009D737A”	GUID	The unique contact ID generated by Customer Engagement
isDeleted Example: “0”	boolean	Whether a contact is deleted or not
deletedOn Example: “2020-01-01T00:00:00”	datetime	When the deletion happened
deletionReason Example: “DECEASED, MANUALLY_REMOVED”	varchar	Why the deletion happened
firstName Example: “Jane”	string	First name
lastName Example: “Doe”	string	Last name
street Example: “Janes street 12”	string	Street address
zipCode Example: “123 45”	string	Postal code
city Example: “Stockholm”	string	City
email Example: “jane.doevoyado.com”	email	Email address
mobilePhone Example: “+46123456789”	mobilephone	Mobile phone number
countryCode Example: “SE”	countrycode	Country code
socialSecurityNumber Example: “199101010101”	socialsecuritynumber	Social security number (actually the Swedish the personal identity number or Finnish personal identity code)
gender Example: “Female”	string	Gender
age Example: “29”	int	Age
createdInStore Example: “03591CA1-706A-4F9D-89DA-A97600D23FB7”	string	Recruitment store
store Example: “51C5FFB2-B8E9-455B-9102-A976009CACEA”	string	Regular store
careOf	string	Care of address
country Example: “Sweden”	string	Country
birthDay Example: “1991-01-01”	date	Birth date
memberNumber Example: “1234567890”	sequence	Customer number (If Customer Engagement is master)
nps.grade Example: “8”	int	Latest grade set by the customers
nps.datetime Example: “2020-01-01T00:00:00.000+01:00”	datetime	Date and time of when the grade was set
nps.averagegrade Example: “9,75”	number	Average score of all grades from the specific contact
rfm Example: “86.00000”	number	RFM score
retail.keyvalue.recency Example: “8”	int	How recently the contact made a purchase
retail.keyvalue.frequency Example: “9”	int	How frequent the contact makes purchases
retail.keyvalue.monetary Example: “8”	int	How much money the contact has spent
registrationDate Example: “2020-01-01T00:00:00Z”	datetime	Date and time of registration date
lastModifiedTime Example: “2020-01-01T00:00:00”	datetime	Date and time of when the contact was last modified
contactPreferencesAcceptsEmail Example: “true”	boolean	If the contact accepts email communication
contactPreferencesAcceptsSms Example: “true”	boolean	If the contact accepts sms communication
contactPreferencesAcceptsPostal Example: “true”	boolean	If the contact accepts postal communication
isApproved Example: “true”	boolean	If the contact is approved and verified in Customer Engagement
statusEmail Example: “Active / Inactive”	string	If the contact is reachable by email
statusSms Example: “Inactive”	string	If the contact is reachable by sms
statusPostal Example: “Active / Inactive”	string	If the contact is reachable by postal
storeExternalId Example: “123”	string	Regular Store (External id)
createdInStoreExternalId Example: “123”	string	Recruited by store (ExternalId)
retail.keyvalue.purchaseamounttotal Example: “1000.00”	decimal	Total purchase amount
retail.keyvalue.numberofarticlepurchasestotal Example: “10.00”	decimal	Total number of purchased articles
retail.keyvalue.averagereceipttotal Example: “100.00”	decimal	Average receipt amount of all purchases
retail.keyvalue.latestreceiptdate Example: “2020-01-01 00:00:00”	datetime	When the last purchase was made
retail.keyvalue.purchasefrequencytotal Example: “10.00”	decimal	Total number of purchases
retail.keyvalue.purchaseamountlast12months Example: “1000.00”	decimal	Total purchase amount over the last 12 months
retail.keyvalue. numberofarticlepurchaseslast12months Example: “10.00”	decimal	Total number of purchased articles over the last 12 months
retail.keyvalue.averagereceiptlast12months Example: “100.00”	decimal	Average receipt amount on all purchases made in the last 12 months
retail.keyvalue.purchasefrequencylast12months Example: “10.00”	decimal	Total number of purchases made in the last 12 months
retail.keyvalue.purchaseamountlast24months Example: “1000.00”	decimal	Total purchase amount in the last 24 months
retail.keyvalue. numberofarticlepurchaseslast24months Example: “10.00”	decimal	Total number of purchased articles in the last 24 months
retail.keyvalue.averagereceiptlast24months Example: “100.00”	decimal	Average receipt amount on all purchases made in the last 24 months
retail.keyvalue.purchasefrequencylast24months Example: “10.00”	decimal	Total number of purchases made in the last 24 months

Member level fields are also available (for example, member.level) but the exact member fields and their names can vary depending on which member level model you are using.

BI export

Delta share

Webhooks