Pendo: Feature

Description

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

Supported Data Sources

• Pendo

Columns

Type	Name	Description
STRING	feature_id	Unique identifier of the feature.
INTEGER	app_id	Foreign key referencing the APPLICATION that the feature is a part of.
DATETIME	created_at	Timestamp of when the feature was created.
INTEGER	created_by_user_id	Foreign key referencing the USER that created the feature.
BOOLEAN	is_dirty	Boolean value returned if feature is processing at the time of request.
STRING	group_id	Foreign key referencing the GROUP (product area) that the feature is tagged under.
BOOLEAN	is_core_event	Boolean that is true if the feature is tagged as a core event/key feature of the product.
STRING	last_updated_at	Timestamp of when the feature was last updated.
INTEGER	last_updated_by_user_id	Foreign key referencing the USER that last updated the feature.
STRING	feature_name	Name of the feature.
STRING	page_id	Foreign key referencing the PAGE that the feature is placed on.
STRING	root_version_id	The unique identifier of the root entity, which nominally matches the public id field of the feature.
STRING	stable_version_id	The unique identifier for the current version of the feature.
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.
STRING	product_area_name	Name of the product area (ie GROUP) that the feature is tagged under.
STRING	page_name	Name of the page that the feature lives on.
DATETIME	page_created_at	Timestamp of when the feature's page was created.
DATETIME	page_valid_through	Timestamp that indicates when data was last processed for the feature's page.
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	created_by_user_full_name	Full name of the internal user who first created the feature.
STRING	created_by_user_username	Username (probably email) of the internal user who first created the feature.
STRING	last_updated_by_user_full_name	Full name of the internal user who last updated the feature.
STRING	last_updated_by_user_username	Username (probably email) of the internal user who last updated the feature.
INTEGER	count_visitors	Count of distinct visitors who have clicked on this feature.
INTEGER	count_accounts	Count of distinct accounts who have been tracked clicking this feature.
INTEGER	sum_clicks	The total sum of click interactions with this feature (based on num_events).
INTEGER	count_click_events	Count of records in feature_event logged for this feature.
DATETIME	first_click_at	Timestamp of when a visitor first clicked on this feature.
DATETIME	last_click_at	Timestamp of when a visitor last clicked on this feature.
INTEGER	avg_visitor_minutes	Average total time spent on this feature per visitor (ignoring 0-event visitors).
INTEGER	avg_visitor_events	Average sum of feature click events per visitor (ignoring 0-event visitors).