Sample custom activity.

Each custom activity in your Marketo organization is returned as a separate table, apart from the main "Activities" table. Each table name is prefixed with 'Activity_' followed by the name of your custom activity.

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.

The following queries are related to a sample custom activity 'Activities_AttendConference'. This table may not exist in your Marketo instance.

	SELECT * FROM Activities_AttendConference WHERE ListId = '1014'

Insert

	INSERT INTO Activities_AttendConference (ActivityDate, LeadId, PrimaryAttributeValue, ConferenceDate, NumberOfAttendees) VALUES ('2024-01-01T00:01:00Z', 4, 'asd', '2024-01-10', 4)

Bulk

When UseBulkAPI is set to true the ActivityDate filter can be processed server-side. Sample queries:

	SELECT * FROM Activities_AttendConference WHERE ActivityDate > '2024-01-01T00:00:00Z'
	SELECT * FROM Activities_AttendConference WHERE ActivityDate >= '2024-01-01T00:00:00Z' AND ActivityDate <= '2024-03-01T00:00:00Z'
	SELECT * FROM Activities_AttendConference WHERE ListId = '1014' AND ActivityDate > '2024-01-01T00:00:00Z'
	SELECT * FROM Activities_AttendConference WHERE ListId = '1014' AND ActivityDate >' 2024-01-01T00:00:00Z'

Columns

Name	Type	ReadOnly	Operators	Description
ActivityId [KEY]	String	False		Unique id of the activity.
ActivityDate	Datetime	False		Datetime of the activity.
LeadId	Int	False	=,IN	Id of the lead associated to the activity.
CampaignId	Int	False		Id of the associated Smart Campaign, if applicable.
ListId	Int	False	=	Mirror column that can be used only as a filter. Will retrieve activities for all leads that are members of this static list. Not available when UseBulkAPI=true.
ConferenceName	String	False
ConferenceNameValue	String	False
ConferenceDate	Datetime	False
NumberOfAttendees	Int	False