Order Delivered Value: Delivered Order Revenue

Order Delivered Value measures the total monetary value of orders that have been delivered to customers.

Formula

Order Delivered Value = SUM ( Order Value ) WHERE status = delivered

Formula Components

Metric	Definition
Order Value	The total value of each order at time of delivery
status = delivered	Filters to orders confirmed as delivered to the customer

Day

Orders Delivered

Order Delivered Value

Monday

$1,240

Tuesday

$980

Wednesday

$1,350

Thursday

$1,620

Friday

$1,890

Saturday

$720

Sunday

$650

When to Use

Scenario	Action
Measuring post-purchase fulfillment revenue	Compare delivered value to purchase value to identify fulfillment gaps
Tracking delivery performance by channel	Segment by acquisition source to see which channels drive reliable deliveries
Analyzing delivery timing impact	Correlate delivery speed with customer satisfaction and repeat purchases
Calculating true delivered ROAS	Use delivered value instead of purchase value for more accurate ad efficiency

Related Metrics

Metric	Relationship
Order Delivered	Count of delivered orders (this metric shows the value)
Order Shipped Value	Value at shipping stage (prior step in fulfillment)
Order Fulfilled Value	Value at fulfillment stage (alternate fulfillment status)
Revenue	Total purchase revenue (pre-delivery value)

Formula