> For the complete documentation index, see [llms.txt](https://help.daasity.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.daasity.com/core-concepts/metrics/retail-and-wholesale-metrics/sales-volume/base-units.md).

# Base Units

**Description:** The expected number of units sold absent promotions.

**Formula:**

* **Option A (Direct Source Available):** `SUM(base_units)`
* **Option B (Not Available):** *Rolling Average of Non-Promo Unit Sales* (e.g., last 4–8 weeks)

**SQL Calculation (Option A):**

```sql
SUM(base_units) AS base_units
```

**SQL Calculation (Option B):**

```sql
AVG(units_sold) OVER (PARTITION BY product_id, retailer_id
                      ORDER BY week ROWS BETWEEN 4 PRECEDING AND CURRENT ROW)
   AS base_units_rolling_avg
```

**Why It Matters:** Establishes the unit-level benchmark needed for promo evaluation and lift calculations.

**Metric Type:** Diagnostic

**Essence:** Lagging

**Frequency:** Weekly

**Units:** Units

**Suggested Breakdowns:** Product, Retailer, Market

**Related Explores:**

* Retail POS Baseline Analysis
* Promo Lift Explorer

**Related Sources:**

* URS.SALES\_REPORT (unit sales)
* Syndicated baseline modeling