Orphex Product Profitability Review
A cost-reconciled product contribution review with net/gross return distinctions, observed break-even ratios, and bounded economic actions.
When to use
When product revenue and advertising returns need reconciliation with returns and variable costs.
Bring the right data
Use your own export, or start with the template. The fictional example shows the expected shape.
View the input columns
product_idRequired- Stable product aggregate for the matched order/advertising scope
currencyRequired- ISO currency
gross_revenueRequired- Revenue before separately listed discounts/refunds; exclude taxes under the supplied rule
discountsRequired- Discounts not already deducted in gross_revenue
refundsRequired- Refunded revenue not already deducted; same cohort/horizon
cost_of_goodsRequired- Total COGS under supplied accounting scope, net of any stated recovered stock adjustment
fulfilmentRequired- Distinct variable fulfilment costs not already included in COGS
payment_feesRequired- Distinct retained payment fees not already included in other costs
ad_spendRequired- Attributed/matched advertising cost under stated allocation, counted once
Add your business context
Supply your objectives, conversion definitions, currency, constraints, and approved brand facts once, then reuse the profile across reviews. Leave unknown values explicit.
See an example
Fictional data · an illustrative review, not a customer result.
Compare product contribution and identify misleading gross ROAS.
View the example result
Fictional example output
| Product | Net revenue | Contribution before ads | Ads | Contribution after ads | Net-revenue ROAS | Contribution break-even ROAS |
|---|---|---|---|---|---|---|
| sku-a | $8,500 | $3,500 | $2,000 | $1,500 | 4.25 | 2.4286 |
| sku-b | $5,000 | $1,250 | $1,500 | −$250 | 3.3333 | 4.00 |
| Total | $13,500 | $4,750 | $3,500 | $1,250 | 3.8571 | 2.8421 |
sku-b's gross ROAS is 6,000/1,500 = 4.00, but the settled discounts/refunds and variable costs leave −$250 after advertising. Gross return is not profit.
For sku-a, net revenue is 10,000−1,000−500 = 8,500; pre-ad contribution is 8,500−4,000−800−200 = 3,500. Net-revenue break-even ROAS is 8,500/3,500, under these cost semantics. This is variable contribution, not company net profit, and assumes the observed cost mix rather than marginal scalability.
Review sku-b's returns, cost allocation and offer economics before proposing budget cuts or price changes. No product, price, or campaign changes applied.
Before you start
Review the required context
- Supplied data with the documented task-specific columns, stable scope, and refresh/maturity context
- Business definitions and constraints relevant to the decision; see the reusable business-context reference
The method
Reconcile economic scope
Align order/acquisition cohort, product/variant, currency, tax/shipping convention, returns maturity, discounts, refunded revenue, recognized/recovered COGS, fulfilment, payment fees and advertising allocation. Identify whether revenue is already net of discounts/refunds and whether COGS already includes other expenses. Subtract each economic cost once. Keep unidentified shared advertising/overhead separate unless a documented allocation is supplied; do not distribute it arbitrarily by attractive ROAS.
View SKILL.md
Orphex Product Profitability Review
Assess product-level contribution under the user's supplied cost and revenue definitions. Do not equate attributed gross revenue with profit or assume a universal margin.
Reconcile economic scope
Align order/acquisition cohort, product/variant, currency, tax/shipping convention, returns maturity, discounts, refunded revenue, recognized/recovered COGS, fulfilment, payment fees and advertising allocation. Identify whether revenue is already net of discounts/refunds and whether COGS already includes other expenses. Subtract each economic cost once. Keep unidentified shared advertising/overhead separate unless a documented allocation is supplied; do not distribute it arbitrarily by attractive ROAS.
Use totals for the same scope and horizon. Under the explicit component contract: net revenue = gross revenue − discounts − refunds; contribution before ads = net revenue − distinct COGS − fulfilment − payment fees; contribution after ads = contribution before ads − allocated ad spend. Negative net revenue or contribution can be real; report it with its definition. A missing cost is unknown, not zero, and prevents a complete contribution claim. A gross-revenue field already net of refunds must be normalized before using the helper, with the transformation documented.
Calculate gross and net revenue ROAS with their named numerators. Contribution break-even net-revenue ROAS = net revenue / pre-ad contribution only for positive net revenue and positive pre-ad contribution under stable observed cost mix. Zero/negative contribution does not have a meaningful positive advertising break-even ratio. Missing/zero ad spend makes ROAS unavailable. These are descriptive cost identities, not marginal response forecasts or target bids.
Recommend economic checks
Rank material adverse contribution, uncertain allocations, immature returns and cost gaps. Identify whether a recommendation concerns ad allocation, merchandising, stock, pricing, returns or feed health; do not prescribe an unrequested price change. Repeat-customer value needs a separate supported cohort analysis. Report the table, explicit cost inclusions, missing overhead/future value, and a bounded next check. No company net-profit or causal incrementality claim follows from allocated contribution alone.
Portable inputs and examples
- Read the input contract when mapping a new export or checking the example's scope and definitions. Copy the header-only CSV template when preparing data; equivalent supplied exports remain acceptable.
- Read the reusable business context only for business facts or constraints this task needs. Reuse user-supplied facts with their source/date; the template contains no default targets.
- Inspect the complete fictional input with its example output when learning the output and calculation boundaries. Never use fictional values for a real account.
State whether the result is complete, partial, or blocked for the requested decision. Link material findings to actual supplied rows/sources and separate observed metrics, hypotheses, and estimates. Lead with a short business conclusion, then evidence, uncertainty, and the next measurable check. A data export or installed skill does not authorize account changes.
For the supported arithmetic only, optionally run the bundled calculator with Python 3: python3 scripts/marketing_math.py profitability < calculation.json. Read its input mapping in the input contract before preparing JSON. It reads JSON, not CSV directly. If Python or the requested method is unavailable, show a reproducible alternative calculation or mark it unsupported; do not report an uncomputed result as verified.
Source:View on GitHub Open SKILL.md