CustomerSegmentMembers
Lists members (for example, customers) associated with a specific customer segment.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- 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 identifier of the segment that this member belongs to. |
| Id [KEY] | String | The globally unique identifier of the segment member. | |
| DisplayName | String | The display name of the member, derived from first and last name. If unavailable, falls back to the customer's email address, or if not available, the phone number. | |
| FirstName | String | The first name of the segment member. | |
| LastName | String | The last name of the segment member. | |
| Note | String | A merchant-facing note about the segment member. | |
| LastOrderId | String | The identifier of the member's most recent order. | |
| NumberOfOrders | String | The total number of orders placed by the member. | |
| AmountSpentAmount | Decimal | The total amount spent by the member, expressed as a decimal money value. | |
| AmountSpentCurrencyCode | String | The currency code for the member's total spent amount. | |
| DefaultAddressId | String | The globally unique identifier of the member's default address. | |
| DefaultAddressCountry | String | The country of the member's default address. | |
| DefaultAddressProvince | String | The province, state, or district of the member's default address. | |
| DefaultAddressCity | String | The city, town, district, or village of the member's default address. | |
| DefaultAddressFormattedArea | String | A comma-separated string combining the city, province, and country of the default address. | |
| DefaultAddressCompany | String | The company or organization name listed on the member's default address. | |
| DefaultAddressAddress1 | String | The first line of the member's default address, typically a street address or PO Box. | |
| DefaultAddressAddress2 | String | The second line of the member's default address, typically an apartment, suite, or unit number. | |
| DefaultAddressName | String | The full name associated with the member's default address, based on first and last name. | |
| DefaultAddressFirstName | String | The first name on the member's default address. | |
| DefaultAddressLastName | String | The last name on the member's default address. | |
| DefaultAddressLatitude | Double | The latitude coordinate of the member's default address. | |
| DefaultAddressLongitude | Double | The longitude coordinate of the member's default address. | |
| DefaultAddressCoordinatesValidated | Bool | Indicates whether the coordinates of the default address are valid. | |
| DefaultAddressValidationResultSummary | String | The validation status of the default address, as determined by the Shopify Admin address validation feature. | |
| DefaultAddressPhone | String | The phone number associated with the default address, formatted using the E.164 standard (for example, +16135551111). | |
| DefaultAddressZip | String | The postal or ZIP code of the member's default address. | |
| DefaultAddressProvinceCode | String | The alphanumeric code for the province, state, or district of the default address, such as ON. | |
| DefaultAddressCountryCode | String | The two-letter country code of the default address, such as US. | |
| DefaultAddressTimeZone | String | The time zone of the member's default address. | |
| DefaultEmailAddressEmailAddress | String | The default email address of the member. | |
| DefaultEmailAddressMarketingState | String | The current email marketing subscription state of the member. | |
| DefaultEmailAddressMarketingUnsubscribeUrl | String | The URL where the member can unsubscribe from all mailing lists. | |
| DefaultEmailAddressOpenTrackingLevel | String | The member's opt-in level for tracking whether their emails are opened. | |
| DefaultEmailAddressOpenTrackingUrl | String | The URL the member can use to opt in or out of email open tracking. | |
| DefaultPhoneNumberMarketingState | String | The current SMS marketing subscription state of the member. | |
| DefaultPhoneNumberPhoneNumber | String | The phone number of the member. | |
| MergeableReason | String | The reason why the member cannot be merged with another customer record. | |
| MergeableErrorFields | String | The list of fields preventing the member from being merged. | |
| MergeableIsMergeable | Bool | Indicates whether the member can be merged with another customer record. | |
| MergeableMergeInProgressJobId | String | The identifier of the merge job currently in progress. | |
| MergeableMergeInProgressResultingCustomerId | String | The identifier of the resulting customer record after a merge. | |
| MergeableMergeInProgressStatus | String | The current status of the member merge request. |