LeadPrograms
Query program membership for one lead.
Table Specific Information
Select
Note: All filterable columns must be specified using the '=' operator.
Retrieves a list of programs for the specific lead 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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| LeadId | Integer | The Marketo lead id |