Skip to main content
User-defined fulfillment costs from order cost entries for returning customer orders.

Formula

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

Formula Components

MetricDefinition
Other Fulfillment CostUser-defined fulfillment costs from order cost entries with category Fulfillment
customer_type = returning_customerFilters to customers who have placed at least one prior order
Metadata
TypeCurrency
Data SourceUpstack Costs
AggregationSum

Example

Your store incurred $1,170 in custom fulfillment costs for returning customers last month:
Customer TypeOther FulfillmentOrdersPer Order
Returning Customers$1,170468$2.50
New Customers$1,560312$5.00
Total$2,730780$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

ScenarioAction
Customer retention profitabilityInclude in total costs when calculating repeat-order margins
Segment comparisonCompare with new customer costs to identify efficiency opportunities
Contribution margin by segmentTrack fulfillment costs separately for NC vs RC profitability
LTV analysisInclude in lifetime value calculations for total customer cost burden

MetricRelationship
Other Fulfillment CostParent metric including all customer types
New Customer Other Fulfillment CostCounterpart for first-time buyers
Total Fulfillment CostSum of shipping, handling, and other fulfillment
Returning Customer Handling CostStandard handling fees for returning customers
Returning Customer Shipping CostShipping expenses for returning customers
See all Fulfillment metrics →