Skip to main content

Data export examples

Louise MacBean
  • Updated

The following data can be exported from Ometria into an AWS S3 bucket.

See: Self-serve data export

This page contains examples of the data you might receive. For full definitions of individual fields, see our data dictionaries:

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"
}

Related articles

Comments

0 comments

Please sign in to leave a comment.