# Pendo: Page

## Description

* Table capturing pages - their latest state enhanced with metrics and relational information.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/pendo/resources/pendo.svg" alt="" data-size="line"> Pendo

## Columns

| Type     | Name                                | Description                                                                                        |
| -------- | ----------------------------------- | -------------------------------------------------------------------------------------------------- |
| STRING   | page\_id                            | Unique identifier of the page.                                                                     |
| STRING   | page\_name                          | Name of the page as displayed in Pendo.                                                            |
| INTEGER  | app\_id                             | Foreign key referencing the `APPLICATION` that the page is associated with.                        |
| DATETIME | created\_at                         | Timestamp of when the page was first created.                                                      |
| INTEGER  | created\_by\_user\_id               | Foreign key referencing the `USER` who created the page.                                           |
| BOOLEAN  | is\_dirty                           | Boolean value returned if page is processing at the time of request.                               |
| STRING   | group\_id                           | Foreign key referencing the `GROUP` (product area) that the page is tagged under.                  |
| STRING   | last\_updated\_at                   | Timestamp of when the page was updated.                                                            |
| INTEGER  | last\_updated\_by\_user\_id         | Foreign key referencing the `USER` who last updated the page.                                      |
| STRING   | root\_version\_id                   | The unique identifier of the root entity, which nominally matches the public id field of the page. |
| STRING   | stable\_version\_id                 | The unique identifier for the current version of the page.                                         |
| DATETIME | valid\_through                      | Timestamp that indicates when data was last processed.                                             |
| DATETIME | \_fivetran\_synced                  | UTC timestamp that indicates the time when Fivetran last successfully synced the row.              |
| INTEGER  | latest\_page\_index                 |                                                                                                    |
| STRING   | rules                               | Comma-separated list of the bare-bones URL rules of the page.                                      |
| STRING   | product\_area\_name                 | Name of the product area (ie `GROUP`) that the page is tagged under.                               |
| STRING   | app\_display\_name                  | Display name of the application that the page is a part of.                                        |
| STRING   | app\_platform                       | Platform on which the page's application is served.                                                |
| STRING   | created\_by\_user\_full\_name       | Full name of the internal user who first created the page.                                         |
| STRING   | created\_by\_user\_username         | Username (probably email) of the internal user who first created the page.                         |
| STRING   | last\_updated\_by\_user\_full\_name | Full name of the internal user who last updated the page.                                          |
| STRING   | last\_updated\_by\_user\_username   | Username (probably email) of the internal user who last updated the page.                          |
| INTEGER  | count\_active\_features             | Count of currently-active features (defined by their `valid_through`) that live on this page.      |
| INTEGER  | count\_visitors                     | Total count of visitors who have viewed this page.                                                 |
| INTEGER  | count\_accounts                     | Total count of accounts who have been tracked viewing this page.                                   |
| INTEGER  | sum\_pageviews                      | The total sum of pageview interactions with this page (based on `num_events`).                     |
| INTEGER  | count\_pageview\_events             | Count of records in `page_event` logged for this page.                                             |
| DATETIME | first\_pageview\_at                 | Timestamp of when this page was first viewed by a visitor.                                         |
| DATETIME | last\_pageview\_at                  | Timestamp of when this page was last viewed by a visitor.                                          |
| INTEGER  | avg\_visitor\_minutes               | Average total time spent on this page per visitor (ignoring 0-event visitors).                     |
| INTEGER  | avg\_visitor\_pageviews             | Average sum of pageview events per visitor (ignoring 0-event visitors).                            |


---

# 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.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.