# On-time delivery rate: Formula and dbt YAML | Silicon

URL: https://meetsilicon.com/metrics/on-time-delivery-rate/

> On-time delivery rate is the percentage of orders delivered by the promised date.

## Formula
On-time delivery rate = orders delivered on time / orders delivered
## Why it matters
It is a direct measure of operational reliability and a leading indicator of repeat purchase.
## Common pitfalls
- Use the promise shown to the customer, not an internal target.
## Define it in dbt for Silicon
Add this to your model's YAML. Aggregate metrics sit under a column's meta.metrics; ratios are type: number metrics that reference other metrics. Rename models and columns to match your project.
schema.yml Copy
models:
- name: fct_deliveries
meta:
metrics:
on_time_delivery_rate:
type: number
sql: ${on_time_deliveries} / NULLIF(${deliveries}, 0)
format: percent
description: Share of orders delivered on time
columns:
- name: delivery_id
meta:
metrics:
deliveries:
type: count_distinct
description: Delivered orders
- name: on_time_delivery_id
meta:
metrics:
on_time_deliveries:
type: count_distinct
description: Orders delivered by the promised date
Once it's defined, anyone can ask about on-time delivery rate in plain English and get an answer built on this definition. See the metrics reference for every option.
## Related
- Average resolution time ->
- Ticket volume ->
- Semantic layer ->
## Tell us where your data lives today.
Book 30 minutes with the founder. Tell us where your data is today, and see Silicon running on sample data.
Talk to Sujay
30-minute call with the founder