SegmentConditions
Lists all conditions that define each segment, including filters and rules applied to segment membership.
Select
The add-in uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the add-in.
- 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. |