Skip to main content
Cost of goods sold for orders placed by new customers—used to calculate new customer gross margin.

Formula

New Customer COGS = SUM ( Product Cost ) WHERE customer_type = new_customer

Formula Components

MetricDefinition
Product CostCost of products in the order from Shopify inventory
customer_type = new_customerFilters to orders from first-time buyers
Metadata
TypeCurrency
Data SourceShopify, Upstack Costs
AggregationSum

Example

Your store generated $18,340 in new customer COGS this month from 412 first-time orders:
SegmentCOGSRevenueGross Margin
New Customers$18,340$47,20061.1%
Returning Customers$24,680$68,40063.9%
All Orders$43,020$115,60062.8%
New customers have slightly lower margins due to higher average discount rates on acquisition offers.

How It Works

New Customer COGS sums the product costs for all orders placed by first-time buyers during the selected period. Product costs come from Shopify variant cost data. This metric is essential for calculating whether your customer acquisition costs can be recovered from first-order profit.

When to Use

ScenarioAction
Acquisition profitabilitySubtract from NC Revenue to find first-order gross profit
CAC payback analysisCompare NC COGS + ad spend to NC Revenue
Segment cost structureIdentify if new customers buy higher-cost products
Margin by cohortTrack if acquisition channel affects product mix

MetricRelationship
COGSAll customers combined
Returning Customer COGSRepeat buyer comparison
New Customer COGS Per OrderAverage cost per first-time order
New Customer Gross RevenueUsed with NC COGS to calculate margin
See all COGS metrics →