Activities_OpenEmail
User opens Marketo Email
Columns
| Name | Type | Operators | Description |
| ActivityId [KEY] | String | Unique id of the activity. | |
| ActivityDate | Datetime | >,>=,=,<,<= | Datetime of the activity. |
| LeadId | Int | =,IN | Id of the lead associated to the activity. |
| CampaignId | Int | Id of the associated Smart Campaign, if applicable. | |
| ListId | Int | = | 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. |
| MailingID | Int | ||
| MailingIDValue | String | ||
| StepID | Int | ||
| ChoiceNumber | Int | ||
| TestVariant | Int | ||
| IsMobileDevice | Bool | ||
| Device | String | ||
| Platform | String | ||
| UserAgent | String | ||
| CampaignRunID | Int | ||
| HasPredictive | Bool | ||
| IsBotActivity | Bool | ||
| BotActivityPattern | String | ||
| Browser | String |