Track Revenue and Costs
1 hourCalculate gross revenue, platform fees, shipping costs, and COGS to determine gross profit per product.
Field context
This workflow is part of 6 niche fields
E-commerce analytics workflow to track revenue and COGS, analyze profit margins, calculate marketing ROAS, compare platform fees, and review monthly KPIs.
Calculate gross revenue, platform fees, shipping costs, and COGS to determine gross profit per product.
Calculate net and gross margins by product, channel, and time period to identify most and least profitable lines.
Measure return on ad spend (ROAS) and overall marketing ROI to optimize budget allocation across channels.
Calculate commission impact across sales channels and identify opportunities to shift volume to higher-margin platforms.
Compile monthly P&L, compare margins and ROI trends, and adjust pricing, ad spend, or product mix accordingly.
Calculate gross and net profit per product after all fees. · Attribute profit to marketing channels for ROI calculation. · Compile monthly P&L summary.
Calculate platform commission fees by sales channel. · Compare commission rates across Amazon, eBay, Etsy, and DTC.
Determine gross and net margins by product and channel. · Monitor margin compression or expansion trends.
Calculate margin changes month-over-month. · Calculate savings from shifting volume to lower-commission channels.
Calculate ROAS and marketing ROI by channel. · Track ROI trends over time.
Typical fee structures across major selling platforms.
| Platform | Referral Fee | Fulfillment | Monthly Fee |
|---|---|---|---|
| Amazon FBA | 8–15% | $3–6/unit | $0 (Individual: $0.99/item) |
| Shopify | 0% (2.9% payment) | Self-fulfill | $29–299/mo |
| Etsy | 6.5% | Self-fulfill | $0.20/listing |
| eBay | 12–15% | Varies | $0 (Store: $4.95+/mo) |
Include inbound shipping, packaging, labeling, and return processing in COGS — not just product cost. Most sellers underestimate by 15–25%.
Products that sell well but lose money are worse than products that do not sell — they consume cash flow and storage space.
Email marketing ROI averages $36–42 per $1 spent — the highest ROI channel in e-commerce. Capture emails on every order.
Connect your store to a dashboard (Shopify Analytics, Triple Whale) to avoid manual spreadsheet work every month.