Activities_ChangeScore
Query Change Score 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,
or ActivityCreatedAt. The LeadId and Email 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_ChangeScore WHERE Email='[email protected]' OR Email='[email protected]'
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. |
| ScoreName | String | The name of the score whose data value was changed. |
| ChangeValue | String | The net change in the score value. For example, +5 or -5. |
| NewValue | String | The new and current score value. |
| OldValue | String | The old and previous score value. |
| Urgency | String | How much the score has changed recently. A higher urgency represents a score that has increased a lot lately, showing customer interest. This value is derived from score value (NewValue). |
| Reason | String | The reason why the data value was changed. |
| Priority | String | The priority rank used to decide which lead should be contacted first. Priority has two components: Urgency and Relative Score. The higher the priority, the higher likelihood that the lead will respond positively to a contact. |
| RelativeScore | String | Contains a measure of how a lead's score compares to other lead scores. This value is derived from score value (NewValue). |
| RelativeUrgency | String | Contains a measure of how a lead's urgency compares to other lead urgencies. |
| ActivityDateTime | Datetime | The date and time the activity was performed. |
| AssetName | String | The marketing asset name associated with the activity. |
| String | Used when performing a GET. Filters activities using the email address of the lead associated with the activity. |
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. |