Segments

Stores definitions for customer segments, including filter logic and dynamic grouping criteria.

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

Id supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM Segments WHERE Id = 'Val1'

Insert

The following columns can be used to create a new record:

Name, Query

Update

The following columns can be updated:

Name, Query

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A globally unique identifier for the customer segment.
Name	String	False		The descriptive name of the segment, used to identify it within the admin interface.
Query	String	False		The query logic that defines the segment, composed of conditional statements and filters based on customer attributes and behaviors.
CreationDate	Datetime	True		The date and time when the segment was first created and saved in the store.
LastEditDate	Datetime	True		The date and time when the segment definition was most recently updated or modified.