Retail and wholesale
Company-wide sales, including retail channel revenue and wholesale contracts closed by the sales team.
- Total sales (retail and wholesale)
- Net revenue
- Won amount
- Wholesale share
- Weekly total sales
- Monthly wholesale share
Dashboard templates
A retailer with sales channels (marketplaces, website, stores) and a sales team selling wholesale to dealers. P&L by channel plus opportunities, win rate and quota attainment of the sales team.
Free plan with no time limit · No card required · Sample workspace ready in minutes
For retail businesses with a sales team selling wholesale to dealers alongside marketplaces, a website and stores. The "Retail and wholesale" dashboard adds retail net revenue to won wholesale contract value for total sales and calculates the wholesale share. The "Opportunities and quota" dashboard tracks opportunities, win rate, sales cycle and quota attainment, while the profit and loss dashboards by channel show which retail channel is most profitable. Needs channel, product, order, order line and sales opportunity data.
Company-wide sales, including retail channel revenue and wholesale contracts closed by the sales team.
New opportunities, win rate, closed value and quota attainment of the sales team.
Actual revenue down to profit after marketplace fees, returns and ads.
Compare channels by revenue, fees, return rate, profit and margin.
SKUs ranked by profit; loss-making SKUs in red; COGS coverage shows which SKUs have no cost yet.
Spend by platform and campaign, platform-reported ROAS, and the gap between reported and actual revenue by channel.
Quality test results with row numbers in the Excel file; COGS coverage and unsettled fees.
Versioned definitions, shared by dashboards, Si, reports and MCP.
| Metric | Definition | Unit |
|---|---|---|
| Total sales (retail and wholesale) | Net revenue of retail channels plus the value of wholesale contracts won in the period.= Net revenue + Won amount | Currency |
| Wholesale share | Value of won wholesale contracts divided by total sales (retail and wholesale).= Won amount / (Net revenue + Won amount) | Ratio (%) |
| Average deal size | Won amount divided by the number of won opportunities.= Won amount / Won opportunities | Currency |
| Average sales cycle (days) | Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunities | Number |
| Lost opportunities | Number of opportunities lost, by close date. | Count |
| New opportunities | Sales opportunities created in the period (by creation date), including open, won and lost ones. | Count |
| Open pipeline value | Total value of opportunities created in the period that are still open (neither won nor lost). | Currency |
| Sales target | Total sales targets of sales reps. Targets are set monthly and recorded on the first day of the month. | Currency |
| Quota attainment | Won amount divided by sales target. Above 100% means the target is exceeded.= Won amount / Sales target | Ratio (%) |
| Win rate | Won opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities) | Ratio (%) |
| Won amount | Total value of won opportunities, by close date. | Currency |
| Won opportunities | Number of opportunities won, by close date. | Count |
| Ad spend | Total advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to. | Currency |
| Average order value | Line revenue after discounts divided by valid orders.= line_net_total / Valid orders | Currency |
| Cancellation rate | Cancelled orders divided by total orders.= cancelled_orders / all_orders | Ratio (%) |
| Cost of goods sold | Quantity times unit cost on the order date (half-open validity interval). SKUs without a cost count as 0; see COGS coverage. Returned lines do not reverse their COGS. | Currency |
| COGS coverage | Share of line revenue (after discounts) coming from SKUs that have a cost. Below 100% means the profit metrics are overstated.= line_net_with_cost / line_net_total | Ratio (%) |
| Contribution margin | Net revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return cost | Currency |
| GMV (gross merchandise value) | Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds). | Currency |
| Net margin | Profit after fees and advertising divided by net revenue.= Net profit after fees and ads / Net revenue | Ratio (%) |
| Net profit after fees and ads | Net revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spend | Currency |
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| Valid orders | Orders that were not cancelled (standard status other than cancelled). | Count |
| Payment fees | Marketplace transaction fees and payment gateway fees, allocated to lines by line revenue. | Currency |
| Marketplace fees | Marketplace commission and service fees, allocated to lines by line revenue. | Currency |
| Ad-reported vs actual revenue gap | Ad-platform-reported revenue minus actual net revenue for the same channel and period. Positive means the platform reports more than reality.= ad_conversion_value - Net revenue | Currency |
| Provisional fee rate | Share of fees (marketplace, payment, shipping) not yet settled, which may still change.= provisional_fees / (Marketplace fees + Payment fees + Seller-paid shipping cost) | Ratio (%) |
| Return cost | Return shipping cost borne by the shop. Does NOT include refunds to buyers (already deducted in net revenue). | Currency |
| Return rate | Returned orders divided by valid orders.= returned_orders / Valid orders | Ratio (%) |
| Blended ROAS | Actual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spend | Number |
| Platform-reported ROAS | Ad-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spend | Number |
| Seller-paid shipping cost | Outbound shipping cost paid by the shop, allocated to lines by line revenue. | Currency |
| Units sold | Total quantity of products in the order lines of valid orders. | Count |
channel, product, order, order_line, opportunity
product_cost, customer, cost, return, ad_performance_daily, sales_rep, sales_target
Available variants: Marketing agency (demo), Multi-channel online seller
Upload an Excel file or connect a source with: channel, product, order, order_line, opportunity.
Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.
The build gives you 7 dashboards and 33 metrics; ask Si anytime.
Connectors with a setup guide that feed the entities this template needs. Excel always works.
Free plan with no time limit · No card required · Sample workspace ready in minutes