# Pardot: Prospects

## Description

* Each record in the table represents a prospect 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  | prospect\_id                             | Pardot ID for this prospect                                                                              |
| BOOLEAN  | \_fivetran\_deleted                      | Boolean representing whether the record has been deleted in the source system.                           |
| DATETIME | \_fivetran\_synced                       | The timestamp of when a record was last synced by Fivetran.                                              |
| INTEGER  | address\_one                             | Prospect's address, line 1                                                                               |
| INTEGER  | address\_two                             | Prospect's address, line 2                                                                               |
| INTEGER  | annual\_revenue                          | Prospect's annual revenue                                                                                |
| INTEGER  | campaign\_id                             | Pardot ID of the campaign associated with this prospect                                                  |
| STRING   | city                                     | Prospect's city                                                                                          |
| INTEGER  | comments                                 | Comments about this prospect                                                                             |
| STRING   | company                                  | Prospect's company                                                                                       |
| STRING   | country                                  | Prospect's country                                                                                       |
| STRING   | created\_timestamp                       | Time prospect is created in Pardot; Time is reported in API user's preferred timezone                    |
| INTEGER  | crm\_account\_fid                        | Account ID in a supported CRM system                                                                     |
| STRING   | crm\_contact\_fid                        | Prospect's contact ID in a supported CRM system                                                          |
| STRING   | crm\_last\_sync                          | Last time this prospect was synced with a supported CRM system                                           |
| INTEGER  | crm\_lead\_fid                           | Prospect's lead ID in a supported CRM system                                                             |
| STRING   | crm\_owner\_fid                          | Prospect's owner ID in a supported CRM system                                                            |
| STRING   | crm\_url                                 | URL to view the prospect within the CRM system                                                           |
| INTEGER  | department                               | Prospect's department                                                                                    |
| STRING   | email                                    | Prospect's email address                                                                                 |
| INTEGER  | employees                                | Prospect's number of employees                                                                           |
| INTEGER  | fax                                      | Prospect's fax number                                                                                    |
| STRING   | first\_name                              | Prospect's first name                                                                                    |
| STRING   | grade                                    | Prospect's letter grade                                                                                  |
| STRING   | industry                                 | Prospect's industry                                                                                      |
| INTEGER  | is\_do\_not\_call                        | If value is 1, prospect prefers not to be called                                                         |
| BOOLEAN  | is\_do\_not\_email                       | If value is 1, prospect prefers not to be emailed                                                        |
| BOOLEAN  | is\_reviewed                             | If value is 1, prospect has been reviewed                                                                |
| INTEGER  | is\_starred                              | If value is 1, prospect has been starred                                                                 |
| STRING   | job\_title                               | Prospect's job title                                                                                     |
| INTEGER  | last\_activity\_at                       | Time stamp of this prospect's latest visitor activity; Time is reported in API user's preferred timezone |
| STRING   | last\_name                               | Prospect's last name                                                                                     |
| INTEGER  | notes                                    | Notes about this prospect                                                                                |
| INTEGER  | opted\_out                               | If value is 1, prospect has opted out of marketing communications                                        |
| INTEGER  | password                                 | Prospect's password                                                                                      |
| STRING   | phone\_number                            | Prospect's phone number                                                                                  |
| INTEGER  | prospect\_account\_id                    | Prospect's account ID                                                                                    |
| STRING   | recent\_interaction                      | Describes the prospect's most recent interaction with Pardot                                             |
| INTEGER  | salutation                               | Prospect's formal prefix                                                                                 |
| INTEGER  | score                                    | Prospect's score                                                                                         |
| STRING   | prospect\_source                         | Prospect's source                                                                                        |
| STRING   | state                                    | Prospect's US state                                                                                      |
| INTEGER  | territory                                | Prospect's territory                                                                                     |
| STRING   | updated\_timestamp                       | Last time prospect was updated in Pardot; Time is reported in API user's preferred timezone              |
| INTEGER  | user\_id                                 | Pardot ID of the user associated with this prospect                                                      |
| STRING   | website                                  | Prospect's website URL                                                                                   |
| INTEGER  | years\_in\_business                      | Prospect's number of years in business                                                                   |
| INTEGER  | zip                                      | Prospect's postal code                                                                                   |
| INTEGER  | count\_activity\_visits                  | Count of visit activities associated with the prospect.                                                  |
| INTEGER  | count\_activity\_emails                  | Count of email activities associated with the prospect.                                                  |
| STRING   | most\_recent\_visit\_activity\_timestamp | Timestamp of most recent visit activity of the prospect.                                                 |
| STRING   | most\_recent\_email\_activity\_timestamp | Timestamp of most recent email activity of the prospect.                                                 |


---

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