Pendo: Feature Event

Description

• Table capturing all recorded click events matching tagged features. Contains custom columns passed through via the pendo__feature_event_pass_through_columns, as well as 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, if any.
INTEGER	app_id	Foreign key referencing the APPLICATION that the event was tracked in.
STRING	feature_id	Foreign key referencing the FEATURE that the event is tagged with.
INTEGER	num_events	Number of feature events tracked for this unique combination of day/hour, visitorId, accountId, server name, and IP address.
INTEGER	num_minutes	Number of feature events minutes tracked for this unique combination of day/hour, visitorId, accountId, server name, and IP address.
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 property_* and param_* fields.
STRING	feature_event_key	Unique key hashed on ['visitor_id', 'timestamp', 'account_id', 'server_name', 'feature_id', 'remote_ip', 'user_agent', '_fivetran_id'].
STRING	previous_feature_id	Foreign key referencing the feature that the visitor previously interacted with.
DATETIME	previous_feature_event_at	Timestamp of the previous time the visitor interacted with a feature.
INTEGER	previous_feature_num_minutes	The time logged for the visitor's previous interaction with a feature.
INTEGER	previous_feature_num_events	The number of clicks logged for the visitor's previous interaction with a feature.
STRING	feature_name	Name of the feature.
STRING	page_id	Foreign key referencing the PAGE that the feature is placed on.
STRING	page_name	Name of the page that the feature lives on.
STRING	product_area_name	Name of the product area (ie GROUP) that the feature is tagged under.
STRING	product_area_id	Foreign key referencing the GROUP (product area) that the feature is tagged under.
STRING	app_display_name	Display name of the application that the feature is a part of.
STRING	app_platform	Platform on which the feature's application is served.
STRING	previous_feature_name	Name of the previous feature the visitor interacted with.
STRING	previous_feature_page_id	Foreign key referencing the page of the feature that the visitor previously interacted with.
STRING	previous_feature_page_name	Name of the page housing the feature that the visitor previously interacted with.
STRING	previous_feature_product_area_name	Name of the product area (group) that the visitor's previous feature is tagged under.
STRING	previous_feature_product_area_id	Foreign key reference to the product area (group) that the visitor's previous feature is tagged under.