Ready to Analyze Views

This functionality is a part of Anywhere: Warehouse. To learn more about Fullstory Anywhere, please visit this page.

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

As of July 31, 2025, all new connections to the destinations above will use the Ready to Analyze Views format. Customers who wish to upgrade to the newest connection format should reach out to a member of their Fullstory account team.

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.

Do you need access to real-time Fullstory event data for your solution? Check out Anywhere: Activation. While Warehouse is comprehensive of all your behavioral data, Activation is designed to provide surgical, specific streams of high-value events or patterns.

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 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 sub-fact tables.
element_definition_id (FK)	string	The id of the most specific, matching customer-configured Named Element in the element_definitions table that was the target of the event.
additional_element_definition_ids	array of strings	Additional matching Named Element IDs for event targets.
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.
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).
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.