Blog · Finance metrics and formulas · Consumer goods
Measure an ecommerce initiative using incremental contribution after merchandise, fulfillment, refunds and channel costs. Build a baseline comparison, calculate the return in a spreadsheet and reconcile the result to your exports.
Ecommerce ROI analysis measures the incremental profit an initiative produces relative to what the company invested. Start after discounts and refunds, deduct merchandise and order costs, and compare the result with an explicit estimate of what would have happened without the initiative. Revenue growth alone does not establish a return.
A US consumer packaged goods brand might evaluate a bundle launch, a shipping offer or a marketplace expansion. Write down the initiative, evaluation dates, customer or channel scope and expected alternative. Give finance and the ecommerce owner the same definition.
For this review, use a pretax operating-benefit measure:
Order contribution = Net sales − Merchandise cost − Fulfillment − Outbound shipping − Channel and payment fees − Return handling
Incremental contribution = Observed contribution − Contribution without the initiative
Initiative ROI = (Incremental contribution − Initiative investment) / Initiative investment
The investment denominator here is incremental initiative spending: advertising, creative work and setup. Those costs are excluded from order contribution and subtracted once in the ROI numerator. This is a stated management measure; it is not a company-wide return on assets or a discounted capital-appraisal result.
For the advertising-specific distinction, use marketing ROI versus ROAS. Keep this review focused on the economics of the whole initiative.
Bring the order and credit export, merchandise-cost report, fulfillment invoices, shipping charges, channel settlements and initiative spending ledger. Keep order identifiers, transaction dates, channel and SKU so a charge can be matched to the relevant sale.
Separate booked merchandise sales after promotional discounts from customer refunds and price credits. The IRS explanation of net sales treats sales returns and allowances as deductions from gross sales. Use that distinction to reconcile the sales bridge; apply your company's accounting policy for the reporting period.
For costs, use merchandise sold after applicable return-cost reversals. Separate inbound freight already included in merchandise cost from outbound delivery. Record fees gross of sales receipts so a settlement deposit does not masquerade as revenue.
If checkout behavior needs investigation, use ecommerce funnel analysis alongside the finance review. It explains where orders are lost without replacing the cost calculation.
Consider an illustrative US pantry-products brand reviewing a bundle initiative for July through September 2026. Finance approved an estimate for the same quarter without the initiative. The comparison assumes the same business scope and no dedicated equipment or additional inventory funding requirement.
The baseline is an assumption to test, not proof that the initiative caused the difference. Retain the assumptions about seasonality, stock availability and price changes with the workbook.
Put line labels in column A, baseline values in B and observed values in C. The sheet rows below define the formulas that follow. Refunds and costs are entered as positive deductions.
| Sheet row | Line | Baseline (USD), B | Observed (USD), C | Increment (USD), D |
|---|---|---|---|---|
| 2 | Booked merchandise sales after discounts | 400,000 | 540,000 | 140,000 |
| 3 | Customer refunds and price credits | 20,000 | 40,000 | 20,000 |
| 4 | Net sales | 380,000 | 500,000 | 120,000 |
| 5 | Merchandise cost | 190,000 | 245,000 | 55,000 |
| 6 | Pick, pack and fulfillment | 30,000 | 42,000 | 12,000 |
| 7 | Outbound shipping | 28,000 | 40,000 | 12,000 |
| 8 | Channel and payment fees | 12,000 | 17,000 | 5,000 |
| 9 | Return handling | 4,000 | 8,000 | 4,000 |
| 10 | Order contribution | 116,000 | 148,000 | 32,000 |
In Excel, enter these formulas in B4, B10, D4 and D10, respectively. Copy B4 and B10 across to column C:
=B2-B3
=B4-SUM(B5:B9)
=C4-B4
=C10-B10
For underlying order rows, suppose Orders has dates in A, channels in B and net sales in C. This formula totals the quarter's DTC net sales:
=SUMIFS(Orders!C:C,Orders!A:A,">="&DATE(2026,7,1),Orders!A:A,"<"&DATE(2026,10,1),Orders!B:B,"DTC")
Microsoft documents SUMIFS as summing values that meet multiple criteria. Keep all referenced columns aligned to the same order rows. Covirage is not affiliated with Microsoft.
The spending ledger contains:
| Cell | Initiative spending | Amount (USD) |
|---|---|---|
| B14 | Incremental advertising | 18,000 |
| B15 | Creative production | 4,000 |
| B16 | Setup work | 3,000 |
| B17 | Total investment | 25,000 |
Calculate the total investment in B17, net gain in B18 and ROI in B19, respectively:
=SUM(B14:B16)
=D10-B17
=B18/B17
The $32,000 incremental contribution less $25,000 investment leaves $7,000. ROI is $7,000 / $25,000 = 28.00%. Format B19 as a percentage; percentages here are rounded to two decimals.
Prove the contribution bridge independently. Baseline order costs total $264,000 and observed order costs total $352,000, using rows 5 through 9. Incremental costs are therefore $88,000. The $120,000 increase in net sales less $88,000 additional costs equals the same $32,000 contribution improvement.
Tie observed sales and refunds to the sales ledger. Tie merchandise cost and service charges to their reports, and reconcile unmatched settlements or invoices before interpreting the ROI. Keep an estimated late-return allowance visible rather than quietly treating unsettled orders as final.
Suppose additional partial price credits of $10,000 arrive, with no returned units and all other costs unchanged. Observed net sales fall to $490,000 and order contribution to $138,000. The incremental contribution becomes $22,000, leaving a $3,000 loss after the $25,000 initiative investment: ROI is −12.00%.
The original calculation had only $7,000 of contribution above break-even. That is the amount of unfavorable cost or revenue change it can absorb before the return reaches zero.
Use ecommerce cohort analysis for evidence about later customer behavior, and ecommerce customer experience analysis to investigate recurring service problems. Include future purchases in this ROI only when the chosen horizon and baseline support them.
Bring your order, cost and spending exports with the baseline assumptions; Covirage maps the columns, and its tools compute and check the figures while the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for consumer packaged goods brands for the business context.
ROAS compares attributed revenue with advertising spending. An ecommerce initiative review needs the profit remaining after merchandise, fulfillment, refunds and other relevant costs. Revenue growth can therefore coincide with a weak or negative initiative return, even when the advertising revenue multiple looks strong.
Yes. Use net sales after refunds and allowances, and include return handling or unrecoverable merchandise costs where relevant. Match credits to the evaluation period or clearly label an estimate for unsettled returns. Avoid subtracting a refund again when the sales export is already net.
Use an explicit estimate of results without the initiative for the same period and business scope. A comparable control group can strengthen that estimate. Prior-period results need adjustments for seasonality, prices, assortment and availability; an unadjusted before-and-after comparison does not prove incremental benefit.
Not by itself. A profit-based return can exclude the timing of inventory purchases, supplier payments and customer settlements. Prepare a separate cash schedule when funding matters, and extend the investment boundary when dedicated equipment or additional working capital is part of the proposal.