Activities_Custom
Sample custom activity.
Each custom activity in your Marketo organization is returned as a separate table, appart 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 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'
SELECT * FROM Activities_AttendConference WHERE ListId = '1014' AND ActivityDate >' 2024-01-01T00:00:00Z'
Insert
INSERT INTO Activities_AttendConference (ActivityDate, LeadId, PrimaryAttributeValue, ConferenceDate, NumberOfAttendees) VALUES ('2024-01-01T00:01:00Z', 4, 'asd', '2024-01-10', 4)
Columns
| Name | Type | ReadOnly | Operators | Description |
| MarketoGUID [KEY] | String | False |
Unique id of the activity. | |
| Id | String | False |
Integer id of the activity. This value could exceed Int.MAX. For instances which have been migrated to Activity Service, this field may not be present, and should not be treated as unique. | |
| ActivityDateTime | 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_Id | String | False | ||
| ConferenceName_Value | String | False | ||
| ConferenceDate | Datetime | False | ||
| NumberOfAttendees | Int | False |