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