Segments
Query segments for a Marketo organization.
Table Specific Information
Select
Note: All filterable columns must be specified using the '=' operator.
Retrieves a list segments for the given segmentation id.
SELECT * FROM Segments WHERE SegmentationId = 1012
Columns
| Name | Type | Filterable | Description |
| Id | Integer | Id of the asset. | |
| Name | String | Name of the asset. | |
| CreatedAt | Datetime | Datetime the asset was created. | |
| Description | String | Description of the asset. | |
| SegmentationId | Integer | True | Id of the Segmentation. |
| Status | String | True | Status filter for draft or approved versions.
The allowed values are approved, draft. |
| UpdatedAt | Datetime | Datetime the asset was most recently updated. | |
| Url | String | Url of the asset in the Marketo UI. |