Ecommerce dashboards: revenue, conversion and margin

Ecommerce dashboards should connect sessions, orders and returns to the contribution each channel leaves behind. Revenue alone can favor a channel that consumes most of its gross profit in advertising and fulfillment.

Use a compact operating display supported by checked source totals. The ecommerce reporting method covers preparation of the detailed sales package; this example focuses on what a manager should see and do with the finished numbers.

Start with a channel decision

Consider an illustrative US home-goods retailer reviewing September 2026. Its marketing manager must decide whether paid search deserves more budget. The finance lead wants the answer after merchandise refunds, product costs and the channel's variable expenses.

The display covers only tracked online-store sales assigned to paid search or email. Sessions belong to mutually exclusive channel groups. Orders use the same channel assignment, and every illustrated order belongs to a session in the period. Other channels stay outside this example rather than being folded into a misleading company total.

Use the same time zone and reporting window for traffic and orders. Costs below are supplied amounts assigned to these channels, not estimates inferred from the traffic share. Refunds relate to the illustrated sales, and product cost is already net of approved recoveries.

The source totals behind the display

The traffic export provides sessions and sessions with purchases. The order and refund exports provide distinct orders, merchandise sales, allocated discounts and merchandise refunds. Finance supplies net product cost, fulfillment expenses, transaction fees and marketing expenses.

Orders and purchasing sessions intentionally differ. Some sessions contain multiple orders. Shopify's behavior-report documentation distinguishes sessions completing checkout from order counts and defines conversion as the share of sessions resulting in a purchase.

Refunds here exclude tax and customer shipping charges. They measure the merchandise revenue reversed, not the count of physically returned items. Shopify's sales-report documentation distinguishes physical returns from broader financial reversals; retain that distinction when labeling a returns tile. Covirage is not affiliated with Shopify.

Calculate the dashboard measures

Use these definitions consistently:

Session conversion = Sessions with purchases / Sessions

Net merchandise sales = Gross merchandise sales − Discounts − Merchandise refunds

Gross profit = Net merchandise sales − Net product cost

Channel contribution = Gross profit − Fulfillment − Transaction fees − Marketing expense

Contribution margin divides channel contribution by net merchandise sales. Refund burden divides merchandise refunds by sales after discounts, before refunds. It describes this period's dollars; it is not a physical unit-return rate or a forecast of future returns.

Conversion is displayed to two decimal places and other percentages to one. Calculations retain unrounded values.

Paid search sales are $52,000 less $2,000 less $5,000, or $45,000. After $24,000 of product cost, gross profit is $21,000. Subtract $4,000, $1,500 and $12,000 of channel expenses to reach $3,500 of contribution.

Email follows the same steps: $40,000 less $1,000 less $2,000 gives $37,000 of sales. Subtracting $18,000 of product cost gives $19,000 of gross profit; the remaining expenses leave $13,000 of contribution. The distinction between gross and contribution margin matters before calling a channel profitable.

Arrange the page around an action

Place net sales, purchasing sessions, refunds and contribution at the top. Follow with the channel table and an exception note naming the owner and next review date. A channel label should lead readers back to the supporting order and expense rows.

Here, email leaves more contribution despite lower sales. That supports investigating paid-search acquisition cost, the purchased product mix and refund reasons before increasing budget. It does not prove that moving spending to email would reproduce email's existing results: the audiences and purchase intent may differ.

Use reporting dashboards for period comparisons and exception ownership. Keep unrelated operational measures off this page unless they explain the channel decision.

Change one input: advertising cost

Suppose the paid-search invoice is $16,000 rather than $12,000. Every traffic, order, revenue and other cost input stays unchanged.

The additional $4,000 turns contribution negative while revenue and conversion remain unchanged. Across the included channels, contribution falls from $16,500 to $12,500. A sales-only display would miss the change entirely.

Checks and common pitfalls

Reconcile the dashboard sales bridge: $92,000 less $3,000 less $7,000 equals $82,000. Then $82,000 less $42,000 equals $40,000 of gross profit, and subtracting the displayed fulfillment, fee and marketing totals leaves $16,500 of contribution.

• Averaged rates. Total conversion is 900 purchasing sessions divided by 30,000 sessions. Divide totals rather than averaging channel percentages.
• Mixed attribution. Order channels and session channels need the same assignment rules before their rates can be combined.
• Incomplete costs. A late advertising invoice can reverse the apparent channel result, as the variation shows.
• Returns without context. Period refunds and original-order return cohorts answer different questions. Label the basis and avoid treating either as a cash-settlement report.

Check your ecommerce figures in Covirage

Upload a sample of your own commerce, traffic and cost files; Covirage maps the columns, and its tools compute and check the supplied channel figures. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and set up your business.

See revenue driver analysis for the supporting questions behind the channel comparison.