LeadPrograms
Query program membership for one lead.
テーブル固有の情報
Select
Note: すべてのフィルター可能なカラムは、'=' 演算子で指定する必要があります。
特定のリードId のプログラムのリストを取得します。
SELECT * FROM LeadPrograms WHERE LeadId = 1021579
Columns
Name | Type | Filterable | Description |
Id | Integer | Unique integer id of a program record. | |
ProgressionStatus | String | Program status of the lead in the parent program. | |
ProgressionStatusType | String | Program status Type of the lead in the parent program. | |
IsExhausted | Boolean | Whether the lead is currently exhausted in the stream, if applicable. | |
AcquiredBy | Boolean | Whether the lead was acquired by the parent program. | |
ReachedSuccess | Boolean | Whether the lead is in a success-status in the parent program. | |
MembershipDate | Datetime | Date the lead first became a member of the program. | |
UpdatedAt | Datetime | Datetime when the program was most recently updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
LeadId | Integer | The Marketo lead id |