CustomerMetrics

Order metrics for this customer only, excluding archived orders. Ordered, allocated, in-progress, held, partially shipped and shipped orders qualify, including equivalent historical accepted and completed states.

type CustomerMetrics {
  averageDaysBetweenOrders: Float
  averageOrderValueLast12Months: MonetaryValue
  channelActivity: [CustomerChannelActivity!]!
  firstOrderAt: ISO8601DateTime
  lastOrderAt: ISO8601DateTime
  ordersLast12Months: Int!
  periodEnd: PreciseDateTime!
  periodStart: PreciseDateTime!
  salesLast12Months: MonetaryValue!
}

Fields

CustomerMetrics.averageDaysBetweenOrders ● Float scalar common

Observed elapsed days between consecutive qualifying orders in the period; null below two orders.

CustomerMetrics.averageOrderValueLast12Months ● MonetaryValue object common

Sales in the period divided by orders in the same period; null when there are no qualifying orders.

CustomerMetrics.channelActivity ● [CustomerChannelActivity!]! non-null object common

Nonempty company-local month/channel buckets reconciling to the period metrics.

CustomerMetrics.firstOrderAt ● ISO8601DateTime scalar common

Earliest qualifying order across all history through periodEnd.

CustomerMetrics.lastOrderAt ● ISO8601DateTime scalar common

Latest qualifying order creation time across all history through periodEnd; null when there are no qualifying orders.

CustomerMetrics.ordersLast12Months ● Int! non-null scalar common

Qualifying orders created in the inclusive rolling 12-calendar-month period.

CustomerMetrics.periodEnd ● PreciseDateTime! non-null scalar common

Inclusive period end captured when metrics are calculated; future orders are excluded.

CustomerMetrics.periodStart ● PreciseDateTime! non-null scalar common

Inclusive period start, 12 calendar months before periodEnd.

CustomerMetrics.salesLast12Months ● MonetaryValue! non-null object common

Eligible line prices times quantities less line discounts in the period, excluding shipping and tax, in the company currency.

Returned By

customerMetrics query