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.

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.

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.

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.

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.

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).

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 Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
fs_error_kind | string | If present, indicates an error click. Possible values: unknown, console, exception. |
fs_rage_count | int64 | The number of rage clicks detected. |
fs_dead_count | int64 | The number of dead clicks detected. |
is_click_long | boolean | Indicates if the click was a long click. |
is_click_unhandled | boolean | Indicates if the click was unhandled. |
target_raw_selector | string | The full selector path to the event's target element. |
target_text | string | The 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) | string | The id of the most specific, matching customer-configured Named Element in the element_definitions table. |
target_additional_element_definition_ids | array of strings | Additional matching Named Element IDs. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
consents
Contains information about click events, including error types, target elements, and additional metadata.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
is_consent_given | boolean | Indicates whether consent was given. |
consent_scope | string | The scope of the consent given by the user. |
consent_action_type | string | The type of consent action taken by the user. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
console_messages
Contains information about console messages, including the message level and the message text.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
console_message_level | string | The level that the console message was logged at. Possible values: error |
message | string | The text of the console message. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
copies
Contains information about copy events, including the target element and whether the target text was masked.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
target_masked | string | If true, indicates that the target text is empty because it was masked due to a privacy rule |
target_raw_selector | string | The full selector path to the event's target element. |
target_text | string | The text found in an event's target element |
target_element_definition_id (FK) | string | The id of the most specific, matching customer-configured Named Element in the element_definitions table. |
target_additional_element_definition_ids | array of strings | Additional matching Named Element IDs. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
crashes
Contains information about mobile app crash events
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
cumulative_layout_shifts
Contains information about cumulative layout shifts, including the CLS score for the page.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
cumulative_layout_shift | double | The Cumulative Layout Shift (CLS) score for the page. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional 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 Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
event_name | string | The customer-defined name of the event. |
event_properties | json | Customer-defined properties of the event. |
fs_api_errors | json | Any errors that occurred while processing the custom event. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
element_definitions
Contains definitions for Defined Elements, including their names, descriptions, and active states.
Column Name | Type | Description |
---|---|---|
id (PK) | string | Unique Id for the event related to the Named Element. |
name | string | Customer-provided name of the element. |
description | string | Element description |
state | string | Whether or not the element is still active. Values are "active" and "inactive" |
created_time | timestamp | The time in UTC that the element was created. |
created_by | string | The Fullstory user who created the element. |
modified_time | timestamp | The time in UTC that the element was modified. |
modified_by | string | The Fullstory user who modified the element. |
element_properties
Contains properties of elements, including various attributes and metadata. The columns available are customer-dependent.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Unique Id for the related event. |
event_time | timestamp | The time in UTC that the event occurred according to the user's device. |
processed_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
last_updated_time | timestamp | The most recent time an element property was updated. |
product_name | string | An example custom property. |
price | float64 | An example custom property. |
elements_seen
Contains information about watched elements that were seen, including render and visibility durations.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
element_render_duration_millis | int64 | The amount of time that the element was rendered. |
element_start_time | int64 | The time at which the Watched Element was first rendered or made visible. |
element_start_type | string | The 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_type | string | 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_visible_duration_millis | int64 | The amount of time that the element was visible. |
target_raw_selector | string | The full selector path to the event's target element. |
target_text | string | The 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) | string | The id of the most specific, matching customer-configured Named Element in the element_definitions table. |
target_additional_element_definition_ids | array of strings | Additional matching Named Element IDs. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
event_definitions
Contains definitions for Defined Events, including their names, descriptions, and active states.
Column Name | Type | Description |
---|---|---|
id (PK) | string | Unique Id for the event related to the Defined Event. |
name | string | Customer-provided name of the defined event. |
description | string | Event description |
state | string | Whether or not the event is still active. Values are "active" and "inactive" |
created_time | timestamp | The time in UTC that the event was created. |
created_by | string | The Fullstory user who created the event. |
modified_time | timestamp | The time in UTC that the event was modified. |
modified_by | string | The 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 Name | Type | Description |
---|---|---|
id (PK) | string | An unique id representing each event in Fullstory. |
user_id (FK) | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
processed_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
event_type | string | The 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 Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
exception_source_file | string | The source file that produced the exception. |
exception_count | int64 | The number of times that this exception fired within a given window (useful for batching bursts of exceptions fired). |
is_exception_handled | boolean | Whether the exception is caught or not. |
message | string | The message associated with the exception |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
first_input_delays
Contains information about first input delays, including the delay time in milliseconds.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
first_input_delay_millis | int64 | The time from the first user input event to the browser's response. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
force_restarts
Contains information about force restarts, including the elapsed time in milliseconds.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
elapsed_millis | int64 | The number of milliseconds between when the app was backgrounded and when it was started. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
form_abandons
Contains information about form abandons, including the target element and whether the target text was masked.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
target_masked | string | If true, indicates that the target text is empty because it was masked due to a privacy rule |
target_raw_selector | string | The full selector path to the event's target element. |
target_text | string | The text found in an event's target element |
target_element_definition_id (FK) | string | The id of the most specific, matching customer-configured Named Element in the element_definitions table. |
target_additional_element_definition_ids | array of strings | Additional matching Named Element IDs. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional 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 Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
fs_suspicious_kind | json | Indicates 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_masked | string | If true, indicates that the target text is empty because it was masked due to a privacy rule |
target_raw_selector | string | The full selector path to the event's target element. |
target_text | string | The text found in an event's target element |
target_element_definition_id (FK) | string | The id of the most specific, matching customer-configured Named Element in the element_definitions table. |
target_additional_element_definition_ids | array of strings | Additional matching Named Element IDs. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
highlights
Contains information about highlights, including the target element and associated event and element definitions.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
target_raw_selector | string | The full selector path to the event's target element. |
target_text | string | The text found in an event's target element |
target_element_definition_id (FK) | string | The id of the most specific, matching customer-configured Named Element in the element_definitions table. |
target_additional_element_definition_ids | array of strings | Additional matching Named Element IDs. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
interaction_to_next_paints
Contains information about the time from user interaction to the next paint event.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
interaction_to_next_paint_millis | int64 | The time from the first user input event to the next paint event. |
event_name | string | The name of the event that triggered the first user input as reported by the browser. Examples are: keydown and mouseover . |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
keyboard_closes
Contains information about keyboard close events.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
keyboard_opens
Contains information about keyboard open events.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
loads
Contains information about page load events, including various performance metrics.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
dom_content_time_millis | int64 | The time it took for the document to be parsed and the DOM tree to be constructed. |
first_paint_time_millis | int64 | The time of the First Contentful Paint (FCP). |
load_time_millis | int64 | The time it took for the page to load completely. |
largest_paint_time_millis | int64 | The time of the Largest Contentful Paint (LCP). |
time_to_interactive_millis | int64 | The Time to Interactive (TTI) is the time it takes for the page to become fully interactive. |
total_blocking_time_millis | int64 | The Total Blocking Time (TBT) is the total amount of time that the page was blocked after the FCP. |
time_to_first_byte_millis | int64 | The Time to First Byte (TTFB) is the time it takes for the first byte of the response to be received. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
low_memories
Contains information about low memory events, including available and maximum memory.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
memory_available | int64 | The amount of memory available on the device at the time of the event. |
memory_maximum | int64 | The maximum amount of memory available on the device. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
mouse_thrashes
Contains information about mouse thrash events.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
navigates
Contains information about navigation events, including the reason for navigation and any associated API errors.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
navigate_reason | string | Possible 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_errors | string | Any errors encountered when identifying the user through the API. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
page_definitions
Contains definitions for Defined Pages, including their names, descriptions, and active states.
Column Name | Type | Description |
---|---|---|
id (PK) | string | Unique Id for the event related to the Defined Page. |
name | string | Customer-provided name of the defined page. |
description | string | Page description |
is_user_defined | boolean | Indicates whether the page definition was created by a user. |
state | string | Whether or not the page is still active. Values are "active" and "inactive" |
created_time | timestamp | The time in UTC that the page was created. |
created_by | string | The Fullstory user who created the page. |
modified_time | timestamp | The time in UTC that the page was modified. |
modified_by | string | The 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 Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Unique Id for the related event. |
event_time | timestamp | The time in UTC that the event occurred according to the user's device. |
processed_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
last_updated_time | timestamp | The most recent time a page property was updated. |
event_definition_id | string | Foreign key referencing id in the event_definitions table. |
location | string | An example custom property. |
page_views
Contains information about page views, including durations and associated event definitions.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
active_duration_millis | int64 | Number of milliseconds the page was active on a page (as indicated mouse movements, scrolling, and other user interactions). |
duration_millis | int64 | Total amount of time the page was rendered in the browser or app window. |
end_time | timestamp | End time (page unloaded in browser or app) in milliseconds relative to the session start. |
inactive_duration_millis | int64 | Total duration minus active duration. |
start_time | timestamp | Start time (page first rendered) in milliseconds relative to the session start. |
page_name | string | The name of the page as provided through the API. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
pastes
Contains information about paste events, including the target element and whether the target text was masked.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
target_masked | string | If true, indicates that the target text is empty because it was masked due to a privacy rule |
target_raw_selector | string | The full selector path to the event's target element. |
target_text | string | The text found in an event's target element |
target_element_definition_id (FK) | string | The id of the most specific, matching customer-configured Named Element in the element_definitions table. |
target_additional_element_definition_ids | array of strings | Additional matching Named Element IDs. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
requests
Contains information about HTTP requests, including the request method, URL, status, and duration.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Foreign 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_time | timestamp | The time in UTC that the event occurred according to the user's device. |
user_id | string | A 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_id | string | A 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_id | string | If 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_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
request_method | string | The full URL of the request, including the protocol, host, path, query, and hash. |
request_url_full_url | string | The host portion of the URL. |
request_url_host | string | The path portion of the URL. |
request_url_path | string | 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. |
request_url_query | string | The hash path of the URL. |
request_url_hash_path | string | The 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_query | string | The 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_status | string | The 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_millis | string | The duration of the request in milliseconds. |
event_definition_id (FK) | string | The id of the most specific matching customer-configured Defined Event in the event_definitions table. |
additional_event_definition_ids | array of strings | Additional matching event definition IDs |
source_properties
Contains properties of event sources, including various attributes and metadata.
Column Name | Type | Description |
---|---|---|
event_id (PK, FK) | string | Unique Id for the related event. |
event_time | timestamp | The time in UTC that the event occurred according to the user's device. |
processed_time | timestamp | The time in UTC that the event was processed by Fullstory's servers. |
updated_time | timestamp | Indicates when a record was last modified (inserted or updated). |
entrypoint | string | If 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. |
origin | string | If present, indicates where the event was generated. Some examples are: "dom" and "server". |
integration | string | If 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_type | string | The Source Type of the related event. |
initial_referrer_full_url | string | The referrer from the first navigation event in the "view". A full URL including the protocol, host, path, query, and hash. |
initial_referrer_host | string | The referrer from the first navigation event in the "view". The host portion of the URL. e.g. www.example.com. |
initial_referrer_path | string | The referrer from the first navigation event in the "view". The path portion of the URL. e.g. /path/to/page. |
initial_referrer_query | json | The 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_path | string | The hash path of the URL. e.g. #/path/to/page would be represented as /path/to/page . |
initial_referrer_hash_query | json | The 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_country | string | If present, the country associated with the IP address at the start of the associated capture instance. |
location_lat_long | string | If present, the latitude and longitude associated with the IP address. The format is "latitude,longitude". |
location_region | string | If present, the name of the region associated with the IP address. |
page_definition_id | string | The ID of the Page as defined in the Fullstory app. |
url_full_url | string | The URL of the page when the event occurred. A full URL including the protocol, host, path, query, and hash. |
url_host | string | The URL of the page when the event occurred. The host portion of the URL. e.g. www.example.com. |
url_path | string | The URL of the page when the event occurred. The path portion of the URL. e.g. /path/to/page. |
url_query | json | The 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_browser | string | The browser used by the device or Unknown. Example values include: Chrome, Safari, Firefox, Microsoft Edge, and Custom Agent. |
user_agent_browser_version | string | If 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_device | string | If present, the type of device. Example values include: Tablet, Mobile, Desktop, Robot. |
user_agent_operating_system | string | If present, the operating system of the device. Example values include: Windows, OS X, iOS, Android, and Linux. |
user_agent_raw_user_agent | string | An 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_id | string | Identifies a run of FSCLI during iOS native mobile builds. |
app_name | string | The name of the mobile app that produced the event. |
app_package_name | string | Code-level package name of a mobile app, e.g. com.fullstory.sampleapp.latest . |
app_screen_name | string | The name of the mobile app screen on which the event occurred. |
app_version | string | Mobile app version, e.g. 25.0.1 . |
fs_version | string | The version of the Fullstory mobile SDK used to capture the event. Release Notes |
device_screen_height | int64 | Indicates the screen height of the device in pixels. |
device_screen_width | int64 | Indicates the screen width of the device in pixels. |
device_viewport_height | int64 | Indicates the height of the viewport in pixels at the time of the event. |
device_viewport_width | int64 | Indicates the width of the viewport in pixels at the time of the event. |
device_manufacturer | string | If 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_model | string | If 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_system | string | If present, the operating system of the device. Generally available for Mobile Apps, but may also be provided by the server API. |
device_os_version | string | If 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 Name | Type | Description |
---|---|---|
user_id (PK/FK) | string | Unique 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_time | timestamp | The most recent time a user property was updated. |
pricing_plan | string | An example custom property. |
total_spent | float64 | An example custom property. |
disabled | bool | An example custom property. |
users
Contains information about users, including their display names, user IDs, and email addresses.
Column Name | Type | Description |
---|---|---|
id (PK) | string | A 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. |
uid | string | A unique id for the user provided by the customer through the API. |
user_display_name | string | The display name for the user as provided through the API. If none is provided, this will be generated by the Fullstory backend. |
user_email | string | If present, the email address for the user. |
last_updated_time | timestamp | The time the user was last updated. |