Start with Shopify
Use observed store revenue, quantities, refunds, and product cost evidence as the commerce base.
Free template
Shopify product profitability template after ad spend.
Revenue is not product profitability. Track price, discounts, refunds, COGS, variable costs, and only the advertising spend that can be defensibly connected to the product.
Respect mapping
Do not spread shared or ambiguous campaign spend across products simply to fill a spreadsheet.
Make unavailable a valid result
If cost, currency, or mapping evidence is missing, mark the profitability view incomplete instead of fabricating precision.
01
Per-product fields
Use these columns for each product and period.
- Product / variant
- Units sold
- Gross sales
- Discounts
- Refunds
- Net revenue
- COGS
- Payment/shipping/other variable costs
- Contribution before ads
- Exact compatible mapped ad spend
- Contribution after ads
- Inventory on hand
- Evidence limitation