CustomerSegmentMembers
Displays members belonging to defined customer segments, supporting segmentation and targeting analysis.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- SegmentId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM CustomerSegmentMembers WHERE SegmentId = 'Val1'
Columns
| Name | Type | References | Description |
| SegmentId [KEY] | String |
Segments.Id | The unique identifier of the customer segment that this member belongs to. |
| Id [KEY] | String | The unique identifier for the segment member record. | |
| DisplayName | String | The full display name of the segment member, derived from their first and last names. If unavailable, the customer's email or phone number is used as a fallback. | |
| FirstName | String | The first name of the segment member. | |
| LastName | String | The last name of the segment member. | |
| Note | String | A merchant-authored note providing additional context or comments about the segment member. | |
| LastOrderId | String | The unique identifier of the most recent order placed by this segment member. | |
| NumberOfOrders | String | The total number of orders the segment member has placed in the store. | |
| AmountSpentAmount | Decimal | The total monetary value of all orders placed by the member, expressed as a decimal amount. | |
| AmountSpentCurrencyCode | String | The three-letter ISO currency code corresponding to the total amount spent. | |
| DefaultAddressId | String | The unique identifier of the member's default address. | |
| DefaultAddressCountry | String | The full country name specified in the default address. | |
| DefaultAddressProvince | String | The administrative region, province, or state specified in the default address. | |
| DefaultAddressCity | String | The city, district, or locality specified in the default address. | |
| DefaultAddressFormattedArea | String | A formatted string combining the city, province, and country values from the default address. | |
| DefaultAddressCompany | String | The company or organization name listed in the default address, if applicable. | |
| DefaultAddressAddress1 | String | The first line of the member's default address, typically the street name or PO Box. | |
| DefaultAddressAddress2 | String | The second line of the member's default address, such as apartment, suite, or unit number. | |
| DefaultAddressName | String | The full name of the customer as listed in the default address, derived from their first and last names. | |
| DefaultAddressFirstName | String | The first name from the member's default address. | |
| DefaultAddressLastName | String | The last name from the member's default address. | |
| DefaultAddressLatitude | Double | The latitude coordinate of the default address location. | |
| DefaultAddressLongitude | Double | The longitude coordinate of the default address location. | |
| DefaultAddressCoordinatesValidated | Bool | Indicates whether the default address coordinates have been successfully validated. | |
| DefaultAddressValidationResultSummary | String | A summary of the address validation result, based on Shopify's built-in validation system. | |
| DefaultAddressPhone | String | The customer's phone number as listed in the default address, formatted in E.164 standard (for example, +16135551111). | |
| DefaultAddressZip | String | The postal or ZIP code for the default address. | |
| DefaultAddressProvinceCode | String | The regional code representing the province or state for the default address (for example, ON). | |
| DefaultAddressCountryCode | String | The two-letter ISO country code for the default address (for example, US). | |
| DefaultAddressTimeZone | String | The time zone associated with the default address location. | |
| DefaultEmailAddressEmailAddress | String | The default email address associated with the segment member. | |
| DefaultEmailAddressMarketingState | String | Indicates the member's current subscription state for email marketing communications. | |
| DefaultEmailAddressMarketingUnsubscribeUrl | String | The URL that allows the member to unsubscribe from all marketing emails. | |
| DefaultEmailAddressOpenTrackingLevel | String | Specifies whether the member has consented to open-tracking in marketing emails. | |
| DefaultEmailAddressOpenTrackingUrl | String | The URL that can be used to update the member's consent status for email open tracking. | |
| DefaultPhoneNumberMarketingState | String | Indicates the member's current subscription state for SMS marketing communications. | |
| DefaultPhoneNumberPhoneNumber | String | The customer's default phone number used for account and marketing communications. | |
| MergeableReason | String | The reason this customer record cannot currently be merged with another customer. | |
| MergeableErrorFields | String | A list of specific fields that are preventing this customer record from being merged. | |
| MergeableIsMergeable | Bool | Indicates whether this customer record can be merged with another record. | |
| MergeableMergeInProgressJobId | String | The unique identifier of the active or pending merge job for this customer. | |
| MergeableMergeInProgressResultingCustomerId | String | The unique identifier of the customer record that will result from the ongoing merge process. | |
| MergeableMergeInProgressStatus | String | The current status of the merge operation, such as pending, running, or completed. |