Customer Segmentation Table (BETA)
customer_segmentation_table
The Customer Segmentation table provides a complete list of customers included in each segment instance, along with metadata about the segment, when it was created, and how it was defined. Querying this table allows you to identify which customers belong to which segments at any given point in time, measure list composition, and join against other tables to analyze performance. Learn more about customer retention and customer segmentation.
Key ConceptsSegment
- A collection of customers that meet a defined set of rules or criteria. Segments are created by users to group customers based on behaviors, attributes, or activities.
Segment Instances
- Snapshots of a segment at a specific point in time. Each time a segment runs, it generates a segment instance representing the customers who matched the criteria on that date.
Dimensions
Dimensions are immutable properties that can be used for grouping data.
Title | ID | Type | Description |
---|---|---|---|
Customer Identity |
| string | The identity of the customer in the segment. Can be either Example values: |
Instance Created Date |
| date | The timestamp when the segment instance (run/snapshot) was generated. Example value: |
Schedule |
| string | The recurring schedule for running the segment. Example values: |
Segment By |
| string | The audience type used to group customers in the segment. Example value: |
Segment Created Date |
| date | The date when the segment was originally created. Example value: |
Segment ID |
| string | The unique identifier for a segment. Example value: |
Segment Instance ID |
| string | The unique identifier for a specific segment instance (run/snapshot). Example value: |
Segment Name |
| string | The human-readable name of the segment, Example values: |
Measures
Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.
Title | ID | Type | Description |
---|---|---|---|
Number of Customers | num_of_customers | numeric | The total number of unique customers included in the segment instance. |
Number of Orders | num_of_orders | numeric | The total number of orders placed by customers in the segment during the relevant time window. |
Total Revenue | total_revenue | numeric | The total revenue generated by customers in the segment during the relevant time window. |
Updated about 22 hours ago