Queries

All the available Commerce Layer Metrics API query types and the supported operators

Commerce Layer Metrics API lets you retrieve metric data and statistics through four types of queries:

BreakdownDate breakdownStatsSearch

Breakdown, date breakdown, and stats queries return aggregated metrics computed on the values of specific fields, based on selected operators. The search query is an actual search, returning the specified fields of the matching records.

The examples in the following pages will be focused on the query part of the request. The orders endpoint will be used as a reference and no specific filter or meta options will be defined (i.e. all the results will be filtered by the default filter and the response won't include the request payload). See the use cases section for more complex combinations of queries and filters.

Query operators

To perform breakdown, date breakdown, and stats queries you need to specify the operator you want to use to compute the calculation on the selected field. The valid operators depend on the field itself, hence on the resource you're doing statistics on. You can find here below the complete list of the available operators for the Metrics API queries (see the related tables to check the subset of valid operators by field for orders, returns, or carts).

OperatorComputed value typeDescription

avg

Float

A single-value metrics aggregation that computes the average of numeric values extracted from specific numeric fields of the aggregated records.

cardinality

Integer

A single-value metrics aggregation that calculates an approximate count of distinct values.

max

Float

A single-value metrics aggregation that keeps track and returns the maximum value among the numeric values extracted from specific numeric fields of the aggregated records.

min

Float

A single-value metrics aggregation that keeps track and returns the minimum value among the numeric values extracted from specific numeric fields of the aggregated records.

percentiles

Float

A multi-value metrics aggregation that calculates one or more percentiles (i.e. the point at which a certain percentage of observed values occurs) over numeric values extracted from specific numeric fields of the aggregated records.

stats

Object

A multi-value metrics aggregation that computes stats over numeric values extracted from specific numeric fields of the aggregated records. The stats that are returned consist of: count, min, max, avg, and sum.

sum

Float

A single-value metrics aggregation that sums up numeric values extracted from specific numeric fields of the aggregated records.

value_count

Integer

A single-value metrics aggregation that counts the number of values extracted from specific fields of the aggregated records.

Last updated