ScoreDetails
Query the score details of a contact.
View Specific Information
To query data from this view, you must specify ContactId.
The connector will use the Act-On API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- ContactId supports the '=' and 'IN' operators.
For example, the following queries are processed server side:
SELECT * FROM ScoreDetails WHERE ContactId = 'l-0004:2'
SELECT * FROM ScoreDetails WHERE ContactId IN ('l-0004:2', 'l-0004:3')
Columns
| Name | Type | Description |
| ContactId [KEY] | String | Unique identifier of the contact. |
| ActivityId | String | Unique identifier of the activity. |
| Action | String | Brief description of the action. |
| IdType | String | Type of the activity. |
| Profile | Boolean | Whether or not the user has a profile. |
| Score | Integer | Score of the activity. |
| Specific | Boolean | Whether or not the activity is specific. |
| Ago | Integer | Days ago that activity happened. |
| InScoreRange | Boolean | Whether or not the activity is in score range. |
| What | String | Object of the activity. |
| When | Datetime | When the activity happened. |
| Bin | String | Subject of the activity. |
| Verb | String | Description of the activity. |