Activities
Query Activities for a Marketo organization.
Table Specific Information
Select
Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt,
ActivityCreatedAt. ActivityNameFilter or ExcludeActivities can be specified as an additional column in the WHERE clause. A list
of available Activity Types can be found here: http://developers.marketo.com/activity-types/. The LeadId, Email, ActivityNameFilter, and ExcludeActivities columns
allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator. Otherwise, an exception will be thrown.
SELECT * FROM Activities WHERE LeadId = '1' OR LeadId = '2'
Columns
| Name | Type | Description |
| ActivityId [KEY] | Integer | The unique Id of the activity. |
| LeadId | Integer | The unique Id of the lead associated with the activity. |
| ActivityDateTime | Datetime | The date and time the activity was performed. |
| ActivityType | String | The type of activity. |
| MktgAssetName | String | The name of the marketing asset tied to the activity. |
| Campaign | String | The campaign the activity is associated with. |
| ActivityAttributes# | String | A comma-separated list of name-value pairs (name=value). |
| String | Used when performing a GET. Filters activities using the email address of the lead associated with the activity. | |
| ActivityNameFilter | String | Used when performing a GET. The name of the specific activities to retrieve. |
| ExcludeActivities | String | Used when performing a GET. The name of the specific activities to exclude. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| OldestCreatedAt | Datetime | Used when performing a GET. Returns all activities updated since the specified time. |
| ActivityCreatedAt | Datetime | Used when performing a GET. Returns all activities updated up until the specified time. |
| StaticListId | Integer | Used when performing a GET. The Id of the static list to retrieve. |
| StaticListName | String | Used when performing a GET. The name of the static list to retrieve. |