# Pendo: Feature Daily Metrics

## Description

* Table capturing daily event metrics for tracked features, 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  | feature\_id                           | Unique identifier of the feature.                                                                                              |
| STRING  | feature\_name                         | Name of the feature.                                                                                                           |
| STRING  | group\_id                             | Foreign key referencing the `GROUP` (product area) that the feature is tagged under.                                           |
| STRING  | product\_area\_name                   | Name of the product area (ie `GROUP`) that the feature is tagged under.                                                        |
| STRING  | page\_id                              | Foreign key referencing the `PAGE` that the feature is placed on.                                                              |
| STRING  | page\_name                            | Name of the page that the feature lives on.                                                                                    |
| INTEGER | sum\_clicks                           | Total daily number of tracked clicks (based on `event.num_events`)                                                             |
| INTEGER | count\_visitors                       | Count of distinct visitors who clicked on the feature on this day.                                                             |
| INTEGER | count\_accounts                       | Count of distinct accounts that were logged in `feature_event` on this day.                                                    |
| INTEGER | count\_first\_time\_visitors          | Count of visitors for whom their first interaction with the feature was on this day.                                           |
| INTEGER | count\_first\_time\_accounts          | Count of accounts for whom their first interaction with the feature was on this day.                                           |
| INTEGER | count\_return\_visitors               | Count of visitors who clicked on the feature prior to this day as well.                                                        |
| INTEGER | count\_return\_accounts               | Count of accounts who clicked on the feature prior to this day as well.                                                        |
| INTEGER | avg\_daily\_minutes\_per\_visitor     | For the day, the average time spent interacting with the feature per visitor.                                                  |
| INTEGER | avg\_daily\_clicks\_per\_visitor      | For the day, the average sum of clicks per visitor.                                                                            |
| INTEGER | percent\_of\_daily\_feature\_clicks   | Relative to the total number of clicks on ALL features, the percentage that were clicks on this feature.                       |
| INTEGER | percent\_of\_daily\_feature\_visitors | Relative to the total number of visitors clicking on ALL features, the percentage that were visitors clicking on this feature. |
| INTEGER | percent\_of\_daily\_feature\_accounts | Relative to the total number of accounts clicking on ALL features, the percentage that were accounts clicking on this feature. |
| INTEGER | count\_click\_events                  | Count of records in `feature_event` for this feature 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-feature-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.