The following data can be exported from Ometria into an AWS S3 bucket.
If you'd like to set up a data export please get in touch with your Customer Success Representative.
See also: Self-serve data export
This page contains examples of the data you might receive. For full definitions of individual fields, see our data dictionaries:
- Data export dictionary: Contact records
- Data export dictionary: Email events
- Data export dictionary: Website interaction events
Contact records
This information relates to your contacts in Ometria.
For full definitions of each field, see the Data dictionary: Contact records.
The following fields are passed for your contact records:
{
"email": "johnsmith@ometria.com"
"their_id": "2319605"
"phone_number": null
"phone_number_country": null
"preferred_lang": en-GB
"sms_allow_marketing": null
"sms_allow_transactional": null
"sms_dt_updated_marketing": null
"sms_dt_updated_transactional": null
"src_medium": "search"
"src_domain": "search.yahoo.com"
"src_terms": "fashion items"
"src_campaign": null
"src_name": "yahoo"
"is_identified":"false"
"n_transactions": 4
"n_transactions_valid": 4
"n_items": 4
"t_rev": 597.00
"aov": 149.48
"n_devices": 0
"n_visits": 12
"ts_first_seen": 1491656585
"ts_last_seen": 1507573366
"ts_first_purchase": 1507573413
"ts_last_purchase": 1507573413
"is_source_captured": "false"
"status": "null"
"country_id": "GB"
"name": "John Smith"
"firstname": "John"
"lastname": "Smith"
"middlename": null
"suffix": null
"prefix": null
"ts_acquired": null
"asrc_medium": null
"asrc_domain": null
"asrc_terms": null
"asrc_campaign": null
"asrc_name": null
"is_asrc_captured": null
"src_content": null
"asrc_content": null
"src_device_type": "computer"
"asrc_device_type": null
"dt_contact_acquired": "2017-01-16 11:48:05.928599+00"
"optout_reason": null
"gender": "m"
"optin": t
"dt_optin": "2017-01-16 11:48:05.1+00"
"dt_optout": null
"date_of_birth": "1985-01-05"
"last_store": 1
"last_channel": "online"
"first_store": 1
"first_channel": "online"
"last_order_city": null
"last_order_state": null
"last_order_postcode": null
"last_order_country": null
"channels_ordered": {"online"}
"stores_ordered": {1}
"channel_stores_ordered": {"online"/1,NULL}
"dt_account_created": "2017-01-16 11:48:05.928599+00"
"dt_at_risk": "2020-05-30 23:27:51+00"
"dt_lapse": "2020-08-17 23:27:51+00"
"dt_second_order": "2018-03-26 14:08:38+00"
"dt_first_order": "2017-10-09 18:23:33+00",
"dt_first_order": "2017-10-09 18:23:33+00"
"dt_last_order": "2020-05-09 23:27:51+00"
"lifecycle_status": "ACTIVE"
"dt_created": "2017-04-08 13:34:05.319819+00"
"dt_updated": "2021-07-03 17:35:31.638753+00"
"dt_first_seen": "2017-04-08 13:03:05+00"
"dt_last_seen": "2021-07-03 17:04:11+00"
"dt_acquired": "2017-04-08 13:03:05+00"
"is_suppressed": null
"timezone": "Europe/Dublin"
"is_email_valid": t
"default_store": 1
"is_pii_anonymised": null
"push_notifications_enabled": null
"dt_push_notifications_first_enabled": null
"dt_push_notifications_first_disabled": null
"dt_push_notifications_last_enabled": null
"dt_push_notifications_last_disabled": null
}
Email events
This information relates to your email sends, e.g. clicks, opens etc.
For full definitions of each field, see the Data export dictionary: Email events.
Bounce
The mail server has permanently rejected a message.
{
"event_id": 66699836223080149
"uuid": "0f3fa2ee4c1045e1b979b31ea55397d4"
"to_address": "sample@ometria.com"
"event_type": "bounce"
"bounce_class": 52
"reason": "Bounce reason:Your email was detected as spam."
"dt_occurred": "2017-11-01T12:13:16+00:00"
"device_type": null
"geo_country": null
"geo_region": null
"geo_city": null
"geo_timezone": null
"target_url": null
"campaign_title": "Your Campaign Name"
"campaign_type": "BROADCAST",
"variant_name": "Variation B"
}
Click
The recipient clicked a tracked link in an email.
{
"event_id": 123456789
"uuid": "ca9a8becec064ccb8cc3a7315116be05"
"to_address": "sample@ometria.co.uk"
"event_type": "click"
"bounce_class": null
"reason": null
"dt_occurred": "2017-11-01T13:19:32+00:00"
"device_type": "tablet"
"geo_country": "GB"
"geo_region": "F8"
"geo_city": "London"
"geo_timezone": "Europe/London"
"target_url": "https://www.ometria.co.uk"
"campaign_title": "Your Campaign Name"
"campaign_type": "AUTOMATION"
}
Delay
The recipient mail server rejected the email for a temporary reason and Ometria will re-attempt delivery.
{
"event_id": 123456789
"uuid": "ca9a8becec064ccb8cc3a7315116be05"
"to_address": "sample@ometria.co.uk"
"event_type": "click"
"bounce_class": null
"reason": null
"dt_occurred": "2017-11-01T13:19:32+00:00"
"device_type": "tablet"
"geo_country": "GB"
"geo_region": "F8"
"geo_city": "London"
"geo_timezone": "Europe/London"
"target_url": "https://www.ometria.co.uk"
"campaign_title": "Your Campaign Name"
"campaign_type": "AUTOMATION"
}
Delivery
The mail server acknowledged receipt of an email.
{
"event_id": 48685442134979123
"uuid": "569566a7e76b4a05a127d2fc059c7c5c"
"to_address": "sample@ometria.com"
"event_type": "delivery"
"bounce_class": null
"reason": null
"dt_occurred": "2017-11-01T13:27:45+00:00"
"device_type": null
"geo_country": null
"geo_region": null
"geo_city": null
"geo_timezone": null
"target_url": null
"campaign_title": "Your Campaign Name"
"campaign_type": "BROADCAST",
"variant_name": "Variation A - winner"
}
Injection
The email has been received by the mail server.
{
"event_id": 48685442134979093,
"uuid": "569566a7e76b4a05a127d2fc059c7c5c",
"to_address": "aaa@example.com",
"event_type": "injection",
"bounce_class": null,
"reason": null,
"dt_occurred": "2019-05-28T00:00:17+00:00",
"device_type": null,
"geo_country": null,
"geo_region": null,
"geo_city": null,
"geo_timezone": null,
"target_url": null,
"campaign_title": "Your Campaign Name"
"campaign_type": "BROADCAST”
"variant_name": "Variation A"
}
Open
The recipient opened a message in an email client.
{
"event_id": 123456789,
"uuid": "0abfd082876948fa97a2ca4df00a3aa8",
"to_address": "aaa@example.com",
"event_type": "open",
"bounce_class": null,
"reason": null,
"dt_occurred": "2019-04-28T00:00:17+00:00",
"device_type": "computer",
"geo_country": "KR",
"geo_region": "11",
"geo_city": "Seoul",
"geo_timezone": "Asia/Seoul",
"target_url": null,
"campaign_title": "Test campaign 4133",
"campaign_type": "AUTOMATION"
}
Website interaction
These are the events Ometria receives from the JavaScript tracker on your website, relating to visitor behaviour such as clicks, identification, abandoned baskets etc.
Add to basket
The visitor has updated their basket by clicking ‘Add to basket’ (or similar).
{
"cookie_id": "QMKijeQA0S39iwV2"
"session_id": "1a780334my3xelP8cB82"
"total_visits": null
"ecamp": ""
"url": "http://www.ometria.com/URL"
"site": ""
"pages_viewed": 3
"event_type": "addtobasket"
"dt_occurred": "2016-10-25T21:22:41"
"ip": "86.23.6.162"
"ips": "86.23.6.162"
"geo_country_id": "GB"
"geo_lat": 51.5
"geo_long": -0.13
"device_sig": "a1921d2f3cbfdfd7797b5e4d2df7e342"
"data_referring_url": ""
"data_page_type": ""
"data_product_id": ""
"data_order_id": ""
"source_medium": ""
"source_domain": ""
"source_name": ""
"source_terms": ""
"dev_user_agent": "Mozilla/5.0 (iPad; CPU OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML like Gecko) Version/9.0 Mobile/13G36 Safari/601.1"
"dev_user_agent_type": "tablet"
"dev_user_agent_platform": "ipad"
"dev_user_agent_name": "ipad"
"dev_user_agent_name_version": "ipad/9"
"dev_is_bot": false
"dev_is_touch": true
"dev_screen_size": "768x1024"
"server_ip": "ip-10-0-2-122"
"uiid": null
"geo_region": null
"tz": null
"hashed_uiid": null
"pageview_id": "DpxqCNJlhPUFZ8zi"
}
Checkout
The visitor has navigated to the checkout page.
{
"cookie_id": "QMKijeQA0S39iwV2"
"session_id": "1a780334my3xelP8cB82"
"total_visits": null
"ecamp": ""
"url": "http://www.ometria.com/URL"
"site": ""
"pages_viewed": 6
"event_type": "checkout"
"dt_occurred": "2016-10-25T21:23:38"
"ip": "86.23.6.162"
"ips": "86.23.6.162"
"geo_country_id": "GB"
"geo_lat": 51.5
"geo_long": -0.13
"device_sig": "a1921d2f3cbfdfd7797b5e4d2df7e342"
"data_referring_url": ""
"data_page_type": ""
"data_product_id": ""
"data_order_id": ""
"source_medium": ""
"source_domain": ""
"source_name": ""
"source_terms": ""
"dev_user_agent": "Mozilla/5.0 (iPad; CPU OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML like Gecko) Version/9.0 Mobile/13G36 Safari/601.1"
"dev_user_agent_type": "tablet"
"dev_user_agent_platform": "ipad"
"dev_user_agent_name": "ipad"
"dev_user_agent_name_version": "ipad/9"
"dev_is_bot": false
"dev_is_touch": true
"dev_screen_size": "768x1024"
"server_ip": "ip-10-0-3-102"
"uiid": null
"geo_region": null
"tz": null
"hashed_uiid": null
"pageview_id": "69u6eo71vNvvFs22"
}
Identify
The visitor has been identified on your website.
{
"cookie_id": "QMKijeQA0S39iwV2"
"session_id": "1a780334my3xelP8cB82"
"total_visits": null
"ecamp": ""
"url": "http://www.ometria.com/URL"
"site": ""
"pages_viewed": 6
"event_type": "identify"
"dt_occurred": "2016-10-25T21:23:38"
"ip": "86.23.6.162"
"ips": "86.23.6.162"
"geo_country_id": "GB"
"geo_lat": 51.5
"geo_long": -0.13
"device_sig": "a1921d2f3cbfdfd7797b5e4d2df7e342"
"data_referring_url": ""
"data_page_type": ""
"data_product_id": ""
"data_order_id": ""
"source_medium": ""
"source_domain": ""
"source_name": ""
"source_terms": ""
"dev_user_agent": "Mozilla/5.0 (iPad; CPU OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML like Gecko) Version/9.0 Mobile/13G36 Safari/601.1"
"dev_user_agent_type": "tablet"
"dev_user_agent_platform": "ipad"
"dev_user_agent_name": "ipad"
"dev_user_agent_name_version": "ipad/9"
"dev_is_bot": false
"dev_is_touch": true
"dev_screen_size": "768x1024"
"server_ip": "ip-10-0-3-102"
"uiid": null
"geo_region": null
"tz": null
"hashed_uiid": null
"pageview_id": "69u6eo71vNvvFs22"
}
Page view
The visitor has viewed a page on your site.
This includes search results, listings of products in a group, category, collection or any other page that presents a list of products.
{
"cookie_id": "PRItNEYt2CwDA5eI"
"session_id": "1a7803349OhIvCDZtivI"
"total_visits": null
"ecamp": ""
"url": "http://www.ometria.com/urlhere"
"site": ""
"pages_viewed": 1
"event_type": "pageview"
"dt_occurred": "2018-10-25T12:29:56"
"ip": "93.152.98.217"
"ips": "93.152.98.217"
"geo_country_id": "GB"
"geo_lat": 51.5
"geo_long": -0.13
"device_sig": "b123458683921"
"data_referring_url": ""
"data_page_type": "confirmation"
"data_product_id": ""
"data_order_id": ""
"source_medium": ""
"source_domain": ""
"source_name": ""
"source_terms": ""
"dev_user_agent": "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML like Gecko) Chrome/53.0.2785.143 Safari/537.36"
"dev_user_agent_type": "computer"
"dev_user_agent_platform": "windows"
"dev_user_agent_name": "chrome"
"dev_user_agent_name_version": "chrome/53"
"dev_is_bot": false
"dev_is_touch": false
"dev_screen_size": "1920x1080"
"server_ip": "ip-10-0-2-122"
"uiid": null
"geo_region": null
"tz": null
"hashed_uiid": null
"pageview_id": "6a18AElfkXPCzi6I"
}
Set basket
The visitor has updated their basket.
{
"cookie_id": "tRQTj80HNDfd9S5I"
"session_id": "1a780334mAXDiutbuzI"
"total_visits": null
"ecamp": ""
"url": "http://www.ometria.com/URL"
"site": ""
"pages_viewed": 22
"event_type": "setbasket"
"dt_occurred": "2016-10-25T20:26:51"
"ip": "82.13.31.152"
"ips": "82.13.31.152"
"geo_country_id": "GB"
"geo_lat": 52.9282
"geo_long": -1.1642
"device_sig": "4a7aec95bf73cd272d3e58eaee68353I"
"data_referring_url": ""
"data_page_type": ""
"data_product_id": ""
"data_order_id": ""
"source_medium": "search"
"source_domain": "google.co.uk"
"source_name": "google"
"source_terms": "not_supplied"
"dev_user_agent": "Mozilla/5.0 (X11; CrOS x86_64 8530.96.0) AppleWebKit/537.36 (KHTML like Gecko) Chrome/53.0.2785.154 Safari/537.36"
"dev_user_agent_type": "computer"
"dev_user_agent_platform": "unknown"
"dev_user_agent_name": "chrome"
"dev_user_agent_name_version": "chrome/53"
"dev_is_bot": false
"dev_is_touch": false
"dev_screen_size": "1366x768"
"server_ip": "ip-10-0-2-122"
"uiid": null
"geo_region": null
"tz": null
"hashed_uiid": null
"pageview_id": "bQopedNJtOXsNZVi"
}
Transaction
The visitor has successfully placed an order.
{
"cookie_id": "tRQTj80HNDfd9S5i"
"session_id": "1a780334mAXDiutbuzZI"
"total_visits": null
"ecamp": ""
"url": "http://www.ometria.com/URL"
"site": ""
"pages_viewed": 37
"event_type": "transaction"
"dt_occurred": "2016-10-25T20:44:32"
"ip": "82.13.31.152"
"ips": "82.13.31.152"
"geo_country_id": "GB"
"geo_lat": 52.9286
"geo_long": -1.1648
"device_sig": "4a7aec95bf73cd272d3e58eaee68353i"
"data_referring_url": ""
"data_page_type": ""
"data_product_id": ""
"data_order_id": "TENM309982"
"source_medium": "search"
"source_domain": "google.co.uk"
"source_name": "google"
"source_terms": "not_supplied"
"dev_user_agent": "Mozilla/5.0 (X11; CrOS x86_64 8530.96.0) AppleWebKit/537.36 (KHTML like Gecko) Chrome/53.0.2785.154 Safari/537.36"
"dev_user_agent_type": "computer"
"dev_user_agent_platform": "unknown"
"dev_user_agent_name": "chrome"
"dev_user_agent_name_version": "chrome/53"
"dev_is_bot": false
"dev_is_touch": false
"dev_screen_size": "1366x768"
"server_ip": "ip-10-0-2-129"
"uiid": null
"geo_region": null
"tz": null
"hashed_uiid": null
"pageview_id": "e651cGewG4NSCbSI"
}
Comments
0 comments
Article is closed for comments.