Pendo: Feature Daily Metrics

Description

• Table capturing daily event metrics for tracked features, from the day that the feature was created to either it's valid_through date or the date of its last tracked event (whichever is later).

Supported Data Sources

• Pendo

Columns

Type	Name	Description
DATE	date_day	Day for which these metrics were calculated.
STRING	feature_id	Unique identifier of the feature.
STRING	feature_name	Name of the feature.
STRING	group_id	Foreign key referencing the GROUP (product area) that the feature is tagged under.
STRING	product_area_name	Name of the product area (ie GROUP) that the feature is tagged under.
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.
INTEGER	sum_clicks	Total daily number of tracked clicks (based on event.num_events)
INTEGER	count_visitors	Count of distinct visitors who clicked on the feature on this day.
INTEGER	count_accounts	Count of distinct accounts that were logged in feature_event on this day.
INTEGER	count_first_time_visitors	Count of visitors for whom their first interaction with the feature was on this day.
INTEGER	count_first_time_accounts	Count of accounts for whom their first interaction with the feature was on this day.
INTEGER	count_return_visitors	Count of visitors who clicked on the feature prior to this day as well.
INTEGER	count_return_accounts	Count of accounts who clicked on the feature prior to this day as well.
INTEGER	avg_daily_minutes_per_visitor	For the day, the average time spent interacting with the feature per visitor.
INTEGER	avg_daily_clicks_per_visitor	For the day, the average sum of clicks per visitor.
INTEGER	percent_of_daily_feature_clicks	Relative to the total number of clicks on ALL features, the percentage that were clicks on this feature.
INTEGER	percent_of_daily_feature_visitors	Relative to the total number of visitors clicking on ALL features, the percentage that were visitors clicking on this feature.
INTEGER	percent_of_daily_feature_accounts	Relative to the total number of accounts clicking on ALL features, the percentage that were accounts clicking on this feature.
INTEGER	count_click_events	Count of records in feature_event for this feature on this day.