Retrieve activities of different types after a specific datetime.

Each activity type in your Marketo organization is returned as a separate table. Each table name is prefixed with 'Activities_' followed by the name of the activity type. Activities are pushed as views. Custom activities are pushed as tables CustomActivities

All activities tables support BULK SELECT when UseBulkAPI is set to true.

Select

By default, this view retrieves all activity types from the creation of Marketo.

It is advised to provide a filter for ActivityTypeId and ActivityDate, or to make use of tables such as Activities_AddtoList, Activities_AddtoNurture, Activities_AddtoOpportunity, which are linked to a specific activity type.

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.

	SELECT * FROM Activities WHERE ActivityDate > '2024-01-01T00:00:00Z'
	SELECT * FROM Activities WHERE ActivityDate >= ' 2024-01-01T00:00:00Z' AND ActivityDate <= '2024-03-01T00:00:00Z'
	SELECT * FROM Activities WHERE ListId = '1014' AND ActivityDate > '2024-01-01T00:00:00Z'
	SELECT * FROM Activities WHERE ListId = '1014' AND ActivityTypeId = '13'
	SELECT * FROM Activities WHERE ListId = '1014' AND ActivityTypeId = '13' AND ActivityDate > ' 2024-01-01T00:00:00Z'
	SELECT * FROM Activities WHERE ActivityTypeId = 24
	SELECT * FROM Activities WHERE ActivityTypeId IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13)

Columns