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. |