# Pardot: Lists

## Description

* Each record represents a list in Pardot.

## Supported Data Sources

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

## Columns

| Type     | Name                                     | Description                                                                   |
| -------- | ---------------------------------------- | ----------------------------------------------------------------------------- |
| INTEGER  | list\_id                                 | Pardot ID of this list                                                        |
| STRING   | name                                     | List's name (internal to Pardot)                                              |
| STRING   | description                              | List's description                                                            |
| STRING   | title                                    | List's title (visible to subscribers)                                         |
| BOOLEAN  | is\_crm\_visible                         | If true, list is visible in CRM to add or remove from                         |
| BOOLEAN  | is\_public                               | If true, list will show on EPC pages to prospects                             |
| BOOLEAN  | is\_dynamic                              | If true, list has prospects dynamically added to it via a set of chosen rules |
| STRING   | created\_timestamp                       | Time list is created in Pardot.                                               |
| STRING   | updated\_timestamp                       | Last time list was updated                                                    |
| DATETIME | \_fivetran\_synced                       | The timestamp of when a record was last synced by Fivetran.                   |
| INTEGER  | count\_activity\_emails                  | Count of email activities associated with the members of the list.            |
| INTEGER  | count\_activity\_visits                  | Count of visit activities associated with the members of the list.            |
| STRING   | most\_recent\_email\_activity\_timestamp | Timestamp of most recent email activity of a list member                      |
| STRING   | most\_recent\_visit\_activity\_timestamp | Timestamp of most recent visit activity of a list member                      |


---

# 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/pardot-lists.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.