| session_uuid |
VARCHAR(40) |
session 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 attached to new device |
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 |
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 |
| milliseconds_since_last_session |
NUMBER(38,0) |
MS since last session data point for this data point |
100 |
| 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 |
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”} |