# Visit Frequency

### Philosophical Vision <a href="#philosophical-vision" id="philosophical-vision"></a>

This metric reflects our belief in&#x20;

***

### Definition <a href="#definition" id="definition"></a>

**Active Customers:**&#x20;

***

### Metric Formula <a href="#metric-formula" id="metric-formula"></a>

```sql
Active Customers = 

COUNT(DISTINCT customer_id)

WHERE transaction_date BETWEEN start_date AND end_date
AND location_id = [location]
```

***

### Example <a href="#example" id="example"></a>

| Soho     | 243 | 2025-08-31 |
| -------- | --- | ---------- |
| Flatiron | 195 | 2025-08-31 |
| Tribeca  | 221 | 2025-08-31 |

***

### Annotation <a href="#annotation" id="annotation"></a>

* **Customer ID** must be linked to a valid service or sale within the defined timeframe.
* Customers counted more than once if active at multiple locations.
* Cancellations or no-shows do **not** count as active participation.

***

### How to Use <a href="#how-to-use" id="how-to-use"></a>

* Benchmark performance across units.
* Identify underperforming or high-performing locations.
* Pair with staffing and cost data to analyze efficiency.

***

### Tags <a href="#tags" id="tags"></a>

`reporting` `core metric` `unit economics` `location-level`