Skip to content

Dashboard templates

Retail · Sales

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.

Use this template to

  • Know what share of total sales comes from wholesale and whether it is growing or shrinking.
  • Track who hits quota and which opportunity sources close best.
  • Compare retail channel profit with wholesale orders to set dealer pricing.

7 ready-made dashboards

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

Opportunities and quota

New opportunities, win rate, closed value and quota attainment of the sales team.

  • Won amount
  • Win rate
  • Open pipeline value
  • Average sales cycle (days)
  • Results by salesperson
  • Quota attainment by team
  • Win rate by opportunity source
  • Monthly closed value by region

Profit and loss overview

Actual revenue down to profit after marketplace fees, returns and ads.

  • Net revenue
  • Contribution margin
  • Net profit after fees and ads
  • Net margin
  • From revenue to profit
  • Weekly profit after fees by channel
  • Weekly orders by channel

Sales channels

Compare channels by revenue, fees, return rate, profit and margin.

  • Profit and loss by channel
  • Return rate by channel
  • Profit after fees and ads by channel
  • Cancellation rate by channel
  • Weekly net revenue

Products

SKUs ranked by profit; loss-making SKUs in red; COGS coverage shows which SKUs have no cost yet.

  • Profit by SKU (biggest losses first)
  • Gross profit after fees by category
  • Units sold by SKU
  • Monthly COGS by SKU

Advertising

Spend by platform and campaign, platform-reported ROAS, and the gap between reported and actual revenue by channel.

  • Ad spend
  • Blended ROAS
  • Platform-reported ROAS
  • Ad-reported vs actual revenue gap
  • Ad platform reported vs actual revenue by channel
  • Campaigns
  • Spend by ad platform
  • Monthly platform ROAS by campaign

Data health

Quality test results with row numbers in the Excel file; COGS coverage and unsettled fees.

  • COGS coverage
  • Provisional fee rate
  • Data quality checks
  • COGS coverage by SKU

Ask Si as soon as the build finishes

  • “How did total sales (retail and wholesale) change compared with last month?”
  • “What is driving wholesale share this quarter?”
  • “Show average deal size by month for the last six months.”
  • “Where is average sales cycle (days) highest this month, and why?”

33 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Total sales (retail and wholesale)Net revenue of retail channels plus the value of wholesale contracts won in the period.= Net revenue + Won amountCurrency
Wholesale shareValue of won wholesale contracts divided by total sales (retail and wholesale).= Won amount / (Net revenue + Won amount)Ratio (%)
Average deal sizeWon amount divided by the number of won opportunities.= Won amount / Won opportunitiesCurrency
Average sales cycle (days)Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunitiesNumber
Lost opportunitiesNumber of opportunities lost, by close date.Count
New opportunitiesSales opportunities created in the period (by creation date), including open, won and lost ones.Count
Open pipeline valueTotal value of opportunities created in the period that are still open (neither won nor lost).Currency
Sales targetTotal sales targets of sales reps. Targets are set monthly and recorded on the first day of the month.Currency
Quota attainmentWon amount divided by sales target. Above 100% means the target is exceeded.= Won amount / Sales targetRatio (%)
Win rateWon opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities)Ratio (%)
Won amountTotal value of won opportunities, by close date.Currency
Won opportunitiesNumber of opportunities won, by close date.Count
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency
Cancellation rateCancelled orders divided by total orders.= cancelled_orders / all_ordersRatio (%)
Cost of goods soldQuantity 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 coverageShare 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_totalRatio (%)
Contribution marginNet 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 costCurrency
GMV (gross merchandise value)Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds).Currency
Net marginProfit after fees and advertising divided by net revenue.= Net profit after fees and ads / Net revenueRatio (%)
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count
Payment feesMarketplace transaction fees and payment gateway fees, allocated to lines by line revenue.Currency
Marketplace feesMarketplace commission and service fees, allocated to lines by line revenue.Currency
Ad-reported vs actual revenue gapAd-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 revenueCurrency
Provisional fee rateShare of fees (marketplace, payment, shipping) not yet settled, which may still change.= provisional_fees / (Marketplace fees + Payment fees + Seller-paid shipping cost)Ratio (%)
Return costReturn shipping cost borne by the shop. Does NOT include refunds to buyers (already deducted in net revenue).Currency
Return rateReturned orders divided by valid orders.= returned_orders / Valid ordersRatio (%)
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spendNumber
Seller-paid shipping costOutbound shipping cost paid by the shop, allocated to lines by line revenue.Currency
Units soldTotal quantity of products in the order lines of valid orders.Count

Data you need

Required

channel, product, order, order_line, opportunity

Add if you have it (unlocks more metrics)

product_cost, customer, cost, return, ad_performance_daily, sales_rep, sales_target

Available variants: Marketing agency (demo), Multi-channel online seller

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: channel, product, order, order_line, opportunity.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 7 dashboards and 33 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Retail · Sales with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes