Reports

Orders by day and hour

Returns order counts, totals, and average order value grouped by weekday and hour across the selected period.

GET /api/v1/store/reports/orders-by-day-hour

Orders by day and hour

curl --request GET \
  --url 'https://{baseUrl}/api/v1/store/reports/orders-by-day-hour' \
  --header 'Authorization: Bearer YOUR_SECRET_TOKEN'
{
  "meta": {
    "report_link": "https://app.metorik.com/reports/orders"
  },
  "totals": {
    "orders": 82,
    "total": 12450.5
  },
  "data": {
    "Monday": [
      {
        "hour": 0,
        "orders": 1,
        "total": 90,
        "aov": 90
      }
    ],
    "Tuesday": [
      {
        "hour": 14,
        "orders": 2,
        "total": 244.5,
        "aov": 122.25
      }
    ]
  }
}

No response description.

Authorizations

  • Authorization string required header

    Generate a store API key from the store's Metorik API settings in Metorik, and choose the scopes needed for the endpoints you want to call.

Query Parameters

  • end_date string required

    End date in the store timezone using YYYY-MM-DD format. Example: 2026-02-28

  • order_filters string

    Optional JSON-encoded array of order-level filters applied before calculating the report. See Order Filters Reference. Cannot be combined with segment. Example: [{"field":"billing_address_country","operator":"eq","value":"US"}]

  • segment integer

    Optional saved store-wide order segment ID. You can find the ID on the order segments page. Example: 123

  • start_date string required

    Start date in the store timezone using YYYY-MM-DD format. Example: 2026-02-01

Headers

  • Accept string required

    Response format header. Example: application/json

Response

application/json
  • meta object
    + Show Child Attributes
    • report_link string
  • totals object
    + Show Child Attributes
    • orders integer
    • total number
  • data object
    + Show Child Attributes
    • Monday[] object array
      + Show Child Attributes
      • hour integer
      • orders integer
      • total integer
      • aov integer
    • Tuesday[] object array
      + Show Child Attributes
      • hour integer
      • orders integer
      • total number
      • aov number