Order Country Weekly Sales - Concierca AI

What it is

One row per country per calendar week for the last 52 weeks. The granular series behind Order Country Demand — use it to see when a country moved, or to check whether a momentum number is one spike or a sustained shift.

How it gets data

Computed view — derived from Orders and Order Line Items, same exclusions as the demand view. Orders without a shipping country appear as UNKNOWN. Read-only; no ingest endpoint.

Fields

Field	Label	Type	Writable	Description
`country_code`	Country	text	read-only	ISO-2 shipping country, or `UNKNOWN`
`week_start`	Week	date	read-only	Calendar-week start date — the default sort, newest first
`orders`	Orders	number	read-only	Distinct orders shipped to that country in that week
`units`	Units	number	read-only	Units in those orders

All columns are read-only. The view also carries tenant_id / workspace_id for tenant isolation — filtered automatically, never selected.

Query it

{
  "method": "tools/call",
  "params": {
    "name": "data_query",
    "arguments": {
      "view_slug": "v_order_country_sales_weekly",
      "filters": { "country_code": "NL" },
      "select_fields": ["week_start", "orders", "units"],
      "sort_by": "week_start",
      "limit": 12
    }
  }
}