Our exportData API method, if called with exportFormat = csv or part of an S3 export, produces several csv files with the following schema.
The CSV export produces separate files for sessions, states, events, event parameters, and user attributes.
| field | type | description |
|---|
| sessionId | BIGINT | unique session ID for the current session |
| userId | VARCHAR(400) | user ID |
| userBucket | INT | LP-assigned user bucket |
| userStart | TIMESTAMP | start time of the user's first session |
| country | VARCHAR(256) | user's current country |
| region | VARCHAR(256) | user's current region |
| city | VARCHAR(256) | user's current city |
| start | TIMESTAMP | start time of session information |
| duration | TIMESTAMP | the duration of the current session in seconds (e.g. 19.254) |
| lat | REAL | latitude of current location |
| lon | REAL | longitude of current location |
| locale | VARCHAR(256) | user's locale, includes language and country set on the device (e.g. en_US) |
| timezone | VARCHAR(256) | user's timezone |
| timezoneOffset | DECIMAL(7,2) | offset of user's timezone |
| appVersion | VARCHAR(128) | current app version |
| client | VARCHAR(50) | current client version |
| sdkVersion | VARCHAR(128) | SDK version |
| osName | VARCHAR(512) | OS name |
| osVersion | VARCHAR(512) | OS version |
| deviceModel | VARCHAR(512) | model of user's device |
| browserName | VARCHAR(512) | user's web browser |
| browserVersion | VARCHAR(512) | version of user's web browser |
| deviceId | VARCHAR(512) | device ID |
| priorEvents | BIGINT | number of prior events |
| priorSessions | BIGINT | number of prior sessions |
| priorTimeSpentInApp | DECIMAL(12,2) | total time of previous session(s) |
| priorStates | BIGINT | number of prior states |
| isDeveloper | BOOLEAN | is developer flag |
| isSession | BOOLEAN | is session flag |
| sourcePublisherId | VARCHAR(200) | attribution source publisher ID |
| sourcePublisher | VARCHAR(200) | attribution source publisher |
| sourceSubPublisher | VARCHAR(200) | attribution source sub-publisher |
| sourceSite | VARCHAR(200) | attribution source site |
| sourceCampaign | VARCHAR(200) | attribution source campaign |
| sourceAdGroup | VARCHAR(200) | attribution source ad group |
| sourceAd | VARCHAR(200) | attribution source ad |
| field | type | description |
|---|
| sessionId | BIGINT | the ID of the matching session |
| name | VARCHAR(256) | the name of the user attribute |
| value | VARCHAR(512) | the value of the user attribute |
| field | type | description |
|---|
| experimentId | BIGINT | unique experiment ID for the A/B test |
| sessionId | BIGINT | the ID of the matching session |
| variantId | BIGINT | the variant ID the user is entered in within the A/B test |
| field | type | description |
|---|
| stateId | BIGINT | unique state ID |
| sessionId | BIGINT | the ID of the matching session |
| stateName | VARCHAR(256) | the name of the state |
| start | TIMESTAMP | the start time within the state |
| duration | DECIMAL(10,2) | time within state |
| info | VARCHAR(1024) | any info attached to the state |
| timeUntilFirstForUser | DECIMAL(12,2) | total time before state occurrence, would be null value if this is not the first occurrence |
| field | type | description |
|---|
| eventId | BIGINT | unique event ID |
| stateId | BIGINT | the ID of the matching state, if any |
| sessionId | BIGINT | the ID of the matching session |
| eventName | VARCHAR(256) | the name of the event |
| start | TIMESTAMP | the start time of the event |
| value | FLOAT | value of the event |
| info | VARCHAR(1024) | any info attached to the event |
| timeUntilFirstForUser | DECIMAL(12,2) | total time before event occurrence, would be null value if this is not the first occurrence |
| field | type | description |
|---|
| eventId | VARCHAR | the ID of the matching event |
| name | VARCHAR(256) | the name of the event parameter |
| value | VARCHAR(512) | the value of the parameter |
