Returning Customer Other Fulfillment Cost: Custom Fulfillment Expenses

Formula

Returning Customer Other Fulfillment Cost = SUM ( Other Fulfillment Cost ) WHERE customer_type = returning_customer

Formula Components

Metric	Definition
Other Fulfillment Cost	User-defined fulfillment costs from order cost entries with category Fulfillment
customer_type = returning_customer	Filters to customers who have placed at least one prior order

Metadata
Type	Currency
Data Source	Upstack Costs
Aggregation	Sum

Customer Type	Other Fulfillment	Orders	Per Order
Returning Customers	$1,170	468	$2.50
New Customers	$1,560	312	$5.00
Total	$2,730	780	$3.50

Customer Type

Other Fulfillment

Orders

Per Order

Returning Customers

$1,170

468

$2.50

New Customers

$1,560

312

$5.00

Total

$2,730

780

$3.50

How It Works

Returning Customer Other Fulfillment Cost sums all user-defined fulfillment expenses from orders where the customer has purchased before. These costs come from order cost entries you configure with the Fulfillment category—packaging materials, custom handling fees, and other fulfillment-related expenses beyond standard shipping and handling.

When to Use

Scenario	Action
Customer retention profitability	Include in total costs when calculating repeat-order margins
Segment comparison	Compare with new customer costs to identify efficiency opportunities
Contribution margin by segment	Track fulfillment costs separately for NC vs RC profitability
LTV analysis	Include in lifetime value calculations for total customer cost burden

Metric	Relationship
Other Fulfillment Cost	Parent metric including all customer types
New Customer Other Fulfillment Cost	Counterpart for first-time buyers
Total Fulfillment Cost	Sum of shipping, handling, and other fulfillment
Returning Customer Handling Cost	Standard handling fees for returning customers
Returning Customer Shipping Cost	Shipping expenses for returning customers

Metric

Relationship

Other Fulfillment Cost

Parent metric including all customer types

New Customer Other Fulfillment Cost

Counterpart for first-time buyers

Total Fulfillment Cost

Sum of shipping, handling, and other fulfillment

Returning Customer Handling Cost

Standard handling fees for returning customers

Returning Customer Shipping Cost

Shipping expenses for returning customers

METRICS

Returning Customer Other Fulfillment Cost: Custom Fulfillment Expenses

Formula

Formula Components

Example

How It Works

When to Use

​Formula

​Formula Components

​Example

​How It Works

​When to Use

​Related Metrics

Formula

Formula Components

Example

How It Works

When to Use

Related Metrics