Analysis / Ecommerce and retail

Calculate ecommerce order contribution margins

Calculate order contribution from uploaded sales and cost exports, separate refunds, fees and fulfillment, and flag missing costs and loss patterns.

Bring this question into Chat

Your starting prompt.

Using [uploaded order exports] and [cost data], calculate contribution margin by order, SKU and [period]. Separate net sales, product cost, payment fees, discounts, refunds and fulfillment expenses, stating missing cost assumptions. Show margin distributions and loss making order patterns with supporting lines. Produce a reviewable margin table; do not equate contribution margin with fully allocated profit or assume a native commerce Connection.

Copy this starting point, then replace the placeholders with your own inputs.

Method and review

Keep the assumptions visible.

Reconcile orders, refunds, costs and fulfillment at a consistent grain. Use supplied exports when a native Connection is unavailable, and distinguish revenue from contribution.

For this task, check

Contribution margin excludes costs outside the agreed definition and can change when returns settle.

This starting prompt has no published worked example yet. Begin with a small sample and check the calculations before relying on the result.

Before you begin

Bring exports you are allowed to upload, or data your Workspace can already query.
Choose the reporting period and agree what each record represents.

Work with permitted files or queryable data. Verify the result against the original records.

Take the next step

Make it your investigation.

Copy the prompt above, create or open your Workspace, and paste it into Chat. Add the inputs you have permission to use and adapt the assumptions with your agent.

Start exploring

Your prompt is carried by copy and paste. Signing up does not submit it or start this work automatically.

Or start with your own agent

The setup prompt includes this public task. Your agent will help you connect when needed and use the access you approve.

Choose Claude, Codex, or Cursor—or copy the prompt to use anywhere.

All ecommerce and retail prompts