Pendo: Account

Description

• Table capturing accounts - their latest state enhanced with metrics. Includes any custom columns passed through via the pendo__account_history_pass_through_columns variable.

Supported Data Sources

• Pendo

Columns

Type	Name	Description
STRING	account_id	Unique identifier of the account.
STRING	last_updated_at	The timestamp (UTC) of when the account was last updated.
INTEGER	account_id_hash	32-bit hash of the account ID.
STRING	first_visit_at	The timestamp (UTC) of when the account or visitor was created.
STRING	last_visit_at	The timestamp (UTC) of when Pendo last recorded an event for the account.
DATETIME	_fivetran_synced	UTC timestamp that indicates the time when Fivetran last successfully synced the row.
INTEGER	latest_account_index
INTEGER	count_associated_visitors	Count of visitors associated with the accounts, based on int_pendo__latest_visitor_account.
INTEGER	min_nps_rating	Of associated visitors' most recent NPS ratings, the minimum rating.
INTEGER	max_nps_rating	Of associated visitors' most recent NPS ratings, the maximum rating.
INTEGER	avg_nps_rating	Of associated visitors' most recent NPS ratings, the average rating.
INTEGER	count_active_visitors	Count of visitors who have triggered any kind of event in Pendo.
INTEGER	count_page_viewing_visitors	Count of visitors who have performed a page event.
INTEGER	count_feature_clicking_visitors	Count of visitors who have performed a feature event.
INTEGER	count_active_days	Count of calendar days on which events were tracked for this account.
INTEGER	count_active_months	Count of calendar months on which events were tracked for this account.
INTEGER	sum_minutes	Total time, in minutes, of logged event activity for this account (based on event.num_minutes).
INTEGER	sum_events	Total number of tracked events for this account (based on event.num_events)
INTEGER	count_event_records	Count of records in the EVENT table logged for this account.
INTEGER	average_daily_minutes	Average minutes logged per day for the account (excluding days with 0 events).
INTEGER	average_daily_events	Average events logged per day for the account (excluding days with 0 events).
DATE	first_event_on	Date on which the first event was tracked for this account.
DATE	last_event_on	Date on which the last event was tracked for this account.