Pendo: Guide Event

Description

• Table capturing various types of events related to guide interactions. Contains any visitor and account custom columns.

Supported Data Sources

• Pendo

Columns

Type	Name	Description
STRING	account_id	Foreign key referencing the ACCOUNT associated with the event triggerer, if any.
INTEGER	app_id	Foreign key referencing the APPLICATION the event was triggered in.
STRING	country	Country in which the guide event was recorded.
STRING	guide_id	Foreign key referencing the GUIDE that was interacted with.
STRING	guide_step_id	Foreign key referencing the STEP within the guide that was interacted with specifically.
INTEGER	latitude	Latitude of where the event was triggered from, if location is provided.
INTEGER	longitude	Longitude of where the event was triggered from, if location is provided.
STRING	region	Geographic region of the triggered event, if location is provided.
STRING	remote_ip	IP Address of the event triggerer.
STRING	server_name	Name of the server (your website) on which the event was tracked.
DATETIME	occurred_at	Timestamp of when the event occurred.
STRING	type	Type of guide event that was tracked. Can be one of guideAdvanced, guideSeen, guideDismissed, guideSnoozed, guideTimeout, guideActivity.
STRING	url	URL on which the guide event was recorded.
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 primary key.
STRING	guide_event_key	Unique key hashed on ['visitor_id', 'timestamp', 'account_id', 'server_name', 'guide_id', 'user_agent', 'remote_ip', '_fivetran_id'].
STRING	guide_name	Name of the guide.
STRING	app_display_name	Display name of the application that the guide is a part of.
STRING	app_platform	Platform on which the guide's application is served.