TDV Adapter for Marketo

Build 22.0.8462

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='test@server.com' OR Email='testlead@server.com'

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.
Email 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462