# Business Glossary & Definition Register

> Captures all key business terms, their agreed definitions, and any conflicts surfaced during interviews.
> This document is the foundation of data governance for the model.
> Every conformed dimension attribute and fact measure should have an entry here.

---

## Glossary

| Term | Agreed definition | Domain | Owner | Source interviews | Conflicts / notes |
|---|---|---|---|---|---|
| | | | | | |

---

## Definition Conflict Log

> Every conflict must be explicitly resolved before model build. Do not silently pick a definition.

| # | Term | Definition A | Team A | Definition B | Team B | Impact on model | Agreed resolution | Resolved by | Date |
|---|---|---|---|---|---|---|---|---|---|
| 1 | | | | | | | | | |

---

## Term Detail Sheets

Use the format below for any term where the conflict or nuance is significant.

---

### [Term name]

**Agreed definition:**
> The single definition to be used across all fact tables and dimensions.

**Business context:**
> Why this term matters and how it is used in reporting.

**Calculation (if applicable):**
```
[Term] = [formula]
```

**Scope / inclusion rules:**
- Include:
- Exclude:

**Edge cases:**
| Scenario | Treatment | Rationale |
|---|---|---|
| | | |

**Conflicts surfaced:**

| Definition | Used by | Why different |
|---|---|---|
| | | |

**Resolution rationale:**
> Why the agreed definition was chosen over alternatives.

**Implementation note:**
> How this definition is implemented in the data model (which table, which column, what logic).

**Sign-off:**
| Name | Role | Date |
|---|---|---|
| | | |

---

## Common conflict patterns by business type

### SaaS conflicts to watch for

| Term | Common conflict |
|---|---|
| MRR | Sales divides annual contracts by 12; Finance recognises full upfront. Agree on one. |
| Churn | 30-day vs. 60-day window from contract end. CS and Finance often differ. |
| Active account | Logged in last 30 days (Product) vs. has an active subscription (Finance). |
| Customer | Company-level (Sales) vs. billing entity (Finance) vs. user login (Product). |
| Expansion | Upgrade only, or also additional seats/properties? |
| ARR | Annualised MRR, or total contracted value? |

### E-commerce conflicts to watch for

| Term | Common conflict |
|---|---|
| Net revenue | Gross minus refunds (Finance) vs. gross minus all deductions incl. fees (Operations). |
| ACOS | Amazon's 14-day attribution vs. Meta's 7-day click / 1-day view. Not comparable. |
| Active SKU | Listed and in stock (Ops) vs. at least one unit sold in last 90 days (Commercial). |
| Customer | Any order ever (broad) vs. DTC order only (narrow, excludes marketplace). |
| Return rate | Units returned / units shipped vs. units returned / units invoiced (different denominators). |
| Sell-through rate | Units sold / units received vs. units sold / units available — depends on accounting for shrinkage. |