Segments
Manages audience segments in the account.
Select
The connector uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the connector.
- Id supports the operator: =, IN
- IsActive supports the operator: =, IN
For example, the following queries are processed server-side:
SELECT * FROM Segments
WHERE Id = 'segment-id'
SELECT * FROM Segments
WHERE IsActive = true
Delete
You can delete a segment by specifying its Id.
DELETE FROM Segments
WHERE Id = 'segment-id'
Columns
| Name | Type | ReadOnly | References | Description | |
| Id [KEY] | String | True |
The unique identifier for the segment within Klaviyo. | ||
| Name | String | False |
The display name assigned to the segment, used to identify it within the account. | ||
| Updated | Datetime | False |
The date and time when the segment was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | ||
| Created | Datetime | False |
The date and time when the segment was created, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | ||
| IsActive | Bool | False |
Indicates whether the segment is currently active. Active segments continuously update based on defined conditions. | ||
| IsProcessing | Bool | False |
Indicates whether the segment is currently processing updates or recalculating its membership. | ||
| IsStarred | Bool | False |
Indicates whether the segment has been marked as starred for quick access or prioritization. |