Skip to main content
Version: v2

Ready to Analyze Views

Fullstory has a new offering (currently in Early Access) to provide our warehousing customers with data that is transformed for Business Intelligence use cases. This new offering will export data directly into Redshift, Snowflake, and BigQuery warehouses using an industry-standard schema organized into Fact, Dimension, and Subdimension tables.

Silver ERD

The Events table is the fact table that has relationships with user data and customer-defined labels like Defined Pages, Defined Elements, and Defined Events. Additional sub-fact tables represent events broken out by event type. For example: clicks, page views, watched elements seen, form input changes, and custom events.

Fact Tables

The Events Table

The Events Table houses identifiers used to join data between dimensions and subdimensions.

Events Table

Event-type Tables

Events are broken out by the specific event types that they represent. These include clicks, page views, watched elements seen, form input changes, and custom events. These are a sampling of the event types that are provided. More events can be found in the Data Dictionary included in this document.

Event Type Tables

Dimension Tables

The Users Table

Select Fullstory Data Capture APIs, such as the Browser API, iOS API, Android API, Server API, contain a customer-defined user_id that reflects our customer's user, not Fullstory's. The Data Capture APIs can also provide the Display Name and Email of our customer's user. Users who do not have customer-provided identifiers will only have an id value. User data can be further enriched with custom user properties.

Users Table

Customer-defined labels

Customer-defined labels include pages, elements, and events given specific names by customers in the Fullstory app. These are Defined Pages, Defined Elements, and Defined Events.

Customer Defined Label Tables

Subdimension Tables

The subdimension tables include properties that provide additional enrichment to dimension tables with user properties, element properties, and page properties and source properties for events.

Customer-defined properties can be provided via integrations with Fullstory's APIs (browser, mobile, and server).

Subdimension Tables

Sample Queries

This new schema is designed to enable the creation of metrics reports to power the BI dashboards.

Number of unique users

select count(distinct id) from users;

Number of unique page views

select count(distinct event_id) from page_views;

Number of unique sessions

select count(distinct session_id) from events;

All events for a session, ordered by time

select 
id,
user_id,
session_id,
event_time,
event_type
from
events
where
session_id = '123:987'
order by
event_time

Session Replay URLs

URLs can be generated that will link to either the beginning of a session replay or to a particular point in time in a replay.

Session replay URLs are built using this template:

https://app.fullstory.com/ui/{your org id}/session/{session_id}{:optional timestamp}

The optional timestamp is in Unix time and will deep-link to a specific moment in time in the session replay. You can find your org id using these instructions.

Link to the beginning of a session replay

SELECT 'https://app.fullstory.com/ui/{your org id}/session/'||session_id as session_replay_url
FROM events

Link to a specific moment in time in a session replay

-- Snowflake
SELECT 'https://app.fullstory.com/ui/{your org id}/session/'||session_id||':'||
DATE_PART(epoch_millisecond, to_timestamp_ntz(event_time)) as session_replay_url
FROM events

-- BigQuery
SELECT 'https://app.fullstory.com/ui/{your org id}/session/'||session_id||':'||UNIX_MILLIS(event_time) as session_replay_url
FROM events

-- Redshift
SELECT 'https://app.fullstory.com/ui/{your org id}/session/'||session_id||':'||DATE_PART('epoch', event_time) * 1000 as session_replay_url
FROM events

Number of clicks from Georgia on the sign up button, grouped by browser

select
source_properties.user_agent_browser as user_agent_browser,
count(*)
from clicks
left join source_properties on clicks.event_id = source_properties.event_id
where
clicks.target_text = 'Sign Up'
and source_properties.location_region = 'GA'
group by
user_agent_browser

Data Dictionary

clicks

Contains information about click events, including error types, target elements, and additional metadata.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
fs_error_kindstringIf present, indicates an error click. Possible values: unknown, console, exception.
fs_rage_countint64The number of rage clicks detected.
fs_dead_countint64The number of dead clicks detected.
is_click_longbooleanIndicates if the click was a long click.
is_click_unhandledbooleanIndicates if the click was unhandled.
target_raw_selectorstringThe full selector path to the event's target element.
target_textstringThe relevant text of the event's target element, such as inner text for click events and values for input change events
target_element_definition_id (FK)stringThe id of the most specific, matching customer-configured Named Element in the element_definitions table.
target_additional_element_definition_idsarray of stringsAdditional matching Named Element IDs.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

consents

Contains information about click events, including error types, target elements, and additional metadata.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
is_consent_givenbooleanIndicates whether consent was given.
consent_scopestringThe scope of the consent given by the user.
consent_action_typestringThe type of consent action taken by the user.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

console_messages

Contains information about console messages, including the message level and the message text.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
console_message_levelstringThe level that the console message was logged at. Possible values: error
messagestringThe text of the console message.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

copies

Contains information about copy events, including the target element and whether the target text was masked.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
target_maskedstringIf true, indicates that the target text is empty because it was masked due to a privacy rule
target_raw_selectorstringThe full selector path to the event's target element.
target_textstringThe text found in an event's target element
target_element_definition_id (FK)stringThe id of the most specific, matching customer-configured Named Element in the element_definitions table.
target_additional_element_definition_idsarray of stringsAdditional matching Named Element IDs.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

crashes

Contains information about mobile app crash events

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

cumulative_layout_shifts

Contains information about cumulative layout shifts, including the CLS score for the page.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
cumulative_layout_shiftdoubleThe Cumulative Layout Shift (CLS) score for the page.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

custom_events

Contains information about custom events created by Fullstory APIs (Browser API, iOS API, Android API, Server API), including event properties and API errors.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
event_namestringThe customer-defined name of the event.
event_propertiesjsonCustomer-defined properties of the event.
fs_api_errorsjsonAny errors that occurred while processing the custom event.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

element_definitions

Contains definitions for Defined Elements, including their names, descriptions, and active states.

Column NameTypeDescription
id (PK)stringUnique Id for the event related to the Named Element.
namestringCustomer-provided name of the element.
descriptionstringElement description
statestringWhether or not the element is still active. Values are "active" and "inactive"
created_timetimestampThe time in UTC that the element was created.
created_bystringThe Fullstory user who created the element.
modified_timetimestampThe time in UTC that the element was modified.
modified_bystringThe Fullstory user who modified the element.

element_properties

Contains properties of elements, including various attributes and metadata. The columns available are customer-dependent.

Column NameTypeDescription
event_id (PK, FK)stringUnique Id for the related event.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
last_updated_timetimestampThe most recent time an element property was updated.
product_namestringAn example custom property.
pricefloat64An example custom property.

elements_seen

Contains information about watched elements that were seen, including render and visibility durations.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
element_render_duration_millisint64The amount of time that the element was rendered.
element_start_timeint64The time at which the Watched Element was first rendered or made visible.
element_start_typestringThe type of the Watched Element at the element_start_time. Possible values: - rendered: Indicates that the watched element was rendered, but not visible in the viewport. - visible: Indicates that the watched element was visible in the viewport. - end: Indicates the end of the watched element's lifecycle.
element_typestringPossible values: - rendered: Indicates that the watched element was rendered, but not visible in the viewport. - visible: Indicates that the watched element was visible in the viewport. - end: Indicates the end of the watched element's lifecycle.
element_visible_duration_millisint64The amount of time that the element was visible.
target_raw_selectorstringThe full selector path to the event's target element.
target_textstringThe relevant text of the event's target element, such as inner text for click events and values for input change events.
target_element_definition_id (FK)stringThe id of the most specific, matching customer-configured Named Element in the element_definitions table.
target_additional_element_definition_idsarray of stringsAdditional matching Named Element IDs.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

event_definitions

Contains definitions for Defined Events, including their names, descriptions, and active states.

Column NameTypeDescription
id (PK)stringUnique Id for the event related to the Defined Event.
namestringCustomer-provided name of the defined event.
descriptionstringEvent description
statestringWhether or not the event is still active. Values are "active" and "inactive"
created_timetimestampThe time in UTC that the event was created.
created_bystringThe Fullstory user who created the event.
modified_timetimestampThe time in UTC that the event was modified.
modified_bystringThe Fullstory user who modified the event.

events

Contains information about various events, including their types, times, and associated identifiers. If a user is wanting a count of things that happened, you can generally start with this table, then join it to some dimensions.

Column NameTypeDescription
id (PK)stringAn unique id representing each event in Fullstory.
user_id (FK)stringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
event_typestringThe type of the event. These types are used to define the event-type dimension tables.

exceptions

Contains information about exceptions, including their sources, counts, and messages.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
exception_source_filestringThe source file that produced the exception.
exception_countint64The number of times that this exception fired within a given window (useful for batching bursts of exceptions fired).
is_exception_handledbooleanWhether the exception is caught or not.
messagestringThe message associated with the exception
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

first_input_delays

Contains information about first input delays, including the delay time in milliseconds.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
first_input_delay_millisint64The time from the first user input event to the browser's response.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

force_restarts

Contains information about force restarts, including the elapsed time in milliseconds.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
elapsed_millisint64The number of milliseconds between when the app was backgrounded and when it was started.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

form_abandons

Contains information about form abandons, including the target element and whether the target text was masked.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
target_maskedstringIf true, indicates that the target text is empty because it was masked due to a privacy rule
target_raw_selectorstringThe full selector path to the event's target element.
target_textstringThe text found in an event's target element
target_element_definition_id (FK)stringThe id of the most specific, matching customer-configured Named Element in the element_definitions table.
target_additional_element_definition_idsarray of stringsAdditional matching Named Element IDs.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

form_input_changes

Contains information about form input changes, including the target element and whether the target text was masked.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
fs_suspicious_kindjsonIndicates any suspicious activity detected in the change event.

Possible values:
- sql_injection: The activity appears to be a SQL injection attack.
- xss: The activity appears to be a cross-site scripting (XSS) attack.
target_maskedstringIf true, indicates that the target text is empty because it was masked due to a privacy rule
target_raw_selectorstringThe full selector path to the event's target element.
target_textstringThe text found in an event's target element
target_element_definition_id (FK)stringThe id of the most specific, matching customer-configured Named Element in the element_definitions table.
target_additional_element_definition_idsarray of stringsAdditional matching Named Element IDs.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

highlights

Contains information about highlights, including the target element and associated event and element definitions.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
target_raw_selectorstringThe full selector path to the event's target element.
target_textstringThe text found in an event's target element
target_element_definition_id (FK)stringThe id of the most specific, matching customer-configured Named Element in the element_definitions table.
target_additional_element_definition_idsarray of stringsAdditional matching Named Element IDs.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

interaction_to_next_paints

Contains information about the time from user interaction to the next paint event.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
interaction_to_next_paint_millisint64The time from the first user input event to the next paint event.
event_namestringThe name of the event that triggered the first user input as reported by the browser. Examples are: keydown and mouseover.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

keyboard_closes

Contains information about keyboard close events.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

keyboard_opens

Contains information about keyboard open events.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

loads

Contains information about page load events, including various performance metrics.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
dom_content_time_millisint64The time it took for the document to be parsed and the DOM tree to be constructed.
first_paint_time_millisint64The time of the First Contentful Paint (FCP).
load_time_millisint64The time it took for the page to load completely.
largest_paint_time_millisint64The time of the Largest Contentful Paint (LCP).
time_to_interactive_millisint64The Time to Interactive (TTI) is the time it takes for the page to become fully interactive.
total_blocking_time_millisint64The Total Blocking Time (TBT) is the total amount of time that the page was blocked after the FCP.
time_to_first_byte_millisint64The Time to First Byte (TTFB) is the time it takes for the first byte of the response to be received.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

low_memories

Contains information about low memory events, including available and maximum memory.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
memory_availableint64The amount of memory available on the device at the time of the event.
memory_maximumint64The maximum amount of memory available on the device.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

mouse_thrashes

Contains information about mouse thrash events.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

Contains information about navigation events, including the reason for navigation and any associated API errors.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
navigate_reasonstringPossible values:
- navigate: Navigation started by clicking a link, entering the URL in the browser's address bar, form submission, or initializing through a script operation other than reload and back_forward as listed below.
- reload: Navigation is through the browser's reload operation, location.reload(), or a Refresh pragma directive.
- back_forward: Navigation is through the browser's history traversal operation.
- prerender: Navigation is initiated by a prerender hint.
fs_api_errorsstringAny errors encountered when identifying the user through the API.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

page_definitions

Contains definitions for Defined Pages, including their names, descriptions, and active states.

Column NameTypeDescription
id (PK)stringUnique Id for the event related to the Defined Page.
namestringCustomer-provided name of the defined page.
descriptionstringPage description
is_user_definedbooleanIndicates whether the page definition was created by a user.
statestringWhether or not the page is still active. Values are "active" and "inactive"
created_timetimestampThe time in UTC that the page was created.
created_bystringThe Fullstory user who created the page.
modified_timetimestampThe time in UTC that the page was modified.
modified_bystringThe Fullstory user who modified the page.

page_properties

Contains properties of pages set with the Fullstory page properties API. The columns available are customer-dependent

Column NameTypeDescription
event_id (PK, FK)stringUnique Id for the related event.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
last_updated_timetimestampThe most recent time a page property was updated.
event_definition_idstringForeign key referencing id in the event_definitions table.
locationstringAn example custom property.

page_views

Contains information about page views, including durations and associated event definitions.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
active_duration_millisint64Number of milliseconds the page was active on a page (as indicated mouse movements, scrolling, and other user interactions).
duration_millisint64Total amount of time the page was rendered in the browser or app window.
end_timetimestampEnd time (page unloaded in browser or app) in milliseconds relative to the session start.
inactive_duration_millisint64Total duration minus active duration.
start_timetimestampStart time (page first rendered) in milliseconds relative to the session start.
page_namestringThe name of the page as provided through the API.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

pastes

Contains information about paste events, including the target element and whether the target text was masked.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
target_maskedstringIf true, indicates that the target text is empty because it was masked due to a privacy rule
target_raw_selectorstringThe full selector path to the event's target element.
target_textstringThe text found in an event's target element
target_element_definition_id (FK)stringThe id of the most specific, matching customer-configured Named Element in the element_definitions table.
target_additional_element_definition_idsarray of stringsAdditional matching Named Element IDs.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

requests

Contains information about HTTP requests, including the request method, URL, status, and duration.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
request_methodstringThe full URL of the request, including the protocol, host, path, query, and hash.
request_url_full_urlstringThe host portion of the URL.
request_url_hoststringThe path portion of the URL.
request_url_pathstringThe query portion of the URL, structured as an object where the key is the query parameter name and the value is a list of values for that parameter.
request_url_querystringThe hash path of the URL.
request_url_hash_pathstringThe hash query of the URL, structured as an object where the key is the query parameter name and the value is a list of values for that parameter. Questions that may be answered using this column: - What are the most common request hash queries? - How many requests were made with a specific hash query?
request_url_hash_querystringThe HTTP status code of the request. Questions that may be answered using this column: - What are the most common request status codes? - How many requests returned a specific status code?
request_statusstringThe duration of the request in milliseconds. Questions that may be answered using this column: - What is the average duration of HTTP requests? - How many requests had a duration above a certain threshold?
request_duration_millisstringThe duration of the request in milliseconds.
event_definition_id (FK)stringThe id of the most specific matching customer-configured Defined Event in the event_definitions table.
additional_event_definition_idsarray of stringsAdditional matching event definition IDs

source_properties

Contains properties of event sources, including various attributes and metadata.

Column NameTypeDescription
event_id (PK, FK)stringUnique Id for the related event.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
entrypointstringIf present, indicates how the event was created, including from the Fullstory capture script. Some examples are: web client, FS('trackEvent'), and POST /v2/users. Support for this field not guaranteed across all capture clients.
originstringIf present, indicates where the event was generated. Some examples are: "dom" and "server".
integrationstringIf present, indicates the integration that generated the event. For Fullstory built capture sources, this value will be fs. Examples include dlo, segment, and zendesk. Support for this field is not guaranteed across all integrations.
source_typestringThe Source Type of the related event.
initial_referrer_full_urlstringThe referrer from the first navigation event in the "view". A full URL including the protocol, host, path, query, and hash.
initial_referrer_hoststringThe referrer from the first navigation event in the "view". The host portion of the URL. e.g. www.example.com.
initial_referrer_pathstringThe referrer from the first navigation event in the "view". The path portion of the URL. e.g. /path/to/page.
initial_referrer_queryjsonThe referrer from the first navigation event in the "view". The query portion of the URL, structured as an object where the key is the query parameter name and the value is a list of values for that parameter. For example, /path/to/page?foo=bar&baz=qux&baz=boop would be represented as { "foo": { "values": ["bar"] }, "baz": { "values": ["qux", "boop"] }}.
initial_referrer_hash_pathstringThe hash path of the URL. e.g. #/path/to/page would be represented as /path/to/page.
initial_referrer_hash_queryjsonThe hash query of the URL, structured as an object where the key is the query parameter name and the value is a list of values for that parameter. For example, #/path/to/page?foo=bar&baz=qux&baz=boop would be represented as { "foo": { "values": ["bar"] }, "baz": { "values": ["qux", "boop"] }}.
location_countrystringIf present, the country associated with the IP address at the start of the associated capture instance.
location_lat_longstringIf present, the latitude and longitude associated with the IP address. The format is "latitude,longitude".
location_regionstringIf present, the name of the region associated with the IP address.
page_definition_idstringThe ID of the Page as defined in the Fullstory app.
url_full_urlstringThe URL of the page when the event occurred. A full URL including the protocol, host, path, query, and hash.
url_hoststringThe URL of the page when the event occurred. The host portion of the URL. e.g. www.example.com.
url_pathstringThe URL of the page when the event occurred. The path portion of the URL. e.g. /path/to/page.
url_queryjsonThe URL of the page when the event occurred. The query portion of the URL, structured as an object where the key is the query parameter name and the value is a list of values for that parameter. For example, /path/to/page?foo=bar&baz=qux&baz=boop would be represented as { "foo": { "values": ["bar"] }, "baz": { "values": ["qux", "boop"] }}.
user_agent_browserstringThe browser used by the device or Unknown. Example values include: Chrome, Safari, Firefox, Microsoft Edge, and Custom Agent.
user_agent_browser_versionstringIf present, the version of the browser. This field will only be present if the version is of the format major.minor.build.patch where each subversion is optional (e.g. 10A is a valid version). Otherwise, this field will be null.
user_agent_devicestringIf present, the type of device. Example values include: Tablet, Mobile, Desktop, Robot.
user_agent_operating_systemstringIf present, the operating system of the device. Example values include: Windows, OS X, iOS, Android, and Linux.
user_agent_raw_user_agentstringAn unprocessed user agent string. This value is used to derive the following fields. There may be cases where this string is not in a known format, in which case the derived fields will be either Unknown or null.
app_idstringIdentifies a run of FSCLI during iOS native mobile builds.
app_namestringThe name of the mobile app that produced the event.
app_package_namestringCode-level package name of a mobile app, e.g. com.fullstory.sampleapp.latest.
app_screen_namestringThe name of the mobile app screen on which the event occurred.
app_versionstringMobile app version, e.g. 25.0.1.
fs_versionstringThe version of the Fullstory mobile SDK used to capture the event. Release Notes
device_screen_heightint64Indicates the screen height of the device in pixels.
device_screen_widthint64Indicates the screen width of the device in pixels.
device_viewport_heightint64Indicates the height of the viewport in pixels at the time of the event.
device_viewport_widthint64Indicates the width of the viewport in pixels at the time of the event.
device_manufacturerstringIf present, the manufacturer of the device. Generally available for Mobile Apps, but may also be provided by the server API. Examples include: Apple, Samsung, Google, and Microsoft.
device_modelstringIf present, the model of the device. Generally available for Mobile Apps, but may also be provided by the server API. Examples include: iPhone12, Pixel 5, and Surface Pro 7 and SM-G950F.
device_operating_systemstringIf present, the operating system of the device. Generally available for Mobile Apps, but may also be provided by the server API.
device_os_versionstringIf present, the version of the operating system. Generally available for Mobile Apps, but may also be provided by the server API.

user_properties

Contains properties of users, including metadata and various attributes captured with Fullstory APIs (Browser API, iOS API, Android API, Server API). The columns available are customer-dependent.

Column NameTypeDescription
user_id (PK/FK)stringUnique id for the related user. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
last_updated_timetimestampThe most recent time a user property was updated.
pricing_planstringAn example custom property.
total_spentfloat64An example custom property.
disabledboolAn example custom property.

users

Contains information about users, including their display names, user IDs, and email addresses.

Column NameTypeDescription
id (PK)stringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
uidstringA unique id for the user provided by the customer through the API.
user_display_namestringThe display name for the user as provided through the API. If none is provided, this will be generated by the Fullstory backend.
user_emailstringIf present, the email address for the user.
last_updated_timetimestampThe time the user was last updated.