# 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

* <img src="https://fivetran.com/integrations/pendo/resources/pendo.svg" alt="" data-size="line"> 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.                                                      |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/pendo-page-daily-metrics.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.