Pendo: Visitor

Description

• Table capturing individual visitors - 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	visitor_id	Unique identifier of the visitor.
STRING	account_id	Foreign key referencing the ACCOUNT associated with this visitor. Visitors can belong to multiple accounts, however. Refer to VISITOR_ACCOUNT_HISTORY for all accounts associated with individual visitors.
STRING	first_visit_at	Timestamp of when an event was first captured for the visitor.
INTEGER	visitor_id_hash	32-bit hash of the visitor ID.
STRING	last_browser_name	Most recent browser name.
STRING	last_browser_version	Most recent browser version.
STRING	last_operating_system	Most recent operating system.
STRING	last_server_name	Most recent server name.
STRING	last_updated_at	Timestamp of when the visitor was last updated.
STRING	last_user_agent	Most recent user agent (unparsed).
STRING	last_visit	Timestamp of the user's last visit.
INTEGER	n_id	Numeric id for the visitor.
DATETIME	_fivetran_synced	UTC timestamp that indicates the time when Fivetran last successfully synced the row.
INTEGER	latest_visitor_index
INTEGER	count_associated_accounts	Count of accounts currently associated with the visitor.
INTEGER	latest_nps_rating	The latest NPS rating that the visitor submitted via a poll.
INTEGER	count_active_days	Count of calendar days on which events were tracked for this visitor.
INTEGER	count_active_months	Count of calendar months on which events were tracked for this visitor.
INTEGER	sum_minutes	Total time, in minutes, of logged event activity for this visitor (based on event.num_minutes).
INTEGER	sum_events	Total number of tracked events for this visitor (based on event.num_events)
INTEGER	count_event_records	Count of records in the EVENT table logged for this visitor.
INTEGER	average_daily_minutes	Of days on which they were active, the average total daily tracked time.
INTEGER	average_daily_events	Of days on which they were active, the average total daily sum of events.
DATE	first_event_on	Date on which the first event was tracked for this visitor.
DATE	last_event_on	Date on which the last event was tracked for this visitor.