Data dictionary: Contact records

Field

Type

Description

email

String

The contact’s email address.

"email": "johnsmith@ometria.com

their_id

String

The contact’s Customer ID.

"their_id": "2319605"    

phone_number

String

The contact’s phone number, if known.

"phone_number": “+447123456789”

phone_number_country

String

The country the contact’s phone number is registered to.

"phone_number_country": “GB”

preferred_lang

String

The contact's language, if known.

"preferred_lang": “en-GB”

sms_allow_marketing

Boolean

Whether or not this contact is subscribed to receive SMS marketing. 

"sms_allow_marketing": null

sms_allow_transactional

Boolean

Whether or not this contact accepts transactional messages via SMS.

"sms_allow_transactional": null

sms_dt_updated_marketing

Time

The date the contact updated their marketing preference for SMS.

"sms_dt_updated_marketing": null

sms_dt_updated_transactional

Time

The date the contact updated their transactional message preference for SMS.

"sms_dt_updated_transactional": null

src_medium

String

The medium the contact clicked through before arriving on your site for their first visit, e.g. search, cpc, social etc.

"src_medium": "search"

src_domain

String

The domain name of the src_medium, e.g. yoursite.com, bing.com

"src_domain": "search.yahoo.com"

src_terms

String

Any other source terms from the contact's first visit.

"src_terms": "fashion items"

src_campaign

String

The source campaign of the contact's first visit - this can be any campaign, not just Ometria campaigns.

"src_campaign": null

src_name

String

The source name of the contact's first visit, e.g. yahoo, google, facebook

"src_name": "yahoo"

is_identified

Boolean

Whether or not a visit record exists for this contact.

"is_identified":"truefalse"

n_transactions

Integer

The number of recorded orders the contact has placed.

"n_transactions": 4

n_transactions_valid

Integer

The number of recorded valid orders the contact has placed. 

"n_transactions_valid": 4

n_items

Integer

The total number of items the contact has purchased from valid orders.

"n_items": 4

t_rev

Float

The total revenue for this contact, based on their valid orders. 

Refunded revenue is not included.

"t_rev": 597.00

aov

Float

The contact's average order value.

"aov": 149.48

n_devices

Integer

This is a legacy field which is no longer tracked in Ometria.

"n_devices": 0

n_visits

Integer

The number of recorded visits from this contact.

"n_visits": 12

ts_first_seen

Integer

This is a legacy field which is no longer tracked in Ometria.

"ts_first_seen": 1491656585

ts_last_seen

Integer

This is a legacy field which is no longer tracked in Ometria.

"ts_last_seen": 1507573366

ts_first_purchase

Integer

This is a legacy field which is no longer tracked in Ometria.

"ts_first_purchase": 1507573413

ts_last_purchase

Integer

This is a legacy field which is no longer tracked in Ometria.

"ts_last_purchase": 1507573413

is_source_captured

Boolean

True if the contact's first visit source is known, False if it isn't.

"is_source_captured": "true"

status

String

This is a legacy field which is no longer tracked in Ometria.

"status": "null"

country_id

String

The country associated with the contact.

"country_id": "GB"

name

String

The contact's full name.

"name": "John Smith"

firstname

String

The contact's first name.

"firstname": "John"

lastname

String

The contact's last name/surname.

"lastname": "Smith"

middlename

String

The contact's middle name.

"middlename": "David"

suffix

String

The contact's name suffix, e.g. Jr, Snr, III, etc.

"suffix": null

prefix

String

The contact's name prefix, e.g. Mr, Ms, Dr, etc.

"prefix": "Mr"

ts_acquired

Integer

This is a legacy field which is no longer tracked in Ometria.

"ts_acquired": null

asrc_medium

String

This is a legacy field which is no longer tracked in Ometria.

"asrc_medium": null

asrc_domain

String

This is a legacy field which is no longer tracked in Ometria.

"asrc_domain": null

asrc_terms

String

This is a legacy field which is no longer tracked in Ometria.

"asrc_terms": null

asrc_campaign

String

This is a legacy field which is no longer tracked in Ometria.

"asrc_campaign": null

asrc_name

String

This is a legacy field which is no longer tracked in Ometria.

"asrc_name": null

is_asrc_captured

Boolean

This is a legacy field which is no longer tracked in Ometria.

"is_asrc_captured": null

src_content

String

The source contents of the contact's first visit - this is most relevant for visits via Ometria campaigns.

"src_content": “bulk”

asrc_content

String

This is a legacy field which is no longer tracked in Ometria.

"asrc_content": null

src_device_type

String

Source device type of the first visit by customer

"src_device_type": "computer"

asrc_device_type

String

This is a legacy field which is no longer tracked in Ometria.

"asrc_device_type": null

dt_contact_acquired

Time

The timestamp for when the contact was first acquired.

This is a legacy field which is no longer tracked in Ometria.

"dt_contact_acquired": "2017-01-16 11:48:05.928599+00"

optout_reason

String

This is a legacy field which is no longer tracked in Ometria.

"optout_reason": null

gender

String

The contact's gender, if known. 

"gender": "m"

optin

Boolean

Whether or not the contact is opted in to receive email marketing. 

"optin": t

dt_optin

Time

The date the contact opted in to receive email marketing messages. 

"dt_optin": "2017-01-16 11:48:05.1+00"

dt_optout

Time

The date the contact opted out of receiving email marketing.

"dt_optout": null

date_of_birth

Time

The contact's date of birth. 

"date_of_birth": "1985-01-05"

last_store

String

The store ID of the contact's last order.

"last_store": 1

last_channel

String

The channel through which the contact placed their last order, e.g. online, in store, mobile app. 

"last_channel": "online"

first_store

String

The store ID of the contact's first order.

"first_store": 1

first_channel

String

The channel the contact used to place their first order, e.g. online, mobile app, etc. 

"first_channel": "online"

last_order_city

String

The city location of the customer's last order. 

"last_order_city": “bath”

last_order_state

String

The state location of the customer's last order.

"last_order_state": null

last_order_postcode

String

The customer's postcode based on their last order.

"last_order_postcode": “ba17sn”

last_order_country

String

The customer's country based on their last order.

"last_order_country": “GB”

channels_ordered

Array of strings

A list of distinct channels through which the customer has placed valid orders, e.g. online, mobile app, in store, etc.

"channels_ordered": {"online"}

stores_ordered

Array of strings

A list of distinct stores through which the customer has placed valid orders.

"stores_ordered": {1}

channel_stores_ordered

Array of strings

A list of distinct channels and stores  through which the customer has placed valid orders. 

"channel_stores_ordered": {"online"/1,NULL}

dt_account_created

Time

The date of the contact's first recorded visit. 

"dt_account_created": "2017-01-16 11:48:05.928599+00"

dt_at_risk

Time

The date the customer's lifecycle status changed to 'at risk'.

"dt_at_risk": "2020-05-30 23:27:51+00"

dt_lapse

Time

The date the customer's lifecycle status changed to 'lapsed'.

"dt_lapse": "2020-08-17 23:27:51+00"

dt_second_order

Time

The date the customer placed their second order. 

"dt_second_order": "2018-03-26 14:08:38+00"

dt_first_order

Time

The date the customer placed their first order.

"dt_first_order": "2017-10-09 18:23:33+00"

dt_last_order

Time

The date of the customer's most recent order.

"dt_last_order": "2020-05-09 23:27:51+00"

lifecycle_status

String

The contact's current lifecycle status.

"lifecycle_status": "ACTIVE"

dt_created

Time

The date and time this contact record was created in Ometria.

"dt_created": "2017-04-08 13:34:05.319819+00"

dt_updated

Time

The date and time the contact's record was last updated in Ometria.

"dt_updated": "2021-07-03 17:35:31.638753+00"

dt_first_seen

Time

The timestamp of when the contact was first seen.

"dt_first_seen": "2017-04-08 13:03:05+00"

dt_last_seen

Time

The timestamp of when the contact was last seen.

"dt_last_seen": "2021-07-03 17:04:11+00"

dt_acquired

Time

The timestamp when the contact was first acquired.

See: Contact acquired

"dt_acquired": "2017-04-08 13:03:05+00"

is_suppressed

Boolean

Is the contact's email address on a suppression list?

"is_suppressed": "f”

timezone

String

The time zone associated with the contact. 

"timezone": "Europe/Dublin"

is_email_valid

Boolean

Is the contact's email a valid email address?

"is_email_valid": t

default_store

String

The default store associated with the contact

"default_store": 1

is_pii_anonymised

Boolean

Is the contact's personal identifiable information (PII) anonymised?

"is_pii_anonymised": f

push_notifications_enabled

Boolean

Does this contact have push notifications enabled for marketing messages?

"push_notifications_enabled": t

dt_push_notifications_first_enabled

Time

The date and time the contact first enabled push notifications.

"dt_push_notifications_first_enabled": “2021-06-06 10:48:28.242995+00”

dt_push_notifications_first_disabled

Time

The date and time the contact  first disabled push notifications.

"dt_push_notifications_first_disabled": “2021-06-06 12:15:42.229069+00”

dt_push_notifications_last_enabled

Time

The date and time the contact last enabled push notifications

"dt_push_notifications_last_enabled": “2021-09-28 12:43:37.009856+00”

dt_push_notifications_last_disabled

Time

The date and time the contact last disabled push notifications.

"dt_push_notifications_last_disabled": null

properties

json

A json object of all the custom fields associated with this contact.

segments

Array of strings

A list of the names of each segment this contact belongs to.