The following data can be exported from Ometria into an AWS S3 bucket.
See also: Self-serve data export
This information relates to your profiles in Ometria - profiles are not the same as contact records.
See also: Contacts and profiles
`null`
- this means Ometria has no data for that field.The following fields are passed for your contact records:
Field |
Type |
Description |
|
|
String |
The contact’s email address.
|
|
their_id |
String |
The contact’s Customer ID.
|
|
phone_number |
String |
The contact’s phone number, if known.
|
|
phone_number_country |
String |
The country the contact’s phone number is registered to.
|
|
preferred_lang |
String |
The contact's language, if known.
|
|
sms_allow_marketing |
Boolean |
Whether or not this contact is subscribed to receive SMS marketing.
|
|
sms_allow_transactional |
Boolean |
Whether or not this contact accepts transactional messages via SMS.
|
|
sms_dt_updated_marketing |
Time |
The date the contact updated their marketing preference for SMS.
|
|
sms_dt_updated_transactional |
Time |
The date the contact updated their transactional message preference for SMS.
|
|
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_domain |
String |
The domain name of the src_medium, e.g. yoursite.com, bing.com
|
|
src_terms |
String |
Any other source terms from the contact's first visit.
|
|
src_campaign |
String |
The source campaign of the contact's first visit - this can be any campaign, not just Ometria campaigns.
|
|
src_name |
String |
The source name of the contact's first visit, e.g. yahoo, google, facebook
|
|
is_identified |
Boolean |
Whether or not a visit record exists for this contact.
|
|
n_transactions |
Integer |
The number of recorded orders the contact has placed.
|
|
n_transactions_valid |
Integer |
The number of recorded valid orders the contact has placed.
|
|
n_items |
Integer |
The total number of items the contact has purchased from valid orders.
|
|
t_rev |
Float |
The total revenue for this contact, based on their valid orders. Refunded revenue is not included.
|
|
aov |
Float |
The contact's average order value.
|
|
n_devices |
Integer |
This is a legacy field which is no longer tracked in Ometria.
|
|
n_visits |
Integer |
The number of recorded visits from this contact.
|
|
ts_first_seen |
Integer |
This is a legacy field which is no longer tracked in Ometria.
|
|
ts_last_seen |
Integer |
This is a legacy field which is no longer tracked in Ometria.
|
|
ts_first_purchase |
Integer |
This is a legacy field which is no longer tracked in Ometria.
|
|
ts_last_purchase |
Integer |
This is a legacy field which is no longer tracked in Ometria.
|
|
is_source_captured |
Boolean |
|
|
status |
String |
This is a legacy field which is no longer tracked in Ometria.
|
|
country_id |
String |
The country associated with the contact.
|
|
name |
String |
The contact's full name.
|
|
firstname |
String |
The contact's first name.
|
|
lastname |
String |
The contact's last name/surname.
|
|
middlename |
String |
The contact's middle name.
|
|
suffix |
String |
The contact's name suffix, e.g. Jr, Snr, III, etc.
|
|
prefix |
String |
The contact's name prefix, e.g. Mr, Ms, Dr, etc.
|
|
ts_acquired |
Integer |
This is a legacy field which is no longer tracked in Ometria.
|
|
asrc_medium |
String |
This is a legacy field which is no longer tracked in Ometria.
|
|
asrc_domain |
String |
This is a legacy field which is no longer tracked in Ometria.
|
|
asrc_terms |
String |
This is a legacy field which is no longer tracked in Ometria.
|
|
asrc_campaign |
String |
This is a legacy field which is no longer tracked in Ometria.
|
|
asrc_name |
String |
This is a legacy field which is no longer tracked in Ometria.
|
|
is_asrc_captured |
Boolean |
This is a legacy field which is no longer tracked in Ometria.
|
|
src_content |
String |
The source contents of the contact's first visit - this is most relevant for visits via Ometria campaigns.
|
|
asrc_content |
String |
This is a legacy field which is no longer tracked in Ometria.
|
|
src_device_type |
String |
Source device type of the first visit by customer
|
|
asrc_device_type |
String |
This is a legacy field which is no longer tracked in Ometria.
|
|
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.
|
|
optout_reason |
String |
This is a legacy field which is no longer tracked in Ometria.
|
|
gender |
String |
The contact's gender, if known.
|
|
optin |
Boolean |
Whether or not the contact is opted in to receive email marketing.
|
|
dt_optin |
Time |
The date the contact opted in to receive email marketing messages.
|
|
dt_optout |
Time |
The date the contact opted out of receiving email marketing.
|
|
date_of_birth |
Time |
The contact's date of birth.
|
|
last_store |
String |
The store ID of the contact's last order.
|
|
last_channel |
String |
The channel through which the contact placed their last order, e.g. online, in store, mobile app.
|
|
first_store |
String |
The store ID of the contact's first order.
|
|
first_channel |
String |
The channel the contact used to place their first order, e.g. online, mobile app, etc.
|
|
last_order_city |
String |
The city location of the customer's last order.
|
|
last_order_state |
String |
The state location of the customer's last order.
|
|
last_order_postcode |
String |
The customer's postcode based on their last order.
|
|
last_order_country |
String |
The customer's country based on their last order.
|
|
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.
|
|
stores_ordered |
Array of strings |
A list of distinct stores through which the customer has placed valid orders.
|
|
channel_stores_ordered |
Array of strings |
A list of distinct channels and stores through which the customer has placed valid orders.
|
|
dt_account_created |
Time |
The date of the contact's first recorded visit.
|
|
dt_at_risk |
Time |
The date the customer's lifecycle status changed to 'at risk'.
|
|
dt_lapse |
Time |
The date the customer's lifecycle status changed to 'lapsed'.
|
|
dt_second_order |
Time |
The date the customer placed their second order.
|
|
dt_first_order |
Time |
The date the customer placed their first order.
|
|
dt_last_order |
Time |
The date of the customer's most recent order.
|
|
lifecycle_status |
String |
The contact's current lifecycle status.
|
|
dt_created |
Time |
The date and time this contact record was created in Ometria.
|
|
dt_updated |
Time |
The date and time the contact's record was last updated in Ometria.
|
|
dt_first_seen |
Time |
The timestamp of when the contact was first seen.
|
|
dt_last_seen |
Time |
The timestamp of when the contact was last seen.
|
|
dt_acquired |
Time |
The timestamp when the contact was first acquired. See: Contact acquired
|
|
is_suppressed |
Boolean |
Is the contact's email address on a suppression list?
|
|
timezone |
String |
The time zone associated with the contact.
|
|
is_email_valid |
Boolean |
Is the contact's email a valid email address?
|
|
default_store |
String |
The default store associated with the contact
|
|
is_pii_anonymised |
Boolean |
Is the contact's personal identifiable information (PII) anonymised?
|
|
push_notifications_enabled |
Boolean |
Does this contact have push notifications enabled for marketing messages?
|
|
dt_push_notifications_first_enabled |
Time |
The date and time the contact first enabled push notifications.
|
|
dt_push_notifications_first_disabled |
Time |
The date and time the contact first disabled push notifications.
|
|
dt_push_notifications_last_enabled |
Time |
The date and time the contact last enabled push notifications
|
|
dt_push_notifications_last_disabled |
Time |
The date and time the contact last disabled push notifications.
|
|
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.
|
Comments
0 comments
Article is closed for comments.