ProspectAccounts
Query the available prospect accounts.
Table Specific Information
Select
The connector will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM ProspectAccounts WHERE Id > 31
Get Deleted
To retrieve deleted prospect accounts, a GETDELETED statement can be executed.
GETDELETED FROM ProspectAccounts
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Int64 | True |
ID of the object. | |
| Name | String | True |
Name of the object. | |
| SalesforceId | String | True |
ID of the Salesforce object representing this object. | |
| IsDeleted | Boolean | True |
True if the object is in the recycle bin in Pardot. | |
| AnnualRevenue | String | True |
Annual Revenue of the object. | |
| BillingAddressOne | String | True |
Billing Address of the object. | |
| BillingAddressTwo | String | True |
Second Billing Address of the object. | |
| BillingCity | String | True |
City of the object. | |
| BillingCountry | String | True |
County of the object. | |
| BillingState | String | True |
State of the object. | |
| BillingZip | String | True |
Zip of the object. | |
| Description | String | True |
Description of the object. | |
| Employees | String | True |
Employees of the object. | |
| Fax | String | True |
Fax of the object. | |
| Industry | String | True |
Industry of the object. | |
| Number | String | True |
Number of the object. | |
| Ownership | String | True |
Ownership of the object. | |
| Phone | String | True |
Phone Number of the object. | |
| Rating | String | True |
Rating of the object. | |
| ShippingAddressOne | String | True |
Shipping Address of the object. | |
| ShippingAddressTwo | String | True |
Second Shipping Address of the object. | |
| ShippingCity | String | True |
Shipping Address city of the object. | |
| ShippingCountry | String | True |
Shipping Address country of the object. | |
| ShippingState | String | True |
Shipping Address state of the object. | |
| ShippingZip | String | True |
Shipping Address zip of the object. | |
| Sic | String | True |
SIC of the object. | |
| Site | String | True |
Site of the object. | |
| TickerSymbol | String | True |
Ticker Symbol of the object. | |
| Type | String | True |
Type of the object. | |
| Website | String | True |
Website of the object. | |
| CreatedAt | Datetime | True |
Creation time of the object. | |
| UpdatedAt | Datetime | True |
Last update time of the object. | |
| AssignedToId | Int64 | True |
ID of the user who the object record is assigned to. | |
| CreatedById | Int64 | True |
ID of the individual who created this object. | |
| UpdatedById | Int64 | True |
ID of the individual who last updated this object. |