Ready to Analyze Views
Anywhere: Warehouse offers two primary methods for accessing your data:
- Raw Data: normalized event data without transformations.
- Ready to Analyze Views: pre-transformed data ready for analysis.
Ready to Analyze Views is the latest method of getting your Fullstory data into your data warehouse with data that is transformed for Business Intelligence use cases. This approach utilizes an industry-standard schema (often referred to as "Silver schema") organized into Fact, Dimension, and Sub-dimension tables.
See the Getting Started page for a detailed comparison to determine which method is right for you.
Destinations
Anywhere: Warehouse supports the following Ready to Analyze Views destinations. For detailed instructions on configuring each destination, visit the specific destination documentation linked below.
Destination | Documentation |
---|---|
Amazon Redshift | Amazon Redshift Views |
BigQuery | BigQuery Views |
Snowflake | Snowflake Views |
Data Model

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 uid
that represents the identifier for the customer's end user, which is
distinct from Fullstory's id
value. 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 Business Intelligence 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
Sync Expectations
Anywhere: Warehouse syncs with destinations on an hourly interval. See each destination's documentation page for details.
Important Timestamps
There are three timestamp fields that are relevant for destinations: event_time
, processed_time
, and updated_time
.
event_time
is an immutable field that records the timestamp of each event according to the user's device.processed_time
is a timestamp field indicating when the event was processed by Fullstory's servers. On average, 95% of events are captured and processed within 20 minutes of the original event time. Several events, including server side events, may reach Fullstory's servers much later than the original event time. Depending on the contents of these late events, Fullstory may need to reprocess them to report on the most accurate metrics, including session length, page active time, etc. In these scenarios, theprocessed_time
for all events in the session or on the page will be updated and the events will be re-synced to the warehouse.updated_time
indicates when a record was last modified (inserted or updated) and is populated by a built-in function in the warehouse during the sync. This field tracks the last time a record in your warehouse was changed and can be used as a filter to determine which new records to pull into your query.
Sync Latency
Sync latency is a concept that tracks the cadence with which Fullstory syncs new events to the destination.
Captured events flow into Fullstory constantly, then are processed on a defined cadence to be sent to the destination.
The interval is dependent on processed_time
, which indicates when our servers processed the event for the particular destination.
For example, when syncing to Snowflake, the sync latency is
Approximately
processed_time
rounded to the next hour + 1 hour.
This is because Fullstory writes data to a file based on the processed_time
, with each file containing events that
were processed in a given hour. The file is then merged into the database table within the next hour. This timing is approximate
because syncing to the destination depends on how large the file is and how much compute is available to run the merge.
Data Dictionary
backgrounds
Indicates that a mobile app was backgrounded.
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). |
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 | integer | The number of rage clicks detected. |
fs_dead_count | integer | 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 |
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. |
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. |
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 |
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). |
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. |
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. |
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 | float | 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 | integer | The amount of time that the element was rendered. |
element_start_time | integer | 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 | integer | 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. |
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. |
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 |
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 | integer | 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 |
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 | integer | The time from the first user input event to the browser's response. |
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 | integer | The number of milliseconds between when the app was backgrounded and when it was started. |
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 |
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 |
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 |
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 | integer | 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 . |
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). |
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). |
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 | integer | The time it took for the document to be parsed and the DOM tree to be constructed. |
first_paint_time_millis | integer | The time of the First Contentful Paint (FCP). |
load_time_millis | integer | The time it took for the page to load completely. |
largest_paint_time_millis | integer | The time of the Largest Contentful Paint (LCP). |
time_to_interactive_millis | integer | The Time to Interactive (TTI) is the time it takes for the page to become fully interactive. |
total_blocking_time_millis | integer | The Total Blocking Time (TBT) is the total amount of time that the page was blocked after the FCP. |
time_to_first_byte_millis | integer | The Time to First Byte (TTFB) is the time it takes for the first byte of the response to be received. |
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 | integer | The amount of memory available on the device at the time of the event. |
memory_maximum | integer | The maximum amount of memory available on the device. |
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). |
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_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. |
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. |
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 | integer | Number of milliseconds the page was active on a page (as indicated mouse movements, scrolling, and other user interactions). |
duration_millis | integer | 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 | integer | 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. |
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. |
max_scroll_depth | integer | Indicates the max scroll depth for the page as a percentage (0-1.0) of the page height that entered the viewport over the total page height. Learn more. This value is only available on web platforms. |
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 |
pinch_gestures
Contains data about pinch gestures with a touch device.
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). |
pinch_gesture_type | string | Possible values: - in : Indicates the pinch led to a scale in.- out : Indicates the pinch led to a scale out. |
pinch_visual_scale_change | float | The change in the visual viewport after a finger pinch. If the change > 1.0, it implies scale in. If the change < 1.0, it implies scale out. If the change is exactly 1.0, it means a failed finger pinch. |
pinch_scale | float | Scale determines the overall page scale at the end of the pinch. It is the ratio of the layout viewport dimensions to visual viewport dimensions. When the page is scaled out to max, the scale is 1.0 and greater than 1.0 otherwise. |
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 HTTP method of the request (e.g., GET, POST, PUT, DELETE). |
request_url_full_url | string | The full URL of the request, including the protocol, host, path, query, and hash. |
request_url_host | string | The host portion of the URL. |
request_url_path | string | The path portion of the URL. |
request_url_query | 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_hash_path | string | The hash path of the URL. |
request_url_hash_query | 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. |
request_status | string | The HTTP status code of the request. |
request_duration_millis | string | The duration of the request in milliseconds. |
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_ip_address | string | If present, the IP address at the start of the associated capture instance. That is, this will be the same for all events with the same device_id, session_id, and view_id. |
location_country | string | If present, the country associated with the IP address at the start of the associated capture instance. |
location_region | string | If present, the name of the region associated with the IP address. |
location_city | string | If present, the name of the city associated with the IP address. |
location_lat_long | string | If present, the latitude and longitude associated with the IP address. The format is "latitude,longitude". |
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. |
title | string | The HTML title of the page when the event occurred. |
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 | The version of the application. For example, the mobile app version: 25.0.1. |
build_variant | string | This outputs the variant being used. For example: Android build variant (e.g. debug, release). |
fs_version | string | The version of the FullStory SDK used. Release Notes |
device_screen_height | integer | Indicates the screen height of the device in pixels. |
device_screen_width | integer | Indicates the screen width of the device in pixels. |
device_viewport_height | integer | Indicates the height of the viewport in pixels at the time of the event. |
device_viewport_width | integer | 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 | float | 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. |