Pendo: Guide

Description

• Table capturing guides - their latest state enhanced with metrics and relational information. Pendo tracks a variety of events around guides, and event-type-specific visitor-count-metrics are dynamically pivoted out in this table.

Supported Data Sources

• Pendo

Columns

Type	Name	Description
STRING	guide_id	Unique identifier of the guide.
STRING	guide_name	Name of the guide.
INTEGER	app_id	Foreign key referencing the APPLICATION that the guide belongs in.
STRING	state	The current state of the guide. published, staged, draft, and disabled.
STRING	device_type	The current state of the guide - 'all', 'desktop', 'mobile'.
DATETIME	created_at	Timestamp of when the guide was created.
INTEGER	created_by_user_id	Foreign key referencing the USER who created the guide.
BOOLEAN	is_multi_step	Returns true if guide has multiple steps (walkthrough).
BOOLEAN	is_training	Boolean that is true if the guide is for training.
STRING	last_updated_at	Timestamp of when the guide was last updated.
INTEGER	last_updated_by_user_id	Foreign key referencing the USER who last updated the guide.
STRING	launch_method	Activation method of the guide (ie auto, badge, dom).
STRING	published_at	Timestamp of when the guide was officially published.
INTEGER	recurrence	How frequent the guide is scheduled to recur.
INTEGER	recurrence_eligibility_window	Eligible interval in which guides can be repeatedly activated.
DATETIME	reset_at	Timestamp of when the guide was reset for visitors.
STRING	root_version_id	The unique identifier of the root entity, which nominally matches the public id field of the guide.
STRING	stable_version_id	The unique identifier for the current version of the feature.
DATETIME	_fivetran_synced	UTC timestamp that indicates the time when Fivetran last successfully synced the row.
INTEGER	latest_guide_index
STRING	app_display_name	Display name of the application that the guide is a part of.
STRING	app_platform	Platform on which the guide's application is served.
STRING	created_by_user_full_name	Full name of the internal user who first created the guide.
STRING	created_by_user_username	Username (probably email) of the internal user who first created the guide.
STRING	last_updated_by_user_full_name	Full name of the internal user who last updated the guide.
STRING	last_updated_by_user_username	Username (probably email) of the internal user who last updated the guide.
INTEGER	count_steps	Number of steps that visitors must navigate to complete the guide.
INTEGER	count_visitors	Count of visitors who have interacted with the guide.
INTEGER	count_accounts	Count of accounts who have been tracked interacting with the guide.
INTEGER	count_events	Count of records in guide_event for this guide.
DATETIME	first_event_at	Timestamp of when the guide was first interacted with.
DATETIME	last_event_at	Timestamp of when the guide was last interacted with.
INTEGER	count_visitors_guideSeen	Count of visitors who have been presented with a guide.