Column Name Type Description Notes/Examples
event_uuid VARCHAR(40) event id ignore
app_id NUMBER(38,0) Application Id 40239
app_name VARCHAR(40) Application name NewsPulse
localytics_device_id VARCHAR(40) Device Identifier afe51163a4a9e6d706f544907e2f41a8179fa18f
customer_id VARCHAR(255) Customer_id as assigned by customer or Localytics analyst@localytics.com
hashed_customer_id VARCHAR(40) Hashed customer_id e92cd0d658aaa5575fd73124197196b49b64d1b8
advertising_id VARCHAR(40) Advertising identifier 233c5-d-e7208d-14d2286344e38-fa1fd3a
is_anonymous_customer BOOLEAN Boolean flag for anonymous customer id TRUE
sdk_version VARCHAR(128) Localytics SDK version iOSa_3.6.1
app_version VARCHAR(64) App Version 5.1.1
device_platform VARCHAR(32) Device Platform iPhone, Android
device_language VARCHAR(2) SO 639-1 code en
device_make VARCHAR(64) Device Make Samsung
device_model VARCHAR(64) Device Model Galaxy S7
device_os_version VARCHAR(64) Device OS Version  
is_new_device BOOLEAN Flag attached to device for first session and all events on the first session FALSE
device_timezone NUMBER(38,0) Device timezone offset in seconds 3600
is_jailbroken BOOLEAN Boolean indicating weather the phone is jailbroken FALSE
browser_id NUMBER(38,0) Browser Id lookup in browsers table
device_carrier VARCHAR(64) Network Verizon Wireless
data_connection VARCHAR(32) Device on WiFi vs. data connection wifi
country VARCHAR(2) ISO 3166-1 alpha-2 code US
region VARCHAR(3) SO 3166-2 code MA
city_id NUMBER(38,0) City id joins on cities on city = cities.id
metro_id NUMBER(38,0) Metro id joins on metro_codes on metro = metro_codes.id
client_date DATE The date in the App timezone that the datapoint was created at 42741
client_time TIMESTAMP_LTZ(3) The time in the App timezone that the datapoint was created at Mon, 17 Apr 2017 09:48:48 +0000
client_time_utc TIMESTAMP_LTZ(9) Client_time in UTC Mon, 17 Apr 2017 13:48:48 +0000
session_uuid VARCHAR(40) Id of session during event occurred c278b361aa923745285849be0dd15b09300747cd7
event_name VARCHAR(128) Event name “Friend Added”
first_session_date DATE client_date of the first processed session for this device ‘2017-01-05’
is_push_enabled BOOLEAN Push enabled boolean at time of event TRUE
cumulative_number_sessions NUMBER(38,0) Total number of sessions for device 10
custom_0 VARCHAR(128) Custom Dimension 0 Look up in localytics_custom_dimensions
custom_1 VARCHAR(128) Custom Dimension 1  
custom_2 VARCHAR(128) Custom Dimension 2  
custom_3 VARCHAR(128) Custom Dimension 3  
custom_4 VARCHAR(128) Custom Dimension 4  
custom_5 VARCHAR(128) Custom Dimension 5  
custom_6 VARCHAR(128) Custom Dimension 6  
custom_7 VARCHAR(128) Custom Dimension 7  
custom_8 VARCHAR(128) Custom Dimension 8  
custom_9 VARCHAR(128) Custom Dimension 9  
custom_10 VARCHAR(128) Custom Dimension 10  
custom_11 VARCHAR(128) Custom Dimension 11  
custom_12 VARCHAR(128) Custom Dimension 12  
custom_13 VARCHAR(128) Custom Dimension 13  
custom_14 VARCHAR(128) Custom Dimension 14  
custom_15 VARCHAR(128) Custom Dimension 15  
custom_16 VARCHAR(128) Custom Dimension 16  
custom_17 VARCHAR(128) Custom Dimension 17  
custom_18 VARCHAR(128) Custom Dimension 18  
custom_19 VARCHAR(128) Custom Dimension 19  
total_ltv NUMBER(38,0) Sum of all clv_change values at write time 1000
ltv_change NUMBER(38,0) Change in CLV/LTV 5000
attr_0 VARCHAR(255) Event Attribute 0 “SportsSection”
attr_1 VARCHAR(255) Event Attribute 1  
attr_2 VARCHAR(255) Event Attribute 2  
attr_3 VARCHAR(255) Event Attribute 3  
attr_4 VARCHAR(255) Event Attribute 4  
attr_5 VARCHAR(255) Event Attribute 5  
attr_6 VARCHAR(255) Event Attribute 6  
attr_7 VARCHAR(255) Event Attribute 7  
attr_8 VARCHAR(255) Event Attribute 8  
attr_9 VARCHAR(255) Event Attribute 9  
attr_10 VARCHAR(255) Event Attribute 10  
attr_11 VARCHAR(255) Event Attribute 11  
attr_12 VARCHAR(255) Event Attribute 12  
attr_13 VARCHAR(255) Event Attribute 13  
attr_14 VARCHAR(255) Event Attribute 14  
attr_15 VARCHAR(255) Event Attribute 15  
attr_16 VARCHAR(255) Event Attribute 16  
attr_17 VARCHAR(255) Event Attribute 17  
attr_18 VARCHAR(255) Event Attribute 18  
attr_19 VARCHAR(255) Event Attribute 19  
attr_20 VARCHAR(255) Event Attribute 20  
attr_21 VARCHAR(255) Event Attribute 21  
attr_22 VARCHAR(255) Event Attribute 22  
attr_23 VARCHAR(255) Event Attribute 23  
attr_24 VARCHAR(255) Event Attribute 24  
attr_25 VARCHAR(255) Event Attribute 25  
attr_26 VARCHAR(255) Event Attribute 26  
attr_27 VARCHAR(255) Event Attribute 27  
attr_28 VARCHAR(255) Event Attribute 28  
attr_29 VARCHAR(255) Event Attribute 29  
attr_30 VARCHAR(255) Event Attribute 30  
attr_31 VARCHAR(255) Event Attribute 31  
attr_32 VARCHAR(255) Event Attribute 32  
attr_33 VARCHAR(255) Event Attribute 33  
attr_34 VARCHAR(255) Event Attribute 34  
attr_35 VARCHAR(255) Event Attribute 35  
attr_36 VARCHAR(255) Event Attribute 36  
attr_37 VARCHAR(255) Event Attribute 37  
attr_38 VARCHAR(255) Event Attribute 38  
attr_39 VARCHAR(255) Event Attribute 39  
attr_40 VARCHAR(255) Event Attribute 40  
attr_41 VARCHAR(255) Event Attribute 41  
attr_42 VARCHAR(255) Event Attribute 42  
attr_43 VARCHAR(255) Event Attribute 43  
attr_44 VARCHAR(255) Event Attribute 44  
attr_45 VARCHAR(255) Event Attribute 45  
attr_46 VARCHAR(255) Event Attribute 46  
attr_47 VARCHAR(255) Event Attribute 47  
attr_48 VARCHAR(255) Event Attribute 48  
attr_49 VARCHAR(255) Event Attribute 49  
n_attr_1 NUMBER(18,5) Event Numeric Attribute 0  
n_attr_2 NUMBER(18,5) Event Numeric Attribute 1 10
n_attr_3 NUMBER(18,5) Event Numeric Attribute 2  
n_attr_4 NUMBER(18,5) Event Numeric Attribute 3  
n_attr_5 NUMBER(18,5) Event Numeric Attribute 4  
n_attr_6 NUMBER(18,5) Event Numeric Attribute 5  
n_attr_7 NUMBER(18,5) Event Numeric Attribute 6  
n_attr_8 NUMBER(18,5) Event Numeric Attribute 7  
n_attr_9 NUMBER(18,5) Event Numeric Attribute 8  
n_attr_10 NUMBER(18,5) Event Numeric Attribute 9  
n_attr_11 NUMBER(18,5) Event Numeric Attribute 10  
n_attr_12 NUMBER(18,5) Event Numeric Attribute 11  
n_attr_13 NUMBER(18,5) Event Numeric Attribute 12  
n_attr_14 NUMBER(18,5) Event Numeric Attribute 13  
n_attr_15 NUMBER(18,5) Event Numeric Attribute 14  
n_attr_16 NUMBER(18,5) Event Numeric Attribute 15  
n_attr_17 NUMBER(18,5) Event Numeric Attribute 16  
n_attr_18 NUMBER(18,5) Event Numeric Attribute 17  
n_attr_19 NUMBER(18,5) Event Numeric Attribute 18  
n_attr_20 NUMBER(18,5) Event Numeric Attribute 19  
n_attr_21 NUMBER(18,5) Event Numeric Attribute 20  
n_attr_22 NUMBER(18,5) Event Numeric Attribute 21  
n_attr_23 NUMBER(18,5) Event Numeric Attribute 22  
n_attr_24 NUMBER(18,5) Event Numeric Attribute 23  
n_attr_25 NUMBER(18,5) Event Numeric Attribute 24  
n_attr_26 NUMBER(18,5) Event Numeric Attribute 25  
n_attr_27 NUMBER(18,5) Event Numeric Attribute 26  
n_attr_28 NUMBER(18,5) Event Numeric Attribute 27  
n_attr_29 NUMBER(18,5) Event Numeric Attribute 28  
n_attr_30 NUMBER(18,5) Event Numeric Attribute 29  
n_attr_31 NUMBER(18,5) Event Numeric Attribute 30  
n_attr_32 NUMBER(18,5) Event Numeric Attribute 31  
n_attr_33 NUMBER(18,5) Event Numeric Attribute 32  
n_attr_34 NUMBER(18,5) Event Numeric Attribute 33  
n_attr_35 NUMBER(18,5) Event Numeric Attribute 34  
n_attr_36 NUMBER(18,5) Event Numeric Attribute 35  
n_attr_37 NUMBER(18,5) Event Numeric Attribute 36  
n_attr_38 NUMBER(18,5) Event Numeric Attribute 37  
n_attr_39 NUMBER(18,5) Event Numeric Attribute 38  
n_attr_40 NUMBER(18,5) Event Numeric Attribute 39  
n_attr_41 NUMBER(18,5) Event Numeric Attribute 40  
n_attr_42 NUMBER(18,5) Event Numeric Attribute 41  
n_attr_43 NUMBER(18,5) Event Numeric Attribute 42  
n_attr_44 NUMBER(18,5) Event Numeric Attribute 43  
n_attr_45 NUMBER(18,5) Event Numeric Attribute 44  
n_attr_46 NUMBER(18,5) Event Numeric Attribute 45  
n_attr_47 NUMBER(18,5) Event Numeric Attribute 46  
n_attr_48 NUMBER(18,5) Event Numeric Attribute 47  
n_attr_49 NUMBER(18,5) Event Numeric Attribute 48  
n_attr_50 NUMBER(18,5) Event Numeric Attribute 49  
created_at TIMESTAMP_LTZ(3) Time in the App timezone that the datapoint was ingested Fri, 06 Jan 2017 10:31:38 +0000
attributes OBJECT JSON object with event attributes {“Purchase Amount”: 100, “Item Category”: “Swimwear”}
custom_dimensions OBJECT JSON object with custom dimensions {“Subscriber Type”: “Premium”, “City”: “Boston”}