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 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
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
urls_countbigintegerissues and eventsA count of different URL visited during a session

Events

Section titled Events
Column nameTypeCategoryDescription
sessionidbigintegertechnicalUnique session identifier
consolelog_leveltexttechnicalVerbose, Info, Warning, or Error
consolelog_valuetexttechnicalConsole log message content
customevent_nametexttechnicalName of the custom event
customevent_payloadtexttechnicalcustom event’s payload
jsexception_messagetexttechnicalJS exception message content
jsexception_nametexttechnicalException’s name
jsexception_payloadtexttechnicalException’s payload
jsexception_metadatatexttechnicalException’s metadata
networkrequest_typetextbehavioral and technicalRequest type (GET, PUT, FETCH,…)
networkrequest_urltextbehavioral and technicalRequested url site
networkrequest_requesttextbehavioral and technicalRequest payload
networkrequest_responsetextbehavioral and technicalResponse from server
networkrequest_statusbigintegerbehavioral and technicalStatus of the request
networkrequest_timestampbigintegerbehavioral and technicalTimestamp of request
networkrequest_durationbigintegerbehavioral and technicalTotal duration of the request
issueevent_message_idbigintegerbehavioral and technicalUnique identifier
issueevent_timestampbigintegerbehavioral and technicalTimestamp of the event
issueevent_typetextbehavioral and technicalType of the issue (see Issue Type documentation for more)
issueevent_context_stringtextbehavioral and technicalIssue message with explanation
issueevent_contexttextbehavioral and technicalRelevant information on the issue
issueevent_payloadtextbehavioral and technicalPayload
customissue_nametexttechnicalCustom issue name
customissue_payloadtexttechnicalCustom issue payload
received_atbigintegertechnicalTimestamp when the event is recieved by connector
batch_order_numberbigintegertechnicalOrder number in a batch. To reconstruct the order of messages, sort by received_at and batch_order_number

Events detailed

Section titled Events detailed
Column nameTypeCategoryDescription
sessionidbigintegertechnicalUnique session identifier
clickevent_hesitationtimebigintegerbehavioralTime between hovering on element and clicking it
clickevent_labeltextbehavioralElement text if present
clickevent_messageidbigintegerbehavioralUnique identifier of DOM element
clickevent_timestampbigintegerbehavioralTimestamp of click event
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_nametexttechnicalName of the custom event
customevent_payloadtexttechnicalCustom event’s payload
fetch_durationbigintegertechnicalDuration of fetch request
fetch_requesttexttechnicalFetch request payload
fetch_responsetexttechnicalResponse from server
fetch_statusbigintegertechnicalStatus of request
fetch_timestampbigintegertechnicalTimestamp of fetch request
fetch_urltexttechnicalURL of server
graphql_operationkindtexttechnicalGraphQL operation kind
graphql_operationnametexttechnicalGraphQL operation
graphql_responsetexttechnicalGraphQL response
graphql_variablestexttechnicalGraphQL variables
inputevent_labeltextbehavioralElement text if exists
inputevent_messageidbigintegerbehavioralUnique identifier
inputevent_timestampbigintegerbehavioralTimestamp of input event
inputevent_valuetextbehavioralInput value
inputevent_valuemaskedbooleanbehavioralTrue if value is masked
jsexception_messagetexttechnicalJS exception message content
jsexception_nametexttechnicalException’s name
jsexception_payloadtexttechnicalException’s payload
jsexception_metadatatexttechnicalException’s metadata
networkrequest_typetextbehavioral and technicalRequest type (GET, PUT, FETCH,…)
networkrequest_urltextbehavioral and technicalRequested url site
networkrequest_requesttextbehavioral and technicalRequest payload
networkrequest_responsetextbehavioral and technicalResponse from server
networkrequest_statusbigintegerbehavioral and technicalStatus of the request
networkrequest_timestampbigintegerbehavioral and technicalTimestamp of request
networkrequest_durationbigintegerbehavioral and technicalTotal duration of the request
pageevent_domcontentloadedeventendbigintegertechnicalTimestamp when DOM contents are loaded
pageevent_domcontentloadedeventstartbigintegertechnicalTimestamp of DOM contents load
pageevent_firstcontentfulpaintbigintegertechnicalTimestamp when the browser first rendered any text, image
pageevent_firstpaintbgintegertechnicalIs 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_loadedbooleantechnicalTrue if loaded
pageevent_loadeventendbigintegertechnicalTimestamp when page loaded
pageevent_loadeventstartbigintegertechnicalTimestamp when start page loading
pageevent_messageidbigintegertechnicalUnique identifier
pageevent_referrertexttechnicalThe URI of the page that linked to this page
pageevent_requeststartbgintegertechnicalTimestamp of start of the request
pageevent_responseendbigintegertechnicalTimestamp of response end
pageevent_responsestartbgintegertechnicalTimestamp of response start
pageevent_speedindexbigintegertechnicalThe average time at which visible parts of the page are displayed. Expressed in milliseconds
pageevent_timestampbigintegertechnicalTimestamp of the event
pageevent_urltexttechnicalURL
sessionend_timestampbigintegertechnicalTimestamp when session end
sessionend_encryption_keytexttechnicalEncryption key
sessionstart_projectidbigintegertechnicalSession’s project id
sessionstart_revidtexttechnicalRevision id
sessionstart_timestampbigintegertechnicalTimestamp when session start
sessionstart_trackerversiontexttechnicalVersion of tracker
sessionstart_useragenttexttechnicalExample: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:47.0) Gecko/20100101 Firefox/47.0
sessionstart_userbrowsertexttechnicalUser browser
sessionstart_userbrowserversiontexttechnicalUser browser version
sessionstart_usercountrytexttechnicalUser country
sessionstart_userdevicetexttechnicalUser’s device
sessionstart_userdeviceheapsizebigintegertechnicalUser device heap size
sessionstart_userdevicememorysizebigintegertechnicalThe approximate amount of device memory in gigabytes
sessionstart_userdevicetypetexttechnicalUser’s device type
sessionstart_userostexttechnicalUser’s OS
sessionstart_userosversiontexttechnicalOS version
sessionstart_useruuidtexttechnicalUser’s unique identifier
setpagelocation_navigationstartbigintegerbehavioral and technicalTimestamp of start of navigation
setpagelocation_referrertextbehavioral and technicalThe URI of the page that linked to the url
setpagelocation_urltextbehavioral and technicalURL location
issueevent_message_idbigintegerbehavioral and technicalUnique identifier
issueevent_timestampbigintegerbehavioral and technicalTimestamp of the event
issueevent_typetextbehavioral and technicalType of the issue (see Issue Type documentation for more)
issueevent_context_stringtextbehavioral and technicalIssue message with explanation
issueevent_contexttextbehavioral and technicalRelevant information on the issue
issueevent_payloadtextbehavioral and technicalPayload
customissue_nametexttechnicalCustom issue name
customissue_payloadtexttechnicalCustom issue payload
received_atbigintegertechnicalTimestamp when the event is recieved by connector
batch_order_numberbigintegertechnicalOrder number in a batch. To reconstruct the order of messages, sort by received_at and batch_order_number

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.