Excel Add-In for Marketo

Build 23.0.8839

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839