Pendo: Page Daily Metrics

Description

• Table capturing daily event metrics for tracked pages, 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	page_id	Unique identifier of the page.
STRING	page_name	Name of the page.
STRING	group_id	Foreign key referencing the GROUP (product area) that the page is tagged under.
STRING	product_area_name	Name of the product area (ie GROUP) that the page is tagged under.
INTEGER	sum_pageviews	Total daily number of tracked views (based on event.num_events)
INTEGER	count_visitors	Count of distinct visitors who viewed on the page on this day.
INTEGER	count_accounts	Count of distinct accounts that were logged in page_event on this day.
INTEGER	count_first_time_visitors	Count of visitors for whom their first interaction with the page was on this day.
INTEGER	count_first_time_accounts	Count of accounts for whom their first interaction with the page was on this day.
INTEGER	count_return_visitors	Count of visitors who clicked on the page prior to this day as well.
INTEGER	count_return_accounts	Count of accounts who clicked on the page prior to this day as well.
INTEGER	avg_daily_minutes_per_visitor	For the day, the average time spent viewing the page per visitor.
INTEGER	avg_daily_pageviews_per_visitor	For the day, the average sum of pageviews per visitor.
INTEGER	percent_of_daily_pageviews	Relative to the total number of views of ALL pages, the percentage that were views on this page.
INTEGER	percent_of_daily_page_visitors	Relative to the total number of visitors viewing ALL pages, the percentage that were visitors viewing this page.
INTEGER	percent_of_daily_page_accounts	Relative to the total number of accounts viewing ALL pages, the percentage that were accounts viewing this page.
INTEGER	count_pageview_events	Count of records in page_event for this page on this day.