# Pendo: Guide

## Description

* Table capturing guides - their latest state enhanced with metrics and relational information. Pendo tracks a variety of events around guides, and event-type-specific visitor-count-metrics are dynamically pivoted out in this table.

## Supported Data Sources

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

## Columns

| Type     | Name                                | Description                                                                                         |
| -------- | ----------------------------------- | --------------------------------------------------------------------------------------------------- |
| STRING   | guide\_id                           | Unique identifier of the guide.                                                                     |
| STRING   | guide\_name                         | Name of the guide.                                                                                  |
| INTEGER  | app\_id                             | Foreign key referencing the `APPLICATION` that the guide belongs in.                                |
| STRING   | state                               | The current state of the guide. published, staged, draft, and disabled.                             |
| STRING   | device\_type                        | The current state of the guide - 'all', 'desktop', 'mobile'.                                        |
| DATETIME | created\_at                         | Timestamp of when the guide was created.                                                            |
| INTEGER  | created\_by\_user\_id               | Foreign key referencing the `USER` who created the guide.                                           |
| BOOLEAN  | is\_multi\_step                     | Returns true if guide has multiple steps (walkthrough).                                             |
| BOOLEAN  | is\_training                        | Boolean that is true if the guide is for training.                                                  |
| STRING   | last\_updated\_at                   | Timestamp of when the guide was last updated.                                                       |
| INTEGER  | last\_updated\_by\_user\_id         | Foreign key referencing the `USER` who last updated the guide.                                      |
| STRING   | launch\_method                      | Activation method of the guide (ie auto, badge, dom).                                               |
| STRING   | published\_at                       | Timestamp of when the guide was officially published.                                               |
| INTEGER  | recurrence                          | How frequent the guide is scheduled to recur.                                                       |
| INTEGER  | recurrence\_eligibility\_window     | Eligible interval in which guides can be repeatedly activated.                                      |
| DATETIME | reset\_at                           | Timestamp of when the guide was reset for visitors.                                                 |
| STRING   | root\_version\_id                   | The unique identifier of the root entity, which nominally matches the public id field of the guide. |
| STRING   | stable\_version\_id                 | The unique identifier for the current version of the feature.                                       |
| DATETIME | \_fivetran\_synced                  | UTC timestamp that indicates the time when Fivetran last successfully synced the row.               |
| INTEGER  | latest\_guide\_index                |                                                                                                     |
| STRING   | app\_display\_name                  | Display name of the application that the guide is a part of.                                        |
| STRING   | app\_platform                       | Platform on which the guide's application is served.                                                |
| STRING   | created\_by\_user\_full\_name       | Full name of the internal user who first created the guide.                                         |
| STRING   | created\_by\_user\_username         | Username (probably email) of the internal user who first created the guide.                         |
| STRING   | last\_updated\_by\_user\_full\_name | Full name of the internal user who last updated the guide.                                          |
| STRING   | last\_updated\_by\_user\_username   | Username (probably email) of the internal user who last updated the guide.                          |
| INTEGER  | count\_steps                        | Number of steps that visitors must navigate to complete the guide.                                  |
| INTEGER  | count\_visitors                     | Count of visitors who have interacted with the guide.                                               |
| INTEGER  | count\_accounts                     | Count of accounts who have been tracked interacting with the guide.                                 |
| INTEGER  | count\_events                       | Count of records in `guide_event` for this guide.                                                   |
| DATETIME | first\_event\_at                    | Timestamp of when the guide was first interacted with.                                              |
| DATETIME | last\_event\_at                     | Timestamp of when the guide was last interacted with.                                               |
| INTEGER  | count\_visitors\_guideSeen          | Count of visitors who have been presented with a guide.                                             |


---

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