Activities_ChangeRevenueStage
Query Change Revenue Stage Activities for a Marketo organization.
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. |
| ModelId | String | The id of the revenue model. |
| ModelVersion | String | The version of the revenue model. |
| NewStageId | String | The new Id of the stage that the lead is currently in. |
| NewStage | String | The new name of the stage that the lead is currently in. |
| OldStageId | String | The Id of the stage that the lead was previously in. |
| OldStage | String | The name of the stage that the lead was previously in. |
| Reason | String | The reason why the data value was changed. |
| StepId | String | The Id of the current step in the flow. |
| ChoiceNumber | String | The choice number of the current step that triggered the activity. |
| ActivityDateTime | Datetime | The date and time the activity was performed. |
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. |