Column Name Type Description Notes/Examples
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_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 attached to new device 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 Fri, 06 Jan 2017 10:31:38 +0000
client_time_utc TIMESTAMP_LTZ(9) Client_time in UTC Mon, 17 Apr 2017 13:48:48 +0000
closed_time TIMESTAMP_LTZ(3) Time of session close Mon, 17 Apr 2017 13:48:48 +0000
session_length NUMBER(38,0) Session length in seconds 1000
session_length_bucket NUMBER(38,0) Session length bucketed 2
session_uuid VARCHAR(40) session id  
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 session close 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
created_at TIMESTAMP_LTZ(3) Time in the App timezone that the datapoint was ingested Fri, 06 Jan 2017 10:31:38 +0000
custom_dimensions OBJECT JSON object with custom dimensions {“Subscriber Type”: “Premium”, “City”: “Boston”}