Which products actually contribute to your marketing budget?

A single SKU, a product family, a bundle, and an order are different units. Begin at the level where costs and quantities are reliable, then aggregate deliberately. A family-level average can hide a costly large size or a frequently returned shade. A bundle’s economics cannot be understood by adding retail prices of its components.

For the marketing decision, show both contribution per unit or order and total contribution over the period. A high-margin niche item may contribute little in total because it sells rarely, while a lower-margin repeat item may be important to the business. Neither measure should erase the other.

Shopify’s profit-report documentation notes that reported product profit depends on cost information recorded at the time of sale. That makes cost coverage an essential audit field. If some variants lack cost data, the report can exclude or misrepresent part of the commercial picture rather than reveal a true product advantage.

Ask the commerce and finance owners to approve the cost source, effective dates, and treatment of changing purchase costs. Marketing should not invent costs to complete a chart. Where estimates are necessary for planning, label them and show how the decision changes across a reasonable range.

A product’s full-price margin can differ greatly from its realized margin during a promotion. Shopify’s sales documentation defines gross and net measures and adjustments; use a consistent revenue basis for the report. A promotional bestseller should not be compared with a full-price item as though both sold at their catalog prices.

Returns may arrive after the sale period. Decide whether the report is a current-period operating view or a mature order-cohort view. Both can be useful, but they answer different questions. A campaign launched yesterday does not yet have a complete returns history.

Imagine Product A generates $10,000 in net revenue from 250 units. Its approved product cost is $4,000 and allocated variable operating costs are $1,500, leaving $4,500 before marketing. Product B generates $12,000 from 200 units, with $6,500 in product cost and $2,000 in variable operating costs, leaving $3,500 before marketing.

Product B has more revenue and a higher average net selling price, but Product A contributes more under this model. That does not automatically mean all promotion should move to A. Stock, customer acquisition role, repeat behavior, and product fit still matter. The calculation simply prevents revenue from being mistaken for available marketing room.

The figures are illustrative. A real report should show the cost categories and allocation method beside the result. If shipping is charged to the customer or subsidized differently by product, represent that consistently rather than hiding it inside a generic margin percentage.

Packaging, pick-and-pack, and shipping may be incurred per order rather than per item. Allocating them by revenue, unit count, weight, or another method can change the apparent margin of a product. Choose a reasonable rule with the relevant owner and show it. The rule is a management convention, not a physical fact about every unit.

For bundles, preserve the component costs and the actual bundle revenue. If the bundle is used to acquire customers or introduce a routine, evaluate the later behavior separately rather than assigning an assumed lifetime benefit to the bundle on day one.

The same product can have different economics in the US and Europe because of price, fulfillment, duties, returns, or channel fees. A global blended margin can be unsuitable for a US advertising decision. Split the report where those differences materially affect the choice.

Also distinguish ordinary purchases, subscriptions, wholesale, and marketplace sales when they use different economics. A single average may be acceptable for an overview, but the analyst should be able to show the underlying mix. Otherwise a channel shift can look like a product-cost problem.

If a promoted item has weak contribution, investigate the cause before removing it from the plan. The issue could be discount depth, packaging cost, return behavior, or an offer that attracts the wrong customer. Some fixes belong to operations or product design rather than advertising.

If an item has attractive contribution but limited demand, a small evidence-led test may be appropriate. The margin does not create demand by itself. Pair the report with customer questions, search relevance, and creative readiness so the marketing decision reflects both economics and buyer interest.

A new product may have estimated landed cost, uncertain return behavior, and introductory fulfillment inefficiencies. Label the initial contribution view as provisional and show which inputs remain uncertain. Do not compare it with a mature bestseller’s fully reconciled economics as though both records have the same completeness.

Choose a review trigger such as receipt of the final cost invoice or completion of a reasonable returns observation period. When actual costs arrive, retain the approved planning version and explain the difference. This helps the team learn whether the original promotion decision was sensible under the information available at the time.

If a product appears unusually profitable because a cost is missing, remove it from the promotion ranking until the issue is resolved or show an explicit incomplete status. A dashboard should make that uncertainty visible before a media buyer uses it to allocate spend.

Ask for cost completeness, formulas, market scope, period maturity, and the allocation rule. Include a sample product that can be traced from order lines to the final contribution figure. The report should label estimates and avoid presenting contribution before fixed costs as company profit.

Dahna can help organize the reporting model and connect it to campaign and merchandising decisions, working with the brand’s approved finance and operations inputs. Bring the product export, cost records, return treatment, and the promotion choices under consideration.

Use these guides when the next question goes beyond the scope of this article.

Download the completed tables as a CSV, then replace the example inputs and add your evidence, owner and review date. Illustrative figures are teaching examples, not default targets.