Product Analytics

Docs > DDSQL Reference > Data Directory > Product Analytics

This dataset represents Product Analytics data collected by Datadog, built on top of Real User Monitoring (RUM). Product Analytics provides insights into user behavior, engagement, and conversion across web and mobile applications. It enables analysis of user journeys, funnels, feature adoption, and product usage patterns to drive data-driven product decisions.

dd.product_analytics

Product Analytics Public Documentation

Product Analytics Explorer Documentation

Query Parameters

This dataset uses a polymorphic table function. You must specify parameters when querying.

Parameter	Type	Required	Description
`columns`	`array<string>`	Yes	List of fields to return for each event (e.g., ’timestamp’, ‘@session.id’, ‘@view.url’, ‘@action.name’). Must follow with AS (…) to name and type outputs.
`event_type`	`string`	No	Optional event subtype to filter by (e.g., event_type => ‘action’).
`filter`	`string`	No	Optional search string. For example: filter => ‘@application.name:my-app AND @action.type:click’.
`from_timestamp`	`string`	No	Lower time bound for the query; defaults to the query context if omitted.
`to_timestamp`	`string`	No	Upper time bound for the query; defaults to the query context if omitted.

Example Queries

-- Analyze user actions for funnel analysis
SELECT * FROM dd.product_analytics(
  columns => ARRAY[
    'timestamp',
    '@session.id',
    '@usr.id',
    '@view.url',
    '@action.name',
    '@action.type',
    '@device.type',
    '@geo.country'
  ],
  event_type => 'action',
  filter => '@application.name:checkout-app',
  from_timestamp => now() - interval '7 days',
  to_timestamp => now()
) AS (
  ts           TIMESTAMP,
  session_id   VARCHAR,
  user_id      VARCHAR,
  page_url     VARCHAR,
  action_name  VARCHAR,
  action_type  VARCHAR,
  device_type  VARCHAR,
  country      VARCHAR
);

Fields

Title	ID	Type	Data Type	Description
Timestamp	timestamp	core	timestamp	Time the event was recorded. Applies to: all.
Event Type	@type	event_attribute	string	Type of event (session, view, action). Applies to: all.
Application ID	@application.id	event_attribute	string	Unique identifier for the application. Applies to: all.
Application Name	@application.name	event_attribute	string	Name of the application (e.g., my-web-app). Applies to: all.
Session ID	@session.id	event_attribute	string	Unique identifier for the user session. Applies to: all.
Session Type	@session.type	event_attribute	string	Type of session (user, synthetics). Applies to: all.
Session Active	@session.is_active	event_attribute	bool	Whether the session is currently active. Applies to: session.
Session Time Spent	@session.time_spent	event_attribute	int64	Total time spent in the session in nanoseconds. Applies to: session.
Session View Count	@session.view.count	event_attribute	int64	Number of page views in the session. Applies to: session.
Session Action Count	@session.action.count	event_attribute	int64	Number of user actions in the session. Applies to: session.
Session Error Count	@session.error.count	event_attribute	int64	Number of errors in the session. Applies to: session.
Session Frustration Count	@session.frustration.count	event_attribute	int64	Number of frustration signals in the session. Applies to: session.
Session Referrer	@session.referrer	event_attribute	string	Referrer URL that led to the session. Applies to: session.
Landing Page Path	@session.initial_view.url_path	event_attribute	string	Path of the first page viewed in the session. Applies to: session.
Exit Page Path	@session.last_view.url_path	event_attribute	string	Path of the last page viewed in the session. Applies to: session.
View ID	@view.id	event_attribute	string	Unique identifier for the page view. Applies to: view, action.
View URL	@view.url	event_attribute	string	Full URL of the page. Applies to: view, action.
View URL Host	@view.url_host	event_attribute	string	Host portion of the view URL. Applies to: view, action.
View URL Path	@view.url_path	event_attribute	string	Path portion of the view URL. Applies to: view, action.
View URL Path Group	@view.url_path_group	event_attribute	string	Parameterized path group for grouping similar pages. Applies to: view, action.
View Name	@view.name	event_attribute	string	User-friendly name for the page/view. Applies to: view, action.
View Time Spent	@view.time_spent	event_attribute	int64	Time spent on the page in nanoseconds. Applies to: view.
View Action Count	@view.action.count	event_attribute	int64	Number of user actions on the page. Applies to: view.
View Error Count	@view.error.count	event_attribute	int64	Number of errors on the page. Applies to: view.
View Frustration Count	@view.frustration.count	event_attribute	int64	Number of frustration signals on the page. Applies to: view.
Action ID	@action.id	event_attribute	string	Unique identifier for the user action. Applies to: action.
Action Type	@action.type	event_attribute	string	Type of action (click, tap, scroll, custom). Applies to: action.
Action Name	@action.name	event_attribute	string	User-friendly name for the action (e.g., 'Add to Cart', 'Submit Form'). Applies to: action.
Action Target	@action.target.name	event_attribute	string	Name or identifier of the target element. Applies to: action.
Action Loading Time	@action.loading_time	event_attribute	int64	Time to complete the action in nanoseconds. Applies to: action.
Frustration Type	@action.frustration.type	event_attribute	string	Type of frustration signal (dead_click, rage_click, error_click). Applies to: action.
User ID	@usr.id	event_attribute	string	Unique identifier for the user. Applies to: all.
User Email	@usr.email	event_attribute	string	Email address of the user. Applies to: all.
User Name	@usr.name	event_attribute	string	Display name of the user. Applies to: all.
Device Type	@device.type	event_attribute	string	Type of device (desktop, mobile, tablet). Applies to: all.
Device Brand	@device.brand	event_attribute	string	Brand of the device (e.g., Apple, Samsung). Applies to: all.
Device Model	@device.model	event_attribute	string	Model of the device. Applies to: all.
OS Name	@os.name	event_attribute	string	Operating system name (e.g., iOS, Android, Windows). Applies to: all.
OS Version	@os.version	event_attribute	string	Operating system version. Applies to: all.
Browser Name	@browser.name	event_attribute	string	Browser name (e.g., Chrome, Safari, Firefox). Applies to: all.
Browser Version	@browser.version	event_attribute	string	Browser version. Applies to: all.
Country	@geo.country	event_attribute	string	Country name from geo IP lookup. Applies to: all.
Country ISO Code	@geo.country_iso_code	event_attribute	string	ISO country code from geo IP lookup. Applies to: all.
City	@geo.city	event_attribute	string	City name from geo IP lookup. Applies to: all.
Continent	@geo.continent	event_attribute	string	Continent name from geo IP lookup. Applies to: all.
Region	@geo.region	event_attribute	string	Region or state name from geo IP lookup. Applies to: all.
Page Referrer	@view.referrer	event_attribute	string	Referrer URL for the page view. Applies to: view.
UTM Source	@session.referrer_utm_source	event_attribute	string	UTM source parameter from the referrer. Applies to: session.
Event ID	id	core	string	A unique identifier for the event.
Discovery Timestamp	discovery_timestamp	core	int64	The time when Datadog first received the event (milliseconds since Unix epoch). May differ from timestamp if there was an ingestion delay.
Tiebreaker	tiebreaker	core	int64	A value used to establish deterministic ordering among events that share the same timestamp.
Ingest Size	ingest_size_in_bytes	core	int64	The size of the event payload in bytes at the time of ingestion, before any processing.
Random Draw	random_draw	core	float64	A random value between 0.0 and 1.0 assigned at ingestion, useful for consistent sampling across queries.