Skip to main content

Voyado Engage

Contact - export fields

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 Engage depending on client requirements.

Field

Description

Data type

Example value

id

The unique contact id generated by Voyado

GUID

0C1216A2-E0F2-4682-A377-A982009D737A

isDeleted

If contact is deleted or not

boolean

0

firstName

First name

string

Jane

lastName

Last name

string

Doe

street

Street address

string

Janes street 12

zipCode

Postal Code

string

123 45

city

City

string

Stockholm

email

Email address

email

jane.doe@voyado.com

mobilePhone

Mobilephone

mobilephone

+46123456789

countryCode

Country code

countrycode

SE

socialSecurityNumber

Social security number

socialsecuritynumber

199101010101

gender

Gender

string

Female

age

Age

int

29

createdInStore

Recruitment store

GUID

03591CA1-706A-4F9D-89DA-A97600D23FB7

store

Regular store

GUID

51C5FFB2-B8E9-455B-9102-A976009CACEA

careOf

Care of

string

country

Country

string

Sweden

birthDay

Birth date

date

1991-01-01

memberNumber

Customer number (If Voyado is master)

sequence

1234567890

bonusPoints

Current point balance (only if Bonus module is activated for the client)

int

499

nps.grade

Latest grade set by the customers

int

8

nps.datetime

Date and time of when the grade was set

datetime

2020-01-01T00:00:00.000+01:00

nps.averagegrade

Average score of all grades from the specific contact

number

9,75

rfm

RFM score

number

86.00000

retail.keyvalue.recency

How recent the contact made purchase

int

8

retail.keyvalue.frequency

How frequent the contact makes purchases

int

9

retail.keyvalue.monetary

How much money the contact has spent

int

8

level

Memberlevel

string

Gold

levelLeftForUpgrade

Amount to upgrade

decimal

2000.00

levelChanged

Changed level

datetime

2020-01-01T00:00:00.000+01:00

levelExpires

Expired level

datetime

2020-01-01T00:00:00.000+01:00

levelRequiredToKeep

Amount to keep level

decimal

1000.00

registrationDate

Date and time of registration date

datetime

2020-01-01T00:00:00.000+01:00

lastModifiedTime

Date and time of when the contact was last modified

datetime

2020-01-01T00:00:00.000+01:00

contactPreferencesAcceptsEmail

If contact accepts email communication

boolean

true

contactPreferencesAcceptsSms

If contact accepts sms communication

boolean

true

contactPreferencesAcceptsPostal

If contact accepts postal communication

boolean

true

isApproved

If the contact is approved and verified in Voyado

boolean

true

statusEmail

If contact is reachable by email

string

Hardbounce

statusSms

If contact is reachable by sms

string

Inactive

statusPostal

If contact is reachable by postal

string

Unsubscribed

statusEmailDateUtc

Datetime of when the statusEmail was last changed

datetime

2020-01-01T00:00:00.000+01:00

statusSmsDateUtc

Datetime of when the statusSms was last changed

datetime

2020-01-01T00:00:00.000+01:00

statusPostalDateUtc

Datetime of when the statusPostal was last changed

datetime

2020-01-01T00:00:00.000+01:00

storeExternalId

Regular Store (External id)

string

123

createdInStoreExternalId

Recruited by store (ExternalId)

string

123

retail.keyvalue.purchaseamounttotal

Total purchase amount

decimal

1000.00

retail.keyvalue.numberofarticlepurchasestotal

Total number of purchased articles

decimal

10.00

retail.keyvalue.averagereceipttotal

Average receipt amount of all purchases

decimal

100.00

retail.keyvalue.latestreceiptdate

When the last purchase was made

datetime

2020-01-01T00:00:00.000+01:00

retail.keyvalue.purchasefrequencytotal

Total number of purchases

decimal

10.00

retail.keyvalue.purchaseamountlast12months

Total purchase amount the last 12 months

decimal

1000.00

retail.keyvalue. numberofarticlepurchaseslast12months

Total number of purchased articles the last 12 months

decimal

10.00

retail.keyvalue.averagereceiptlast12months

Average receipt amount on all purchases made the last 12 months

decimal

100.00

retail.keyvalue.purchasefrequencylast12months

Total number of purchases made the last 12 months

decimal

10.00

retail.keyvalue.purchaseamountlast24months

Total purchase amount the last 24 months

decimal

1000.00

retail.keyvalue. numberofarticlepurchaseslast24months

Total number of purchased articles the last 24 months

decimal

10.00

retail.keyvalue.averagereceiptlast24months

Average receipt amount on all purchases made the last 24 months

decimal

100.00

retail.keyvalue.purchasefrequencylast24months

Total number of purchases made the last 24 months

decimal

10.00