ProspectAccounts
Retrieve and modify prospect accounts.
テーブル固有の情報
Select
connector はSalesforce Marketing Cloud Account Engagement API を使用して、以下のカラムと演算子で構築されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドでconnector 内部で処理されます。
- Id は '='、'<'、'<='、'>'、'>=' をサポートしています。
例えば、次のクエリはサーバーサイドで処理されます。
SELECT * FROM ProspectAccounts WHERE Id > 31
Get Deleted
削除されたプロスペクトのアカウントを取得するには、GETDELETED 文を実行します。
GETDELETED FROM ProspectAccounts
Columns
| Name | Type | References | Description |
| Id [KEY] | Int64 | ID of the object. | |
| Name | String | Name of the object. | |
| SalesforceId | String | ID of the Salesforce object representing this object. | |
| IsDeleted | Boolean | True if the object is in the recycle bin in Pardot. | |
| AnnualRevenue | String | Annual Revenue of the object. | |
| BillingAddressOne | String | Billing Address of the object. | |
| BillingAddressTwo | String | Second Billing Address of the object. | |
| BillingCity | String | City of the object. | |
| BillingCountry | String | County of the object. | |
| BillingState | String | State of the object. | |
| BillingZip | String | Zip of the object. | |
| Description | String | Description of the object. | |
| Employees | String | Employees of the object. | |
| Fax | String | Fax of the object. | |
| Industry | String | Industry of the object. | |
| Number | String | Number of the object. | |
| Ownership | String | Ownership of the object. | |
| Phone | String | Phone Number of the object. | |
| Rating | String | Rating of the object. | |
| ShippingAddressOne | String | Shipping Address of the object. | |
| ShippingAddressTwo | String | Second Shipping Address of the object. | |
| ShippingCity | String | Shipping Address city of the object. | |
| ShippingCountry | String | Shipping Address country of the object. | |
| ShippingState | String | Shipping Address state of the object. | |
| ShippingZip | String | Shipping Address zip of the object. | |
| Sic | String | SIC of the object. | |
| Site | String | Site of the object. | |
| TickerSymbol | String | Ticker Symbol of the object. | |
| Type | String | Type of the object. | |
| Website | String | Website of the object. | |
| CreatedAt | Datetime | Creation time of the object. | |
| UpdatedAt | Datetime | Last update time of the object. | |
| AssignedToId | Int64 | ID of the user who the object record is assigned to. | |
| CreatedById | Int64 | ID of the individual who created this object. | |
| UpdatedById | Int64 | ID of the individual who last updated this object. |