LeadPrograms
Query program membership for leads.
Select
Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.
If no LeadId filter is specified, this table queries all available LeadIds. This process is time-consuming because querying the Leads table is resource-intensive.
SELECT * FROM LeadPrograms WHERE LeadId=4
Columns
| Name | Type | Operators | Description |
| LeadId [KEY] | Int | = | The Marketo lead id. |
| ProgramId [KEY] | Int | 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 | Bool | Whether the lead is currently exhausted in the stream, if applicable. | |
| AcquiredBy | Bool | Whether the lead was acquired by the parent program. | |
| ReachedSuccess | Bool | 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. |