Skip to main content
Version: v2

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.

DestinationDocumentation
Amazon RedshiftAmazon Redshift Views
BigQueryBigQuery Views
SnowflakeSnowflake Views

Data Model

Silver ERD

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

Fact Tables

The Events Table

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

Events Table

Event-type Tables

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

Event Type Tables

Dimension Tables

The Users Table

Select Fullstory Data Capture APIs, such as the Browser API, iOS API, Android API, Server API, contain a customer-defined 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.

Users Table

Customer-defined labels

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

Customer Defined Label Tables

Subdimension Tables

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

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

Subdimension Tables

Sample Queries

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

clicks

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

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

consents

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

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

console_messages

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

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

copies

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

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

crashes

Contains information about mobile app crash events

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

cumulative_layout_shifts

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

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

custom_events

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

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

element_definitions

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

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

element_properties

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

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

elements_seen

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

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

event_definitions

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

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

events

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

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

exceptions

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

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

first_input_delays

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

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

form_input_changes

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

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

Possible values:
- sql_injection: The activity appears to be a SQL injection attack.
- xss: The activity appears to be a cross-site scripting (XSS) attack.
target_maskedstringIf true, indicates that the target text is empty because it was masked due to a privacy rule
target_raw_selectorstringThe full selector path to the event's target element.
target_textstringThe text found in an event's target element

highlights

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

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

interaction_to_next_paints

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

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

keyboard_closes

Contains information about keyboard close events.

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

keyboard_opens

Contains information about keyboard open events.

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

loads

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

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
dom_content_time_millisintegerThe time it took for the document to be parsed and the DOM tree to be constructed.
first_paint_time_millisintegerThe time of the First Contentful Paint (FCP).
load_time_millisintegerThe time it took for the page to load completely.
largest_paint_time_millisintegerThe time of the Largest Contentful Paint (LCP).
time_to_interactive_millisintegerThe Time to Interactive (TTI) is the time it takes for the page to become fully interactive.
total_blocking_time_millisintegerThe Total Blocking Time (TBT) is the total amount of time that the page was blocked after the FCP.
time_to_first_byte_millisintegerThe 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 NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
memory_availableintegerThe amount of memory available on the device at the time of the event.
memory_maximumintegerThe maximum amount of memory available on the device.

mouse_thrashes

Contains information about mouse thrash events.

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

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

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

Possible values:
- sql_injection: The activity appears to be a SQL injection attack.
- xss: The activity appears to be a cross-site scripting (XSS) attack.

page_definitions

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

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

page_properties

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

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

page_views

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

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

Possible values:
- sql_injection: The activity appears to be a SQL injection attack.
- xss: The activity appears to be a cross-site scripting (XSS) attack.
max_scroll_depthintegerIndicates 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 NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
target_maskedstringIf true, indicates that the target text is empty because it was masked due to a privacy rule
target_raw_selectorstringThe full selector path to the event's target element.
target_textstringThe text found in an event's target element

pinch_gestures

Contains data about pinch gestures with a touch device.

Column NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
pinch_gesture_typestringPossible values:
- in: Indicates the pinch led to a scale in.
- out: Indicates the pinch led to a scale out.
pinch_visual_scale_changefloatThe 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_scalefloatScale 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 NameTypeDescription
event_id (PK, FK)stringForeign key referencing event_id in the fact event table. This is a unique identifier for a single event. This field should only be joined to other tables using event_id.
event_timetimestampThe time in UTC that the event occurred according to the user's device.
user_idstringA unique id assigned to the user by Fullstory. For web recording, the ID corresponds to a unique user cookie. For mobile recording, this corresponds to a single app/device combo.
session_idstringA unique id corresponding to a single session. Events sent from the server API may not be associated with a session and the session_id value could be null.
view_idstringIf present, a unique id associating multiple events to a single page, screen or tab. This value combined with session_id uniquely identifies the view. For web recording, this corresponds to a single page load. For mobile recording, this corresponds to a continuous period of recording.
processed_timetimestampThe time in UTC that the event was processed by Fullstory's servers.
updated_timetimestampIndicates when a record was last modified (inserted or updated).
request_methodstringThe HTTP method of the request (e.g., GET, POST, PUT, DELETE).
request_url_full_urlstringThe full URL of the request, including the protocol, host, path, query, and hash.
request_url_hoststringThe host portion of the URL.
request_url_pathstringThe path portion of the URL.
request_url_querystringThe 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_pathstringThe hash path of the URL.
request_url_hash_querystringThe 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_statusstringThe HTTP status code of the request.
request_duration_millisstringThe duration of the request in milliseconds.

source_properties

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

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

user_properties

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

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

users

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

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