# Pendo: Account

## Description

* Table capturing accounts - their latest state enhanced with metrics. Includes any custom columns passed through via the `pendo__account_history_pass_through_columns` variable.

## 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                        | Unique identifier of the account.                                                                 |
| STRING   | last\_updated\_at                  | The timestamp (UTC) of when the account was last updated.                                         |
| INTEGER  | account\_id\_hash                  | 32-bit hash of the account ID.                                                                    |
| STRING   | first\_visit\_at                   | The timestamp (UTC) of when the account or visitor was created.                                   |
| STRING   | last\_visit\_at                    | The timestamp (UTC) of when Pendo last recorded an event for the account.                         |
| DATETIME | \_fivetran\_synced                 | UTC timestamp that indicates the time when Fivetran last successfully synced the row.             |
| INTEGER  | latest\_account\_index             |                                                                                                   |
| INTEGER  | count\_associated\_visitors        | Count of visitors associated with the accounts, based on `int_pendo__latest_visitor_account`.     |
| INTEGER  | min\_nps\_rating                   | Of associated visitors' most recent NPS ratings, the minimum rating.                              |
| INTEGER  | max\_nps\_rating                   | Of associated visitors' most recent NPS ratings, the maximum rating.                              |
| INTEGER  | avg\_nps\_rating                   | Of associated visitors' most recent NPS ratings, the average rating.                              |
| INTEGER  | count\_active\_visitors            | Count of visitors who have triggered any kind of event in Pendo.                                  |
| INTEGER  | count\_page\_viewing\_visitors     | Count of visitors who have performed a page event.                                                |
| INTEGER  | count\_feature\_clicking\_visitors | Count of visitors who have performed a feature event.                                             |
| INTEGER  | count\_active\_days                | Count of calendar days on which events were tracked for this account.                             |
| INTEGER  | count\_active\_months              | Count of calendar months on which events were tracked for this account.                           |
| INTEGER  | sum\_minutes                       | Total time, in minutes, of logged event activity for this account (based on `event.num_minutes`). |
| INTEGER  | sum\_events                        | Total number of tracked events for this account (based on `event.num_events`)                     |
| INTEGER  | count\_event\_records              | Count of records in the `EVENT` table logged for this account.                                    |
| INTEGER  | average\_daily\_minutes            | Average minutes logged per day for the account (excluding days with 0 events).                    |
| INTEGER  | average\_daily\_events             | Average events logged per day for the account (excluding days with 0 events).                     |
| DATE     | first\_event\_on                   | Date on which the first event was tracked for this account.                                       |
| DATE     | last\_event\_on                    | Date on which the last event was tracked for this account.                                        |


---

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