CustomerSegmentMembers
The list of members, such as customers, that's associated with individual segments.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- SegmentId supports the '=' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM CustomerSegmentMembers
SELECT * FROM CustomerSegmentMembers WHERE SegmentId = 'gid://shopify/Segment/460201033987'
Columns
| Name | Type | References | Description |
| SegmentId [KEY] | String |
Segments.Id | The ID of the segment. |
| Id [KEY] | String | The member's ID. | |
| DisplayName | String | The full name of the member, which is based on the values of the 'first_name' and 'last_name' fields. If the member's first name and last name aren't available, then the customer's email address is used. If the customer's email address isn't available, then the customer's phone number is used. | |
| FirstName | String | The member's first name. | |
| LastName | String | The member's last name. | |
| Note | String | A note about the member. | |
| LastOrderId | String | The ID of the member's most recent order. | |
| NumberOfOrders | String | The total number of orders that the member has made. | |
| AmountSpentAmount | Decimal | Decimal money amount. | |
| AmountSpentCurrencyCode | String | Currency of the money. | |
| DefaultAddressId | String | A globally-unique ID. | |
| DefaultAddressCountry | String | The name of the country. | |
| DefaultAddressProvince | String | The region of the address, such as the province, state, or district. | |
| DefaultAddressCity | String | The name of the city, district, village, or town. | |
| DefaultAddressFormattedArea | String | A comma-separated list of the values for city, province, and country. | |
| DefaultAddressCompany | String | The name of the customer's company or organization. | |
| DefaultAddressAddress1 | String | The first line of the address. Typically the street address or PO Box number. | |
| DefaultAddressAddress2 | String | The second line of the address. Typically the number of the apartment, suite, or unit. | |
| DefaultAddressName | String | The full name of the customer, based on firstName and lastName. | |
| DefaultAddressFirstName | String | The first name of the customer. | |
| DefaultAddressLastName | String | The last name of the customer. | |
| DefaultAddressLatitude | Double | The latitude coordinate of the customer address. | |
| DefaultAddressLongitude | Double | The longitude coordinate of the customer address. | |
| DefaultAddressCoordinatesValidated | Bool | Whether the address coordinates are valid. | |
| DefaultAddressPhone | String | A unique phone number for the customer. Formatted using E. 164 standard. For example, _+16135551111_. | |
| DefaultAddressZip | String | The zip or postal code of the address. | |
| DefaultAddressProvinceCode | String | The alphanumeric code for the region. For example, ON. | |
| DefaultAddressCountryCode | String | The two-letter code for the country of the address. For example, US. | |
| DefaultAddressTimeZone | String | The time zone of the address. | |
| DefaultEmailAddressEmailAddress | String | The customer's default email address. | |
| DefaultEmailAddressMarketingState | String | Whether the customer has subscribed to email marketing. | |
| DefaultEmailAddressMarketingUnsubscribeUrl | String | The URL to unsubscribe a member from all mailing lists. | |
| DefaultEmailAddressOpenTrackingLevel | String | Whether the customer has opted in to having their opened emails tracked. | |
| DefaultEmailAddressOpenTrackingUrl | String | The URL that can be used to opt a customer in or out of email open tracking. | |
| DefaultPhoneNumberMarketingState | String | Whether the customer has subscribed to SMS marketing material. | |
| DefaultPhoneNumberPhoneNumber | String | A customer's phone number. | |
| MergeableReason | String | The reason why the customer can't be merged with another customer. | |
| MergeableErrorFields | String | The list of fields preventing the customer from being merged. | |
| MergeableIsMergeable | Bool | Whether the customer can be merged with another customer. | |
| MergeableMergeInProgressJobId | String | The UUID of the merge job. | |
| MergeableMergeInProgressResultingCustomerId | String | The ID of the customer resulting from the merge. | |
| MergeableMergeInProgressStatus | String | The status of the customer merge request. |