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

´╗┐Column nameTypeCategoryDescription
sessionidtextsession metadataUnique session identifier
user_agenttextsession metadataExample: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:47.0) Gecko/20100101 Firefox/47.0
user_browsertextsession metadataUser browser
user_browser_versiontextsession metadataUser browser version
user_countrytextsession metadataUser country
user_devicetextsession metadataUser device
user_device_heap_sizebigintegersession metadataUser device heap size
user_device_memory_sizebigintegersession metadataThe approximate amount of device memory in gigabytes
user_device_typetextsession metadataUser device type
user_ostextsession metadataUser OS
user_os_versiontextsession metadataUser OS version
user_uuidtextsession metadataUser unique identifier
connection_effective_bandwidthbigintegersession metadataThe effective bandwidth estimate in megabits per second
connection_typetextsession metadataConnection type. One of the following: bluetooth, cellular, ethernet, none, wifi, other, unknown
metadata_keytextsession metadataAdditional information about users (also known as traits or user variables). Learn more about metadata
metadata_valuetextsession metadataAdditional information about users (also known as traits or user variables). Learn more about metadata
referrertextsession metadatathe URI of the page that linked to this page
user_anonymous_idtextsession metadataOptional user identifier
user_idtextsession metadataAn identifier of a user within a session, that can be set manually with setUserID() tracker method
session_start_timestampbigintegersession metadataTimestamp when the first message from the session was generated on the user side
session_end_timestampbigintegersession metadataTimestamp when the last message from a session arrived followed by 2 minutes and 30 seconds of inactivity
session_durationbigintegersession metadataThe difference between session_end_timestamp and session_start_timestamp in milliseconds
first_contentful_paintbigintegerloading speedTime when the browser first rendered any text, image
speed_indexbigintegerloading speedSpeed 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_completebigintegerloading speedThe time necessary to the zone above the foldline to be rendered under its final form
timing_time_to_interactivebigintegerloading speedTime 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_cpubigintegerperformanceAverage estimated CPU on a user side
avg_fpsbigintegerperformanceMaximum number of frames per second on a user side
max_cpubigintegerperformanceMaximum estimated CPU on a user side
max_fpsbigintegerperformanceMaximum number of frames per second on a user side
max_total_js_heap_sizebigintegerperformanceMaximum total heap size
max_used_js_heap_sizebigintegerperformanceMaximum used heap size
js_exceptions_countbigintegerissues and eventsA count of JavaScript exceptions events within a session
long_tasks_total_durationbigintegerissues and eventsTotal duration of tasks that block the main thread for 50 ms or more
long_tasks_max_durationbigintegerissues and eventsMaximum duration of a single task that block the main thread for 50 ms or more
long_tasks_countbigintegerissues and eventsTotal number of tasks that block the main thread for 50 ms or more
inputs_countbigintegerissues and eventsA count of Input events within a session
clicks_countbigintegerissues and eventsA count of Click events within a session
issues_countbigintegerissues and eventsA count of Issue events within a session
issuesarray[text]issues and eventsA list of issue names
urls_countbigintegerissues and eventsA count of different URL visited during a session
urlsarray[text]issues and eventsA list of URLs visited during a session

Events

Column nameTypeCategoryDescription
sessionidbigintegertechnicalUnique session identifier
connectioninformation_downlinkbigintegertechnicalThe effective bandwidth estimate in megabits per second, rounded to the nearest multiple of 25 kilobits per seconds
connectioninformation_typetexttechnicalThe type of connection a device is using to communicate with the network. One of the following: bluetooth, cellular, ethernet, none, wifi, other, unknown.
consolelog_leveltexttechnicalVerbose, Info, Warning or Error
consolelog_valuetexttechnicalConsole log message content
customevent_messageidbigintegertechnicalUnique identifier
customevent_nametexttechnicalName of the custom event
customevent_payloadtexttechnicalcustom event's payload
customevent_timestampbigintegertechnicalTimestamp of the event
errorevent_messagetexttechnicalError event message content
errorevent_messageidbigintegertechnicalUnique identifier
errorevent_nametexttechnicalName of the error event
errorevent_payloadtexttechnicalError's payload
errorevent_sourcetexttechnicalSource of the error
errorevent_timestampbigintegertechnicalTimestamp of the event
jsexception_messagetexttechnicalJS exception message content
jsexception_nametexttechnicalException's name
jsexception_payloadtexttechnicalException's payload
metadata_keytexttechnicalAdditional information about users (also known as traits or user variables). Learn more about metadata
metadata_valuetexttechnicalAdditional information about users (also known as traits or user variables). Learn more about metadata
mouseclick_idbigintegerbehavioralA unique identifier of a DOM element
mouseclick_hesitationtimebigintegerbehavioralTime between hovering on element and clicking it
mouseclick_labeltextbehavioralElement text if present
pageevent_firstcontentfulpaintbigintegertechnicalTimestamp when the browser first rendered any text, image
pageevent_firstpaintbigintegertechnicalIs the time between navigation and when the browser renders the first pixels to the screen, rendering anything that is visually different from what was on the screen prior to navigation. It answers the question Is it happening?
pageevent_messageidbigintegertechnicalUnique identifier
pageevent_referrertexttechnicalthe URI of the page that linked to this page
pageevent_speedindexbigintegertechnicalThe average time at which visible parts of the page are displayed. Expressed in milliseconds
pageevent_timestampbigintegertechnicalTimestamp of the event
pageevent_urltextbehavioralURL
pagerendertiming_timetointeractivebigintegertechnicalA 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
pagerendertiming_visuallycompletebigintegertechnicalThe time necessary to the zone above the foldline to be rendered under its final form
rawcustomevent_nametexttechnicalCustom event name
rawcustomevent_payloadtexttechnicalPayload
setviewportsize_heightbigintegerbehavioralHeight of the user's visible area of a web page
setviewportsize_widthbigintegerbehavioralWidth of the user's visible area of a web page
timestamp_timestampbigintegertechnicalTimestamp message (related to v.2)
user_anonymous_idtexttechnicalOptional user identifier
user_idtexttechnicalAn identifier of a user within a session, that can be set manually with setUserID() tracker method
issueevent_messageidbigintegerbehavioral, technicalUnique identifier
issueevent_timestampbigintegerbehavioral, technicalTimestamp of the event
issueevent_typetextbehavioral, technicalType of the issue (see Issue Type documentation for more)
issueevent_contextstringtextbehavioral, technicalIssue message with explanation
issueevent_contexttextbehavioral, technicalRelevant information on the issue
issueevent_payloadtextbehavioral, technicalPayload
customissue_nametexttechnicalCustom issue name
customissue_payloadtexttechnicalCustom issue payload
received_atbigintegertechnicalTimestamp when the event is received by connector
batch_order_numberbigintegertechnicalOrder number in a batch. To reconstruct the order of messages, sort by received_at and batch_order_number