Data dictionary: Contact records – Ometria Help Centre

You can create a regular, scheduled data export from Ometria to an AWS S3 bucket, Databricks, Google Cloud, Microsoft Azure, or an SFTP you host.

See also: Customised data export

Contact records contain data about your Ometria contacts (customers, contacts, leads and subscribers).

Ometria merges contact records into profiles to create a single customer view.

This means that a profile is often the result of multiple contact records.

Think of the contact records in your data export as updates to a profile, rather than the profile itself - so there can be multiple records for the same customer in one export.

See also: Contacts and profiles

Note: Empty fields are passed as `null` - this means Ometria has no data for that field.

If you'd like to set up a data export please get in touch with your Customer Success Representative.

The following fields are passed for your 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"`
profile_hash	String	A unique, encoded identifier for a contact's profile, sometimes called a profile ID. `"profile_hash": "8cdcf152e871646a"`
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":"true"`
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": "2025-05-09 23:27:51+00"`
dt_predicted_next_order	Time	The contact's predicted next purchase date. `"dt_predicted_next_order": "2026-04-01 08:00:00+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. Note: A contact entering or exiting a segment is not considered a change to the contact's record. This means if a contact is added to a new segment and no other changes occur to the record they will not be included in the daily export.

Related articles