SalesStatisticsRow

One row of a sales statistics result: the requested dimension values that identify this row, plus the requested metric values. Fields for dimensions/metrics that were not requested are null.

type SalesStatisticsRow {
  day: String
  week: String
  month: String
  year: String
  countryName: String
  countryCode: String
  brandId: Int
  brandName: String
  categoryId: Int
  categoryName: String
  productId: String
  productName: String
  customerId: Int
  quantity: Int
  revenueExcludingTax: Float
  revenueIncludingTax: Float
  taxAmount: Float
  orderCount: Int
  customerCount: Int
  newCustomerCount: Int
}

Fields

day ● String

Present when DAY was a requested dimension. Format: YYYY-MM-DD

week ● String

Present when WEEK was a requested dimension. ISO year-week. Format: YYYY-WW

month ● String

Present when MONTH was a requested dimension. Format: YYYY-MM

year ● String

Present when YEAR was a requested dimension. Format: YYYY

countryName ● String

Present when COUNTRY was a requested dimension (shipping country, per order snapshot)

countryCode ● String

Present when COUNTRY was a requested dimension and a matching country row exists

brandId ● Int

Present when BRAND was a requested dimension

brandName ● String

Present when BRAND was a requested dimension

categoryId ● Int

Present when CATEGORY was a requested dimension. Only a product's standard/primary category is counted (Artiklar_Artikelgrupper.StandardGrupp = 1), so quantity/revenue is not split across a product's secondary categories

categoryName ● String

Present when CATEGORY was a requested dimension

productId ● String

Present when PRODUCT was a requested dimension

productName ● String

Present when PRODUCT was a requested dimension and a matching article exists, in the caller's display language

customerId ● Int

Present when CUSTOMER was a requested dimension

quantity ● Int

Present when QUANTITY was a requested metric

revenueExcludingTax ● Float

Present when REVENUE_EXCLUDING_TAX was a requested metric. In SalesStatisticsResult.currency

revenueIncludingTax ● Float

Present when REVENUE_INCLUDING_TAX was a requested metric. In SalesStatisticsResult.currency

taxAmount ● Float

Present when TAX_AMOUNT was a requested metric. In SalesStatisticsResult.currency

orderCount ● Int

Present when ORDER_COUNT was a requested metric (distinct orders contributing to this row)

customerCount ● Int

Present when CUSTOMER_COUNT was a requested metric (distinct customers who ordered in this row)

newCustomerCount ● Int

Present when NEW_CUSTOMER_COUNT was a requested metric (of those customers, how many registered within dateRange, per Kunder.Tid_Registrerad)

Example

{
  "day": "2026-07-22",
  "week": "2026-30",
  "month": "2026-07",
  "year": 2026,
  "countryName": "Sweden",
  "countryCode": "SE",
  "productId": "AVR 135",
  "productName": "Laura Regular Fit Shirt Double Cuff White"
}