Excel Add-In for Marketo

Build 24.0.9175

ListStaticMemberShip

Query leads of a static list in Marketo.

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.

Tip: This table uses server-side projection. Performance can be improved by minimizing the number of columns in projection. 

	SELECT * FROM ListStaticMemberShip WHERE ListId=123

Columns

Name Type Operators Description
ListId [KEY] Int = Id of the static list.
Id [KEY] Int The lead Id.
AcmeAccessCode String =,IN
AcquisitionProgramId Int
Address String
AnnualRevenue Decimal
AnonymousIP String
BillingCity String
BillingCountry String
BillingPostalCode String
BillingState String
BillingStreet String
BlackListed Bool
BlackListedCause String
City String
Company String
ContactCompany Int
Cookies String =,IN
Country String
CreatedAt Datetime
Cstmfdtest1 String =,IN
Cstmfdtest2 String =,IN
DateOfBirth Date
Department String =,IN
DoNotCall Bool
DoNotCallReason String
Ecids String
Email String =,IN
EmailInvalid Bool
EmailInvalidCause String
EmailSuspended Bool
EmailSuspendedAt Datetime
EmailSuspendedCause String =,IN
ExternalCompanyId String =,IN
ExternalSalesPersonId String =,IN
Fax String
FirstName String
FirstUTMCampaign String
FirstUTMContent String
FirstUTMMedium String
FirstUTMSource String
FirstUTMTerm String
GdprMailableStatus String
Industry String
InferredCity String
InferredCompany String
InferredCountry String
InferredMetropolitanArea String
InferredPhoneAreaCode String
InferredPostalCode String
InferredStateRegion String
IsAnonymous Bool
IsLead Bool
LastName String
LatestUTMCampaign String
LatestUTMContent String
LatestUTMMedium String
LatestUTMSource String
LatestUTMterm String
LeadPartitionId Int =,IN
LeadPerson Int
LeadRevenueCycleModelId Int
LeadRevenueStageId Int
LeadRole String
LeadScore Int
LeadSource String
LeadStatus String
MainPhone String
MarketingSuspended Bool
MarketingSuspendedCause String
MiddleName String
MktoAcquisitionDate Datetime
MktoCompanyNotes String
MktoDoNotCallCause String
MktoIsCustomer Bool
MktoIsPartner Bool
MktoName String =,IN
MktoPersonNotes String
MobilePhone String
NumberOfEmployees Int
NumberofEmployeesProspect String
OriginalReferrer String
OriginalSearchEngine String
OriginalSearchPhrase String
OriginalSourceInfo String
OriginalSourceType String
PersonLevelEngagementScore Int =,IN
PersonPrimaryLeadInterest Int
PersonTimeZone String
PersonType String
Phone String
PostalCode String
Priority Int
Rating String
RegistrationSourceInfo String
RegistrationSourceType String
RelativeScore Int
RelativeUrgency Int
Salutation String
SicCode String
Site String
State String
Test String =,IN
Test1 Bool
Test98 String =,IN
TestBoolean Bool
TestCustomfieldEmail String =,IN
TestFieldText1 String =,IN
TestInteger Bool
TestInteger_cf Int =,IN
TestKpQA String =,IN
Title String
Unsubscribed Bool
UnsubscribeDateFoFS String
UnsubscribeDateUnleashed String
UnsubscribedReason String
UnsubscribeFoFS String
UnsubscribeMarketing String
UnsubscribeSales String
UnsubscribeUnleashed String
UpdatedAt Datetime
Urgency Double
UTMTerm String =,IN
Website String

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175