1. JET UI User Guide
  2. Segment Queries
  3. Strata Queries

Strata Queries

These categories control how the customers are broken out into strata for a Stratified Segment, and are available at the Strata Query step of the Create Segment Wizard if a Strata Type of Loyalty or Transaction was selected at the Strata Field step.

The Strata Query step is not available when a Strata Type of Customer was selected at the Strata Field step. Also, this step is not available for an Unstratified Segment.

Loyalty Summary

These options are available at the Strata Query step if you select Strata Type = Loyalty at the Strata Field step.

Program Id X Program Level Y Active/Inactive

This query returns all the Customers who are members of a Program at a certain Program Level who are either Active or Inactive.

Figure 15-72 Program Id X Program Level Y Active/Inactive

This figure shows the Program Id X Program Level Y Active/Inactive

Loyalty Activity Type by Date Range

This query returns all the Customers who are members of a Program at a certain Program Level who have performed a certain account activity within a specified date range.

Figure 15-73 Loyalty Activity Type by Date Range

This figure shows the Date Range.

Loyalty Activity Type in Last X Days

This query returns all the Customers who are members of a Program at a certain Program Level who have performed a certain account activity within a certain number of days in the past.

Figure 15-74 Loyalty Activity Type in Last X Days

This figure shows the Loyalty Activity.

Loyalty Activity Type YTD

This query returns all the Customers who are members of a Program at a certain Program Level who have performed a certain account activity within the year to date.

Figure 15-75 Loyalty Activity Type YTD

This figoure shows the YTD Loyalty Activity.

Loyalty Activity Type LTD

This query returns all the Customers who are members of a Program at a certain Program Level who have performed a certain account activity within the lifetime to date of the account.

Figure 15-76 Loyalty Activity Type LTD

Loyalty Activity Type LTD

Transaction Criteria

These options are available at the Strata Query step if you select Strata Type = Transaction and Based on = Header at the Strata Field step

Location

This query returns the list of Customers who performed a transaction at a certain location.

Figure 15-77 Location

This figure shows the Location

Transactions in last X Months

This query returns the list of Customers who performed a transaction within a certain number of days in the past.

Figure 15-78 Transactions in last X Months

This figure shows the Transactions in Last X Months

Transaction Date Range

This query returns the list of Customers who performed a transaction within a certain date range.

Figure 15-79 Transaction Date Range

This figure shows the Transaction Date Range

Subtotal Amount

This query returns the list of Customers who have had a subtotal of a certain, defined value.

Figure 15-80 Subtotal Amount

This figure shows the Subtotal Amount

Transaction from Location Group in Last X Days

This query returns the list of Customers who have performed a transaction at a location within a configured location group in the last X days.

Figure 15-81 Transaction from Location Group in Last X Days

This figure shows the Transaction from Location Group in Last X Days

Line Item Detail

These options are available at the Strata Query step if you select Strata Type = Transaction and Based on = Detail at the Strata Field step.

Location

This query returns the list of Customers who performed a transaction at a certain location.

Figure 15-82 Location

This figure shows the Location

Transactions in last X Months

This query returns the list of Customers who performed a transaction within a certain number of days in the past.

Figure 15-83 Transactions in Last X Months

This figure shows the Transactions in Last X Months

Transaction Date Range

This query returns the list of Customers who performed a transaction within a certain date range.

Figure 15-84 Transaction Date Range

This figure shows the Transaction Date Range.

Item Department

This query returns the list of Customers who performed a transactions containing an item belonging to a certain item department.

Figure 15-85 Item Department

This figure shows the Item Department.

Item Class

This query returns the list of Customers who performed a transaction containing an item belonging to a certain item class.

Figure 15-86 Item Class

This figure shows the Item Class.

Item Style

This query returns the list of Customers who performed a transaction containing an item belonging to a certain item style.

Figure 15-87 Item Style

This figure shows the Item Style.

Returned Item

This query returns the list of Customers who have either returned or not returned items in a transaction.

Figure 15-88 Returned Item

This figure shows the Returned Item.

Item Price

This query returns the list of Customers with a transaction containing an item of a certain price.

Figure 15-89 Item Price

This figure shows the Item Price.

Item Quantity

This query returns the list of Customers with a transaction containing a certain quantity of any item.

Figure 15-90 Item Quantity

This figure shows the Item Quantity.

Item ID

This query returns the list of Customers who performed a transaction containing a certain item.

Figure 15-91 Item ID

This figure shows the Item ID.

Purchased Item from Location Group in Last Y Days

This query returns the list of Customers who purchased an item within a certain set of items, from a certain set of locations, within a certain number of days in the past.

Figure 15-92 Purchased Item from Location Group in Last Y Days

This figure shows the Purchased Item from Location Group in Last Y Days.