> ## Documentation Index
> Fetch the complete documentation index at: https://agents.concierca.ch/llms.txt
> Use this file to discover all available pages before exploring further.

# Weekly Sales

> Units sold per product and calendar week — newest week first, strongest sellers within each week.

## What it is

Units sold per product and calendar week. Newest week first, strongest sellers within each week. One row per variant per week — the granular time series behind the aggregated demand rates, useful for spotting week-over-week movement that a 30/90-day average smooths away.

## How it gets data

**Computed view** — derived automatically from [Orders](/for-agents/data-model/orders) / [Order Line Items](/for-agents/data-model/order-line-items) and [Products](/for-agents/data-model/products). Read-only; no ingest endpoint.

## Fields

| Field                  | Label      | Type   | Writable  | Description                                                                                                |
| ---------------------- | ---------- | ------ | --------- | ---------------------------------------------------------------------------------------------------------- |
| `week_start`           | Week       | date   | read-only | Calendar-week start date                                                                                   |
| `sku`                  | SKU        | text   | read-only | Variant SKU                                                                                                |
| `product_name`         | Product    | text   | read-only | Variant title                                                                                              |
| `product_family_label` | Family     | text   | read-only | Model family                                                                                               |
| `units`                | Units      | number | read-only | Units sold in that week                                                                                    |
| `orders`               | Orders     | number | read-only | Orders containing the variant in that week                                                                 |
| `variant_id`           | Variant ID | text   | read-only | Source variant id — joins to `products.external_id`                                                        |
| `product_id`           | —          | text   | API only  | Internal product reference — joins to `products.id` (not a registered app column, but returned by queries) |

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

## Query it

```json theme={null}
{
  "method": "tools/call",
  "params": {
    "name": "data_query",
    "arguments": {
      "view_slug": "v_product_sales_weekly",
      "filters": { "sku": "6304" },
      "select_fields": ["week_start", "units", "orders"],
      "sort_by": "week_start",
      "limit": 12
    }
  }
}
```