# Pendo: Page Event

## Description

* Table capturing all recorded pageviews matching tagged pages. Contains custom columns passed through the `pendo__page_event_pass_through_columns` variable, as well as any custom `visitor` and `account` columns.

## Supported Data Sources

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

## Columns

| Type     | Name                              | Description                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| -------- | --------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING   | account\_id                       | Foreign key referencing the `ACCOUNT` associated with the event, if any.                                                                                                                                                                                                                                                                                                                                                                    |
| INTEGER  | app\_id                           | Foreign key referencing the `APPLICATION` that the event was tracked in.                                                                                                                                                                                                                                                                                                                                                                    |
| INTEGER  | num\_events                       | Number of pageviews matching tagged pages.                                                                                                                                                                                                                                                                                                                                                                                                  |
| INTEGER  | num\_minutes                      | Page time on site calculations are in 1 minute buckets. So if you are logged in to your app as a user (Pendo Visitor) when you load a page’s URL, 1 minute time on site is calculated. Every time you click on that page, the time on site calculation keeps running and totaling the successive minutes you’ve spent on that page. See <https://support.pendo.io/hc/en-us/articles/360032203171-How-is-Site-Page-Interaction-Calculated->. |
| STRING   | page\_id                          | Foreign key referencing the `PAGE` being loaded.                                                                                                                                                                                                                                                                                                                                                                                            |
| STRING   | remote\_ip                        | The IP address of the event triggerer.                                                                                                                                                                                                                                                                                                                                                                                                      |
| STRING   | server\_name                      | Name of the server (your website) on which the event was tracked.                                                                                                                                                                                                                                                                                                                                                                           |
| DATETIME | occurred\_at                      | Day/hour-part timestamp of when the event occurred.                                                                                                                                                                                                                                                                                                                                                                                         |
| STRING   | user\_agent                       | String identifying the browser and operating system on which the event was triggered.                                                                                                                                                                                                                                                                                                                                                       |
| STRING   | visitor\_id                       | Foreign key referencing the `VISITOR` who triggered the event.                                                                                                                                                                                                                                                                                                                                                                              |
| DATETIME | \_fivetran\_synced                | UTC timestamp that indicates the time when Fivetran last successfully synced the row.                                                                                                                                                                                                                                                                                                                                                       |
| INTEGER  | \_fivetran\_id                    | Fivetran created id hashed on the `param_*` fields.                                                                                                                                                                                                                                                                                                                                                                                         |
| STRING   | page\_event\_key                  | Unique key hashed on \['visitor\_id', 'timestamp', 'account\_id', 'server\_name', 'page\_id', 'user\_agent', 'remote\_ip', '\_fivetran\_id'].                                                                                                                                                                                                                                                                                               |
| STRING   | previous\_page\_id                | Foreign key referencing the `page` that the visitor previously interacted with.                                                                                                                                                                                                                                                                                                                                                             |
| DATETIME | previous\_page\_event\_at         | Timestamp of the previous time the visitor interacted with a page.                                                                                                                                                                                                                                                                                                                                                                          |
| INTEGER  | previous\_page\_num\_minutes      | The time logged for the visitor's previous interaction with a page.                                                                                                                                                                                                                                                                                                                                                                         |
| INTEGER  | previous\_page\_num\_events       | The number of views logged for the visitor's previous interaction with a page.                                                                                                                                                                                                                                                                                                                                                              |
| STRING   | page\_name                        | Name of the page that was viewed.                                                                                                                                                                                                                                                                                                                                                                                                           |
| STRING   | page\_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   | product\_area\_id                 | Foreign key referencing the `GROUP` (product area) 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   | previous\_page\_name              | Name of the page that the visitor previously loaded.                                                                                                                                                                                                                                                                                                                                                                                        |
| STRING   | previous\_product\_area\_name     | Name of the product area (group) that the visitor's previous page is tagged under.                                                                                                                                                                                                                                                                                                                                                          |
| STRING   | previous\_page\_product\_area\_id | Foreign key reference to the product area (group) that the visitor's previous page is tagged under.                                                                                                                                                                                                                                                                                                                                         |


---

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