Pendo: Page

Description

• Table capturing pages - their latest state enhanced with metrics and relational information.

Supported Data Sources

• Pendo

Columns

Type	Name	Description
STRING	page_id	Unique identifier of the page.
STRING	page_name	Name of the page as displayed in Pendo.
INTEGER	app_id	Foreign key referencing the APPLICATION that the page is associated with.
DATETIME	created_at	Timestamp of when the page was first created.
INTEGER	created_by_user_id	Foreign key referencing the USER who created the page.
BOOLEAN	is_dirty	Boolean value returned if page is processing at the time of request.
STRING	group_id	Foreign key referencing the GROUP (product area) that the page is tagged under.
STRING	last_updated_at	Timestamp of when the page was updated.
INTEGER	last_updated_by_user_id	Foreign key referencing the USER who last updated the page.
STRING	root_version_id	The unique identifier of the root entity, which nominally matches the public id field of the page.
STRING	stable_version_id	The unique identifier for the current version of the page.
DATETIME	valid_through	Timestamp that indicates when data was last processed.
DATETIME	_fivetran_synced	UTC timestamp that indicates the time when Fivetran last successfully synced the row.
INTEGER	latest_page_index
STRING	rules	Comma-separated list of the bare-bones URL rules of the page.
STRING	product_area_name	Name of the product area (ie GROUP) that the page is tagged under.
STRING	app_display_name	Display name of the application that the page is a part of.
STRING	app_platform	Platform on which the page's application is served.
STRING	created_by_user_full_name	Full name of the internal user who first created the page.
STRING	created_by_user_username	Username (probably email) of the internal user who first created the page.
STRING	last_updated_by_user_full_name	Full name of the internal user who last updated the page.
STRING	last_updated_by_user_username	Username (probably email) of the internal user who last updated the page.
INTEGER	count_active_features	Count of currently-active features (defined by their valid_through) that live on this page.
INTEGER	count_visitors	Total count of visitors who have viewed this page.
INTEGER	count_accounts	Total count of accounts who have been tracked viewing this page.
INTEGER	sum_pageviews	The total sum of pageview interactions with this page (based on num_events).
INTEGER	count_pageview_events	Count of records in page_event logged for this page.
DATETIME	first_pageview_at	Timestamp of when this page was first viewed by a visitor.
DATETIME	last_pageview_at	Timestamp of when this page was last viewed by a visitor.
INTEGER	avg_visitor_minutes	Average total time spent on this page per visitor (ignoring 0-event visitors).
INTEGER	avg_visitor_pageviews	Average sum of pageview events per visitor (ignoring 0-event visitors).