Pendo: Page Event

Description

• Table capturing all recorded pageviews matching tagged pages. Contains custom columns passed through the pendo__page_event_pass_through_columns variable, as well as any custom visitor and account columns.

Supported Data Sources

• Pendo

Columns

Type	Name	Description
STRING	account_id	Foreign key referencing the ACCOUNT associated with the event, if any.
INTEGER	app_id	Foreign key referencing the APPLICATION that the event was tracked in.
INTEGER	num_events	Number of pageviews matching tagged pages.
INTEGER	num_minutes	Page time on site calculations are in 1 minute buckets. So if you are logged in to your app as a user (Pendo Visitor) when you load a page’s URL, 1 minute time on site is calculated. Every time you click on that page, the time on site calculation keeps running and totaling the successive minutes you’ve spent on that page. See https://support.pendo.io/hc/en-us/articles/360032203171-How-is-Site-Page-Interaction-Calculated-.
STRING	page_id	Foreign key referencing the PAGE being loaded.
STRING	remote_ip	The IP address of the event triggerer.
STRING	server_name	Name of the server (your website) on which the event was tracked.
DATETIME	occurred_at	Day/hour-part timestamp of when the event occurred.
STRING	user_agent	String identifying the browser and operating system on which the event was triggered.
STRING	visitor_id	Foreign key referencing the VISITOR who triggered the event.
DATETIME	_fivetran_synced	UTC timestamp that indicates the time when Fivetran last successfully synced the row.
INTEGER	_fivetran_id	Fivetran created id hashed on the param_* fields.
STRING	page_event_key	Unique key hashed on ['visitor_id', 'timestamp', 'account_id', 'server_name', 'page_id', 'user_agent', 'remote_ip', '_fivetran_id'].
STRING	previous_page_id	Foreign key referencing the page that the visitor previously interacted with.
DATETIME	previous_page_event_at	Timestamp of the previous time the visitor interacted with a page.
INTEGER	previous_page_num_minutes	The time logged for the visitor's previous interaction with a page.
INTEGER	previous_page_num_events	The number of views logged for the visitor's previous interaction with a page.
STRING	page_name	Name of the page that was viewed.
STRING	page_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	product_area_id	Foreign key referencing the GROUP (product area) 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	previous_page_name	Name of the page that the visitor previously loaded.
STRING	previous_product_area_name	Name of the product area (group) that the visitor's previous page is tagged under.
STRING	previous_page_product_area_id	Foreign key reference to the product area (group) that the visitor's previous page is tagged under.