SegmentConditions
Lists all conditions that define each segment, including filters and rules applied to segment membership.
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 operators: =, IN
For example, the following query is processed server-side:
SELECT * FROM SegmentConditions
WHERE Id IN ('segmentcondition-id-1', 'segmentcondition-id-2', 'segmentcondition-id-3')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the segment associated with these conditions. | |
| ProfileGroupMembershipIsMember | Boolean | Indicates whether the profile is a member of the specified group used in the condition. | |
| ProfileGroupMembershipGroupIds | String | A list of group Ids used to check for profile membership within specific groups. | |
| ProfileGroupMembershipTimeframeFilter | String | Specifies the timeframe filter applied to group membership conditions to evaluate when a profile joined or left a group. | |
| profileMetricMetricId | String | The unique identifier of the metric used in the segment condition. | |
| profileMetricMeasurement | String | Specifies the measurement type applied to the metric condition, such as count, value, or frequency. | |
| profileMetricMeasurementFilter | String | Defines the filter applied to the metric measurement, used to narrow results based on specific criteria. | |
| profileMetricTimeframeFilter | String | Specifies the timeframe filter applied to the metric condition, such as within the last 30 days. | |
| profileMetricMetricFiltersProperty | String | Specifies the property used to filter the metric within the condition, such as product name or order value. | |
| profileMetricMetricFiltersFilter | String | Defines the specific filter or operator applied to the selected metric property. | |
| profileMarketingConsentChannel | String | Specifies the marketing channel evaluated in the condition, such as email or SMS. | |
| profileMarketingConsentCanRecieveMarketing | Boolean | Indicates whether the profile has consent to receive marketing communications through the specified channel. | |
| profileMarketingConsentConsentStatus | String | Specifies the consent status for marketing communications, such as subscribed, unsubscribed, or pending. | |
| ProfilePostalCodeDistanceCountryCode | String | The ISO country code used for distance-based postal code conditions. | |
| ProfilePostalCodeDistancePostalCode | String | The postal code value used as the reference point for distance-based conditions. | |
| ProfilePostalCodeDistancUunit | String | Specifies the unit of measurement used for postal code distance evaluation, such as miles or kilometers. | |
| ProfilePostalCodeDistanceFilter | String | Defines the filter or operator applied to the postal code distance condition, such as within or greater than. | |
| ProfileProperty | String | Specifies the profile property used in the condition, such as location, signup source, or custom attribute. | |
| ProfilePropertyFilter | String | Defines the filter or operator applied to the selected profile property. | |
| ProfileRegionInRegion | Boolean | Indicates whether the profile is located within the specified region used in the condition. | |
| ProfileRegion | String | Specifies the region value used in the condition, such as state, province, or country. | |
| ProfilePredictiveAnalyticsDimension | String | Specifies the predictive analytics dimension used in the condition, such as churn probability or predicted Customer Lifetime Value (CLV). | |
| ProfilePredictiveAnalyticsFilter | String | Defines the filter applied to the predictive analytics dimension, used to segment profiles based on predicted behaviors. | |
| ProfilePredictiveAnalyticsMeasurement | String | Specifies the measurement or comparison value applied to the predictive analytics dimension. | |
| ProfilePredictiveAnalyticsPredictedChannel | String | Specifies the marketing channel used in the predictive analytics condition, such as email or SMS. |