Exported Data
OpenReplay Enterprise Edition comes with different connectors for exporting captured data (user behavior and technical issues) to your data warehouse. We support:
- Amazon Redshift
- Google BigQuery
- PostgreSQL
- Snowflake
- ClickHouse
Sessions
Section titled Sessions| Column name | Type | Category | Description |
|---|---|---|---|
| sessionid | text | session metadata | Unique session identifier |
| user_browser | text | session metadata | User browser |
| user_browser_version | text | session metadata | User browser version |
| user_country | text | session metadata | User country |
| user_city | text | session metadata | User city |
| user_state | text | session metadata | User state |
| user_device | text | session metadata | User device |
| user_device_heap_size | biginteger | session metadata | User device heap size |
| user_device_memory_size | biginteger | session metadata | The approximate amount of device memory in gigabytes |
| user_device_type | text | session metadata | User device type |
| user_os | text | session metadata | User OS |
| user_os_version | text | session metadata | User OS version |
| user_uuid | text | session metadata | User unique identifier |
| connection_effective_bandwidth | biginteger | session metadata | The effective bandwidth estimate in megabits per second |
| connection_type | text | session metadata | Connection type. One of the following: bluetooth, cellular, ethernet, none, wifi, other, unknown |
| referrer | text | session metadata | the URI of the page that linked to this page |
| user_anonymous_id | text | session metadata | Optional user identifier |
| user_id | text | session metadata | An identifier of a user within a session, that can be set manually with setUserID() tracker method |
| tracker_version | text | technical | Version of tracker |
| rev_id | text | technical | Revision ID |
| session_start_timestamp | biginteger | session metadata | Timestamp when the first message from the session was generated on the user side |
| session_end_timestamp | biginteger | session metadata | Timestamp when the last message from a session arrived followed by 2 minutes and 30 seconds of inactivity |
| session_duration | biginteger | session metadata | The difference between session_end_timestamp and session_start_timestamp in milliseconds |
| first_contentful_paint | biginteger | loading speed | Time when the browser first rendered any text, image |
| speed_index | biginteger | loading speed | Speed Index is a page load performance metric that shows you how quickly the contents of a page are visibly populated. It is the average time at which visible parts of the page are displayed. Expressed in milliseconds, and dependent on the size of the viewport, the lower the score, the better. |
| visually_complete | biginteger | loading speed | The time necessary to the zone above the foldline to be rendered under its final form |
| timing_time_to_interactive | biginteger | loading speed | Time to Interactive is a non-standardized web performance ‘progress’ metric defined as the point in time when the last Long Task finished and was followed by 5 seconds of network and main thread inactivity. |
| avg_cpu | biginteger | performance | Average estimated CPU on a user side |
| avg_fps | biginteger | performance | Maximum number of frames per second on a user side |
| max_cpu | biginteger | performance | Maximum estimated CPU on a user side |
| max_fps | biginteger | performance | Maximum number of frames per second on a user side |
| max_total_js_heap_size | biginteger | performance | Maximum total heap size |
| max_used_js_heap_size | biginteger | performance | Maximum used heap size |
| js_exceptions_count | biginteger | issues and events | A count of JavaScript exceptions events within a session |
| inputs_count | biginteger | issues and events | A count of Input events within a session |
| clicks_count | biginteger | issues and events | A count of Click events within a session |
| issues_count | biginteger | issues and events | A count of Issue events within a session |
| pages_count | biginteger | issues and events | A count of different URL visited during a session |
| metadata_1 | text | session metadata | Additional information about users (also known as traits or user variables). Learn more about metadata |
| metadata_2 | text | session metadata | Additional information about users (also known as traits or user variables). Learn more about metadata |
| metadata_3 | text | session metadata | Additional information about users (also known as traits or user variables). Learn more about metadata |
| metadata_4 | text | session metadata | Additional information about users (also known as traits or user variables). Learn more about metadata |
| metadata_5 | text | session metadata | Additional information about users (also known as traits or user variables). Learn more about metadata |
| metadata_6 | text | session metadata | Additional information about users (also known as traits or user variables). Learn more about metadata |
| metadata_7 | text | session metadata | Additional information about users (also known as traits or user variables). Learn more about metadata |
| metadata_8 | text | session metadata | Additional information about users (also known as traits or user variables). Learn more about metadata |
| metadata_9 | text | session metadata | Additional information about users (also known as traits or user variables). Learn more about metadata |
| metadata_10 | text | session metadata | Additional information about users (also known as traits or user variables). Learn more about metadata |
Events
Section titled Events| Column name | Type | Category | Description |
|---|---|---|---|
| sessionid | biginteger | technical | Unique session identifier |
| consolelog_level | text | technical | Verbose, Info, Warning, or Error |
| consolelog_value | text | technical | Console log message content |
| customevent_name | text | technical | Name of the custom event |
| customevent_payload | text | technical | Custom event’s payload |
| jsexception_message | text | technical | JS exception message content |
| jsexception_name | text | technical | Exception’s name |
| jsexception_payload | text | technical | Exception’s payload |
| jsexception_metadata | text | technical | Exception’s metadata |
| networkrequest_type | text | behavioral and technical | Request type (GET, PUT, FETCH,…) |
| networkrequest_method | text | behavioral and technical | Request method |
| networkrequest_url | text | behavioral and technical | Requested url site |
| networkrequest_request | text | behavioral and technical | Request payload |
| networkrequest_response | text | behavioral and technical | Response from server |
| networkrequest_status | biginteger | behavioral and technical | Status of the request |
| networkrequest_timestamp | biginteger | behavioral and technical | Timestamp of request |
| networkrequest_duration | biginteger | behavioral and technical | Total duration of the request |
| issueevent_message_id | biginteger | behavioral and technical | Unique identifier |
| issueevent_timestamp | biginteger | behavioral and technical | Timestamp of the event |
| issueevent_type | text | behavioral and technical | Type of the issue (see Issue Type documentation for more) |
| issueevent_context_string | text | behavioral and technical | Issue message with explanation |
| issueevent_context | text | behavioral and technical | Relevant information on the issue |
| issueevent_payload | text | behavioral and technical | Payload |
| issueevent_url | text | behavioral and technical | URL |
| customissue_name | text | technical | Custom issue name |
| customissue_payload | text | technical | Custom issue payload |
| clickevent_label | text | behavioral | Element text if present |
| clickevent_selector | text | behavioral | Element selector if present |
| clickevent_url | text | behavioral | URL |
| clickevent_hesitation_time | biginteger | behavioral | Time between hovering on element and clicking it |
| clickevent_timestamp | biginteger | behavioral | Timestamp of click event |
| pageevent_url | text | technical | URL |
| pageevent_referrer | text | technical | The URI of the page that linked to this page |
| pageevent_speedindex | biginteger | technical | The average time at which visible parts of the page are displayed. Expressed in milliseconds |
| pageevent_timestamp | biginteger | technical | Timestamp of the event |
| inputevent_label | text | behavioral | Element text if exists |
| inputevent_hesitation_time | biginteger | behavioral | Hesitation time when typing the input |
| inputevent_input_duration | text | behavioral | Input duration |
| inputevent_timestamp | biginteger | behavioral | Timestamp of input event |
| mobile_event_name | text | behavioral and technical | Mobile event name |
| mobile_event_payload | text | behavioral and technical | Mobile event payload |
| mobile_networkcall_type | text | technical | Mobile network call type |
| mobile_networkcall_method | text | technical | Mobile network call method |
| mobile_networkcall_url | text | technical | Mobile network call URL |
| mobile_networkcall_request | text | technical | Mobile network request |
| mobile_networkcall_response | text | technical | Mobile network response |
| mobile_networkcall_status | text | technical | Mobile network request status |
| mobile_networkcall_timestamp | biginteger | technical | Mobile network request timestamp |
| mobile_networkcall_duration | biginteger | technical | Mobile network request duration |
| mobile_clickevent_x | biginteger | behavioral | Mobile tap event x coordinate |
| mobile_clickevent_y | biginteger | behavioral | Mobile tap event y coordinate |
| mobile_clickevent_timestamp | biginteger | behavioral | Mobile tap event timestamp |
| mobile_clickevent_label | text | behavioral | Mobile tap event label |
| mobile_swipeevent_x | biginteger | behavioral | Mobile swipe event x coordinate |
| mobile_swipeevent_y | biginteger | behavioral | Mobile swipe event y coordinate |
| mobile_swipeevent_timestamp | biginteger | behavioral | Mobile swipe event timestamp |
| mobile_swipeevent_label | text | behavioral | Mobile swipe event label |
| mobile_inputevent_label | text | behavioral | Mobile input label |
| mobile_inputevent_value | text | behavioral | Mobile input value |
| mobile_crash_name | text | technical | Mobile crash view name |
| mobile_crash_reason | text | technical | Mobile crash error |
| mobile_crash_stacktrace | text | technical | Mobile crash stacktrace |
| mobile_issueevent_timestamp | biginteger | technical | Mobile issue name |
| mobile_issueevent_type | text | technical | Mobile issue type |
| mobile_issueevent_context_string | text | technical | Mobile issue context |
| mobile_issueevent_context | text | technical | Mobile issue |
| mobile_issueevent_payload | text | technical | Mobile issue payload |
| mobile_viewcomponentevent_screen_name | text | behavioral | Mobile screen name |
| mobile_viewcomponentevent_view_name | text | behavioral | Mobile view name |
| mobile_viewcomponentevent_visible | boolean | behavioral | Is visible |
| mobile_viewcomponentevent_timestamp | biginteger | behavioral | Mobile screen/view event timestamp |
| received_at | biginteger | technical | Timestamp when the event is recieved by connector |
Have questions?
Section titled Have questions?If you have any questions about this process, feel free to reach out to us on our Slack or check out our Forum.